Home » SQL & PL/SQL » SQL & PL/SQL
Please read the OraFAQ Forum Guide before posting.
Please contribute good answers to the wiki.

    Replies Views Last message
icon5.gif Cursored FOR loops, PLS-00103 compile error
12.1.0.2.0
By: thegerman on Sat, 21 March 2020
2 8664 Sun, 22 March 2020 18:27
By: thegerman
  Moving sequences from one schema to other with the next value.
12c , Solaris 10
By: daulat01 on Wed, 18 March 2020
14 14948 Sat, 21 March 2020 06:34
By: Solomon Yakobson
  XS entity with this name already exists.
Oracle form 12c
By: Shiv93 on Wed, 18 March 2020
7 14605 Thu, 19 March 2020 04:18
By: Shiv93
  ORACLE :::Is there any other way to drop the column with out uncompression table in oracle database
oracle 12c
By: sivaraman.pvi@gmail.com on Thu, 12 March 2020
6 13579 Tue, 17 March 2020 12:41
By: Bill B
  different rows in set of data (using lead or alternative)
11.2.0.1.0
By: OraFerro on Tue, 17 March 2020
3 4802 Tue, 17 March 2020 04:20
By: OraFerro
  Import CSV data from CLOB
Oracle 12c, Unix
By: Rayam69 on Fri, 06 March 2020
32 16989 Wed, 11 March 2020 09:07
By: cookiemonster
  log ORA-01013: user requested cancel of current operation tips
11g
By: vioricamilea on Wed, 22 June 2011
20 19979 Wed, 11 March 2020 08:58
By: shthed@gmail.com
  ORA-02069
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0
By: s4.ora on Tue, 10 March 2020
2 4998 Wed, 11 March 2020 08:34
By: s4.ora
  Locking issue while MATERIALIZED VIEW REFRESH
PL/SQL Release 12.1.0.2.0
By: Manoj.Gupta.91 on Fri, 06 March 2020
6 8326 Wed, 11 March 2020 07:28
By: Bill B
  MATERIALIZED VIEW REFRESH HISTORY
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
By: Manoj.Gupta.91 on Tue, 10 March 2020
1 5081 Wed, 11 March 2020 07:18
By: Bill B
  multiple inserts without Loops
By: ghostman on Tue, 10 March 2020
2 3856 Tue, 10 March 2020 06:10
By: _jum
  Analytic Function: How to Partition Hierarchical Data
By: whdyck on Mon, 09 March 2020
1 3070 Mon, 09 March 2020 13:03
By: Michel Cadot
  exit when cursor%notfound is giving buffer overflow if not being used in anonymous block (merged)
By: sfksuperman on Tue, 03 March 2020
18 11178 Thu, 05 March 2020 10:19
By: Michel Cadot
  Select statement inside IF statement for comparing a given string with records in table
By: sfksuperman on Fri, 28 February 2020
27 15461 Tue, 03 March 2020 02:43
By: cookiemonster
  convert rows to column in SQL
12C
By: NeetuMishraIsBack on Fri, 28 February 2020
1 6525 Sat, 29 February 2020 00:58
By: Michel Cadot
  embedded implicit cursors in SQL
Oracle, Win 10
By: Calvin_007 on Fri, 28 February 2020
1 5836 Sat, 29 February 2020 00:54
By: Michel Cadot
  query-assistance
Oracle 11g
By: winfire on Fri, 28 February 2020
4 5981 Fri, 28 February 2020 08:26
By: winfire
  Time Between Consecutive Locations
Oracle 12c
By: run400 on Mon, 24 February 2020
4 6070 Fri, 28 February 2020 03:21
By: _jum
  Oracle 11g Sequence(merged)
11g
By: moyida on Thu, 27 February 2020
7 5502 Thu, 27 February 2020 12:27
By: Bill B
  How to Fetch merged rows back !
By: ramya29p on Thu, 27 February 2020
2 3231 Thu, 27 February 2020 05:21
By: ramya29p
  regexp_replace (merged 2)
By: akarra on Wed, 26 February 2020
8 4928 Wed, 26 February 2020 15:04
By: akarra
  Get (and lock) first unlocked row?!
By: emirc on Mon, 16 May 2005
8 21449 Wed, 26 February 2020 06:54
By: EdStevens
  Single update to get one column value using another column value
Oracle 12c
By: sss111ind on Tue, 25 February 2020
12 6079 Tue, 25 February 2020 07:44
By: sss111ind
  Return defined column size of varchar and varchar2 data types
By: jdbeyler on Fri, 21 February 2020
3 7134 Mon, 24 February 2020 05:55
By: Bill B
  Tab Delimited
Oracle Database 11g -Oracle JDBC driver- Linux
By: enriquemans on Fri, 21 February 2020
3 6758 Sat, 22 February 2020 08:31
By: EdStevens
  Start Transactional Control in PL/SQL
Oracle Database
By: aks11 on Wed, 19 February 2020
6 6436 Fri, 21 February 2020 12:06
By: Bill B
  PLSQL: Execute Immediate is not working as expected in PLSQL anonymous block.
By: msyogi on Thu, 20 February 2020
4 6333 Thu, 20 February 2020 11:12
By: Michel Cadot
  How to export multiple blob and character data into a text file?
PL/SQL
By: Ethan Caleb on Tue, 18 February 2020
3 7089 Tue, 18 February 2020 21:32
By: BlackSwan
  How To Show Non Matching rows in oracle
Oracle 11G
By: ssyr on Sun, 16 February 2020
3 4760 Mon, 17 February 2020 07:10
By: Bill B
  AS_XLSX. how to set worksheet name
By: calacausi on Mon, 17 February 2020
4 6193 Mon, 17 February 2020 07:08
By: Bill B
  test failed: ORA-01017 invalid username / password access denied
By: syed.javid.ali.ali@gmail. on Sun, 16 February 2020
5 7696 Sun, 16 February 2020 14:56
By: EdStevens
  ORA-02085 database link AZZRE.CG44.FR connects to GZWR2.ZZ44.FR
Oracle 12.2, SLES12 SP3
By: Mat44 on Wed, 12 February 2020
8 7629 Thu, 13 February 2020 07:24
By: Solomon Yakobson
  ORA-20200: ORA-0000: normal, successful completion when executing PCRD_DF_MANAGEMENT.DF_MANAGE ORA
By: shilpanarayan94 on Wed, 12 February 2020
3 5553 Wed, 12 February 2020 08:58
By: Michel Cadot
  Simultaneous DML executions on different objects in the same session
11g and higher, any OS
By: Olexandr Siroklyn on Tue, 28 January 2020
12 9612 Mon, 10 February 2020 10:38
By: Olexandr Siroklyn
  Previous week's first and last day
Oracle 12
By: asagpariya on Thu, 06 February 2020
6 8559 Sat, 08 February 2020 10:35
By: Bill B
  Combining multiple regexp_like statements & correct regex syntax
By: mgarret40 on Mon, 03 February 2020
4 6549 Wed, 05 February 2020 01:25
By: Michel Cadot
  Delete statement to retain last 90 days of data
Oracle SQL IDE 4.0.3.16 Win2k8 Server
By: Jay76 on Fri, 31 January 2020
11 9254 Mon, 03 February 2020 06:03
By: Bill B
  ORA-12801: error signaled in parallel query server PXXX (merged 3)
oracle ,12c
By: jgjeetu on Fri, 31 January 2020
12 18728 Mon, 03 February 2020 00:19
By: jgjeetu
  Calling webservice from plsql package (merged)
Oracle12c
By: Shiv93 on Sun, 05 January 2020
5 10857 Fri, 31 January 2020 00:44
By: Shiv93
  How to download a BLOB field data to local storage (merged)
Oracle form 12c RDS
By: Shiv93 on Thu, 30 January 2020
2 4058 Thu, 30 January 2020 04:08
By: John Watson
Goto Forum:
  
Legend New Messages New Messages   No New messages No New messages   Locked (w/ unread messages) Locked (w/ unread messages)   Locked Locked   Moved to another forum Moved to another forum

Current Time: Fri Mar 29 04:43:02 CDT 2024