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
  create materialized view log with explicit constraint (merged)
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0
By: wtolentino on Mon, 13 April 2020
3 4743 Mon, 13 April 2020 14:16
By: wtolentino
  Filtering result from 2 PL/SQL UNION queries
PL/SQL 9.0
By: gbuck on Thu, 09 April 2020
1 5767 Thu, 09 April 2020 15:45
By: Michel Cadot
  Subquery returns more than one row - where clause -decode
oracle 12c
By: New50 on Wed, 08 April 2020
11 10758 Thu, 09 April 2020 14:40
By: Michel Cadot
  Adding a from () to a query made it so slow
11.2.0.1.0
By: OraFerro on Mon, 06 April 2020
6 6782 Wed, 08 April 2020 08:13
By: OraFerro
  getting finacial week number
oracle 11gr2
By: guddu_12 on Thu, 17 April 2014
15 16871 Sun, 05 April 2020 11:16
By: danielarias
  How To Add Full Email Body Text from File to CLOB Column?
Oracle 12c
By: bmccollum on Wed, 01 April 2020
1 5694 Thu, 02 April 2020 00:11
By: Michel Cadot
icon5.gif Fill in records where date missing in sequence
Oracle 12c, Querying with SQL Developer v3.2.20.10
By: sqlafterdark on Tue, 31 March 2020
1 5048 Tue, 31 March 2020 23:43
By: Michel Cadot
  Alter Regex to validate email Domain on RFC 5322 from Java to Oracle sql
Oracle 11g, windows 10
By: Nicha on Fri, 27 March 2020
2 9352 Mon, 30 March 2020 12:41
By: Nicha
  Joined two tables on one row
By: Gin min on Wed, 25 March 2020
9 12580 Thu, 26 March 2020 05:02
By: Michel Cadot
icon5.gif Cursored FOR loops, PLS-00103 compile error
12.1.0.2.0
By: thegerman on Sat, 21 March 2020
2 8984 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 15312 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 15006 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 13970 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 4986 Tue, 17 March 2020 04:20
By: OraFerro
  Import CSV data from CLOB
Oracle 12c, Unix
By: Rayam69 on Fri, 06 March 2020
32 17201 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 20176 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 5196 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 8558 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 5277 Wed, 11 March 2020 07:18
By: Bill B
  multiple inserts without Loops
By: ghostman on Tue, 10 March 2020
2 4027 Tue, 10 March 2020 06:10
By: _jum
  Analytic Function: How to Partition Hierarchical Data
By: whdyck on Mon, 09 March 2020
1 3285 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 11381 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 15659 Tue, 03 March 2020 02:43
By: cookiemonster
  convert rows to column in SQL
12C
By: NeetuMishraIsBack on Fri, 28 February 2020
1 6709 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 6015 Sat, 29 February 2020 00:54
By: Michel Cadot
  query-assistance
Oracle 11g
By: winfire on Fri, 28 February 2020
4 6135 Fri, 28 February 2020 08:26
By: winfire
  Time Between Consecutive Locations
Oracle 12c
By: run400 on Mon, 24 February 2020
4 6237 Fri, 28 February 2020 03:21
By: _jum
  Oracle 11g Sequence(merged)
11g
By: moyida on Thu, 27 February 2020
7 5653 Thu, 27 February 2020 12:27
By: Bill B
  How to Fetch merged rows back !
By: ramya29p on Thu, 27 February 2020
2 3379 Thu, 27 February 2020 05:21
By: ramya29p
  regexp_replace (merged 2)
By: akarra on Wed, 26 February 2020
8 5105 Wed, 26 February 2020 15:04
By: akarra
  Get (and lock) first unlocked row?!
By: emirc on Mon, 16 May 2005
8 21671 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 6298 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 7357 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 6935 Sat, 22 February 2020 08:31
By: EdStevens
  Start Transactional Control in PL/SQL
Oracle Database
By: aks11 on Wed, 19 February 2020
6 6607 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 6620 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 7329 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 4937 Mon, 17 February 2020 07:10
By: Bill B
  AS_XLSX. how to set worksheet name
By: calacausi on Mon, 17 February 2020
4 6401 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 7910 Sun, 16 February 2020 14:56
By: EdStevens
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: Mon May 13 17:07:41 CDT 2024