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
  Calculating the Difference of Timestamp in Min, Sec
Windows 2012, 11g, 12c
By: Giles02 on Mon, 13 April 2020
9 7363 Tue, 14 April 2020 07:45
By: Michel Cadot
  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 4746 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 5776 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 10763 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 6785 Wed, 08 April 2020 08:13
By: OraFerro
  getting finacial week number
oracle 11gr2
By: guddu_12 on Thu, 17 April 2014
15 16873 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 5699 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 5051 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 9357 Mon, 30 March 2020 12:41
By: Nicha
  Joined two tables on one row
By: Gin min on Wed, 25 March 2020
9 12586 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 8988 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 15315 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 15012 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 13974 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 4991 Tue, 17 March 2020 04:20
By: OraFerro
  Import CSV data from CLOB
Oracle 12c, Unix
By: Rayam69 on Fri, 06 March 2020
32 17208 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 20181 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 5202 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 8563 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 5280 Wed, 11 March 2020 07:18
By: Bill B
  multiple inserts without Loops
By: ghostman on Tue, 10 March 2020
2 4033 Tue, 10 March 2020 06:10
By: _jum
  Analytic Function: How to Partition Hierarchical Data
By: whdyck on Mon, 09 March 2020
1 3290 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 11384 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 15663 Tue, 03 March 2020 02:43
By: cookiemonster
  convert rows to column in SQL
12C
By: NeetuMishraIsBack on Fri, 28 February 2020
1 6716 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 6020 Sat, 29 February 2020 00:54
By: Michel Cadot
  query-assistance
Oracle 11g
By: winfire on Fri, 28 February 2020
4 6141 Fri, 28 February 2020 08:26
By: winfire
  Time Between Consecutive Locations
Oracle 12c
By: run400 on Mon, 24 February 2020
4 6241 Fri, 28 February 2020 03:21
By: _jum
  Oracle 11g Sequence(merged)
11g
By: moyida on Thu, 27 February 2020
7 5656 Thu, 27 February 2020 12:27
By: Bill B
  How to Fetch merged rows back !
By: ramya29p on Thu, 27 February 2020
2 3384 Thu, 27 February 2020 05:21
By: ramya29p
  regexp_replace (merged 2)
By: akarra on Wed, 26 February 2020
8 5110 Wed, 26 February 2020 15:04
By: akarra
  Get (and lock) first unlocked row?!
By: emirc on Mon, 16 May 2005
8 21676 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 6301 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 7361 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 6940 Sat, 22 February 2020 08:31
By: EdStevens
  Start Transactional Control in PL/SQL
Oracle Database
By: aks11 on Wed, 19 February 2020
6 6613 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 6623 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 7335 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 4940 Mon, 17 February 2020 07:10
By: Bill B
  AS_XLSX. how to set worksheet name
By: calacausi on Mon, 17 February 2020
4 6405 Mon, 17 February 2020 07:08
By: Bill B
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 22:03:59 CDT 2024