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 1885 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 2739 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 3438 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 2311 Wed, 08 April 2020 08:13
By: OraFerro
  getting finacial week number
oracle 11gr2
By: guddu_12 on Thu, 17 April 2014
15 10614 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 3071 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 2111 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 4746 Mon, 30 March 2020 12:41
By: Nicha
  Joined two tables on one row
By: Gin min on Wed, 25 March 2020
9 5756 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 3282 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 3675 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 4006 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 5751 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 1795 Tue, 17 March 2020 04:20
By: OraFerro
  Import CSV data from CLOB
Oracle 12c, Unix
By: Rayam69 on Fri, 06 March 2020
32 8898 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 15079 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 1987 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 4986 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 1906 Wed, 11 March 2020 07:18
By: Bill B
  multiple inserts without Loops
By: ghostman on Tue, 10 March 2020
2 1446 Tue, 10 March 2020 06:10
By: _jum
  Analytic Function: How to Partition Hierarchical Data
By: whdyck on Mon, 09 March 2020
1 1064 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 5003 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 6313 Tue, 03 March 2020 02:43
By: cookiemonster
  convert rows to column in SQL
12C
By: NeetuMishraIsBack on Fri, 28 February 2020
1 3661 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 3414 Sat, 29 February 2020 00:54
By: Michel Cadot
  query-assistance
Oracle 11g
By: winfire on Fri, 28 February 2020
4 3428 Fri, 28 February 2020 08:26
By: winfire
  Time Between Consecutive Locations
Oracle 12c
By: run400 on Mon, 24 February 2020
4 3207 Fri, 28 February 2020 03:21
By: _jum
  Oracle 11g Sequence(merged)
11g
By: moyida on Thu, 27 February 2020
7 1922 Thu, 27 February 2020 12:27
By: Bill B
  How to Fetch merged rows back !
By: ramya29p on Thu, 27 February 2020
2 1299 Thu, 27 February 2020 05:21
By: ramya29p
  regexp_replace (merged 2)
By: akarra on Wed, 26 February 2020
8 1991 Wed, 26 February 2020 15:04
By: akarra
  Get (and lock) first unlocked row?!
By: emirc on Mon, 16 May 2005
8 16626 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 1892 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 4227 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 4086 Sat, 22 February 2020 08:31
By: EdStevens
  Start Transactional Control in PL/SQL
Oracle Database
By: aks11 on Wed, 19 February 2020
6 3454 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 2269 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 2694 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 1887 Mon, 17 February 2020 07:10
By: Bill B
  AS_XLSX. how to set worksheet name
By: calacausi on Mon, 17 February 2020
4 2563 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 1970 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: Fri Mar 05 12:35:47 CST 2021