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
  Using the Sql query to find employees who were recruited on the same day or on neighboring days.
Oracle, 11g, Win 7
By: orajav on Wed, 12 June 2019
21 9033 Thu, 13 June 2019 12:46
By: orajav
  How to pass input parameter(Inside a procedure) with more than 4000 characters as comma separated va
oracle 11g
By: Piranava on Mon, 10 June 2019
3 4800 Thu, 13 June 2019 07:24
By: Bill B
  How to build a query that gets its values from a file
Oracle SQL Developer Version 4.0.1.14 / windows 7.0
By: hartyshow@yahoo.fr on Tue, 11 June 2019
10 5907 Wed, 12 June 2019 10:23
By: cookiemonster
  Backup
Oracle 11.1 , linux
By: Manishkumar on Sun, 09 June 2019
20 7415 Tue, 11 June 2019 12:35
By: Bill B
  Aggregate operation on array
11.2.0.1.0
By: OraFerro on Thu, 30 May 2019
20 9510 Tue, 11 June 2019 03:56
By: OraFerro
  PLS-00306: wrong number or types of arguments in call to 'FOPEN' (CM merged 2)
Oracle 11GR2
By: maik2910 on Wed, 05 June 2019
4 4709 Thu, 06 June 2019 06:43
By: maik2910
  Combining 3 queries into 1
Oracle11g
By: ssyr on Wed, 05 June 2019
5 3252 Wed, 05 June 2019 11:15
By: Bill B
  Approximate 50MB files per day to be saved in Oracle Database
Oracle 11gR2
By: srinivas.k2005 on Thu, 30 May 2019
1 3595 Mon, 03 June 2019 12:31
By: Bill B
  select START_TIME = TO_DATE returns 0
RDBMS 12.2..0.1 on linux
By: evoradba on Wed, 29 May 2019
5 3909 Mon, 03 June 2019 11:01
By: Bill B
  How to write SQL Query to get desire output
oracle 12c
By: shawaj on Fri, 31 May 2019
3 3786 Sun, 02 June 2019 23:38
By: shawaj
  varchar2 byte or char semantics
db any version
By: John Watson on Wed, 29 May 2019
2 2458 Wed, 29 May 2019 12:19
By: John Watson
  json filter unusual behaviour
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0
By: sss111ind on Wed, 29 May 2019
3 2903 Wed, 29 May 2019 07:48
By: cookiemonster
  can we call an sql script from the code of a stored procedure
By: santosh_only on Thu, 25 May 2006
28 32176 Mon, 27 May 2019 04:24
By: William Robertson
  How to get all child records from a table with multiple self referential integrity constraints? (merged 3)
11g
By: rrcr on Thu, 23 May 2019
8 4307 Fri, 24 May 2019 08:06
By: EdStevens
  case if avec PL/SQL
By: sawssen on Wed, 22 May 2019
1 2654 Thu, 23 May 2019 00:20
By: Michel Cadot
  Help in building a Query
By: spirit3d on Mon, 20 May 2019
4 3489 Tue, 21 May 2019 06:50
By: Bill B
  Sql query taking long time to execut
By: haider_1pk on Tue, 21 May 2019
2 2295 Tue, 21 May 2019 06:37
By: Bill B
  minus query using dblink
Oracle 12
By: sivakumar121 on Sat, 18 May 2019
4 2925 Mon, 20 May 2019 11:50
By: Bill B
  Loop after fetch on generic SYS_REFCURSOR
11.2.0.1.0
By: OraFerro on Sun, 19 May 2019
9 4196 Mon, 20 May 2019 11:47
By: Bill B
  Error: ORA-00980: synonym translation is no longer valid
By: abs on Thu, 09 May 2019
5 4824 Mon, 20 May 2019 01:09
By: sandycullen
  Disable FND_FILE.PUT_LINE(FND_FILE.LOG
12.0.1.2
By: vaibhav15211 on Thu, 16 May 2019
8 4360 Sat, 18 May 2019 00:33
By: Michel Cadot
  write to the file from PL SQL
oracle 11
By: ykozhevnikov on Fri, 17 May 2019
3 2309 Fri, 17 May 2019 14:00
By: Bill B
  month as columns
12c
By: m.abdulhaq on Sun, 12 May 2019
4 2640 Thu, 16 May 2019 01:34
By: m.abdulhaq
  How to get or concatenate a value from inner most query
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0, Windows 10 Professional
By: buggleboy007 on Tue, 14 May 2019
2 2385 Wed, 15 May 2019 15:05
By: buggleboy007
  Update in EXECUTE IMMEDIATE
Oracle 11G
By: RaShi.Raj on Mon, 11 April 2016
34 9370 Wed, 15 May 2019 12:39
By: cookiemonster
  Extract clob xml data to get node value
Oracle RDBMS, 12.1, Windows
By: unna on Mon, 13 May 2019
5 3887 Tue, 14 May 2019 15:57
By: unna
  Why does my SQL not work?
By: jvanh on Tue, 14 May 2019
10 2861 Tue, 14 May 2019 13:39
By: Solomon Yakobson
  Package transfer from one to other oracle database
Oracle database 12.2 on Oracle Linux 7
By: armait on Tue, 07 May 2019
30 4988 Wed, 08 May 2019 09:42
By: Michel Cadot
  How to remove line breaks and put it in excel
Oracle11g
By: ssyr on Thu, 02 May 2019
6 2897 Mon, 06 May 2019 06:01
By: Bill B
  parent value of xmlquery
Oracle 12C
By: hakan_8 on Fri, 03 May 2019
4 2729 Fri, 03 May 2019 10:07
By: _jum
  ORA-00933: SQL command not properly ended
Oracle Live SQL
By: davethewelder on Wed, 01 May 2019
8 5261 Thu, 02 May 2019 09:54
By: cookiemonster
  Runtime data stored in tables
By: hapr1 on Wed, 01 May 2019
1 1932 Wed, 01 May 2019 18:19
By: BlackSwan
  Converting returned rows into columns
Oracle 11
By: ssmith001 on Tue, 23 April 2019
3 2630 Sun, 28 April 2019 06:26
By: Satheeshkumar.P
  Inserting %RowType objects "faster"
11g
By: andrew-mack on Tue, 23 April 2019
1 2167 Tue, 23 April 2019 14:12
By: Michel Cadot
  Query taking 40 hours to execute
SQL developer
By: mjpatil on Mon, 22 April 2019
10 3332 Tue, 23 April 2019 04:11
By: cookiemonster
  pl/sql procedure compile error PLS-00103
11.2.0.4
By: calgary2019 on Mon, 22 April 2019
2 2738 Mon, 22 April 2019 21:30
By: BlackSwan
  optimizer_feature_enable Hint
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: saipradyumn on Mon, 22 April 2019
6 2359 Mon, 22 April 2019 10:24
By: Bill B
  update with subqueries possibilty
By: shahzad-ul-hasan on Mon, 22 April 2019
2 1912 Mon, 22 April 2019 06:08
By: Solomon Yakobson
  update collection of object type using update statement
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: fachoch@gmail.com on Fri, 19 April 2019
4 2606 Sat, 20 April 2019 09:47
By: Solomon Yakobson
  json fetching using JSON_TABLE
Oracle 12c
By: sss111ind on Thu, 18 April 2019
6 2725 Sat, 20 April 2019 08:24
By: sss111ind
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 Apr 16 09:18:58 CDT 2021