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
  Announcement: How to use [code] tags and make your code easier to read
By: Michel Cadot on Thu, 01 November 2018
0 5159 Thu, 01 November 2018 14:05
By: Michel Cadot
  sticky: Row generator ( 1 2)
By: Michel Cadot on Thu, 03 January 2008
43 204651 Tue, 06 November 2018 14:17
By: Solomon Yakobson
How to create cumulative data has been moved to Forms by the moderator.
  Incorrect work of the sql query with JOIN.
Oracle, 11g, Win 7
By: orajav on Thu, 13 June 2019
18 1944 Fri, 14 June 2019 05:50
By: orajav
SQL to get the Percentage in the Seeded Report of Purchase Requisition has been moved to Business Intelligence by the moderator.
  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 2371 Thu, 13 June 2019 12:46
By: orajav
  MV Refresh On Commit
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: saipradyumn on Thu, 06 June 2019
1 1546 Thu, 13 June 2019 07:37
By: Bill B
  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 2130 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 1480 Wed, 12 June 2019 10:23
By: cookiemonster
  Backup
Oracle 11.1 , linux
By: Manishkumar on Sun, 09 June 2019
20 3813 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 4449 Tue, 11 June 2019 03:56
By: OraFerro
  Returning into clause for insert selectstatements
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: saipradyumn on Fri, 07 June 2019
5 2756 Mon, 10 June 2019 03:34
By: Michel Cadot
  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 737 Thu, 06 June 2019 06:43
By: maik2910
  Combining 3 queries into 1
Oracle11g
By: ssyr on Wed, 05 June 2019
5 608 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 1564 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 933 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 939 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 417 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 368 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 25461 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 854 Fri, 24 May 2019 08:06
By: EdStevens
  case if avec PL/SQL
By: sawssen on Wed, 22 May 2019
1 416 Thu, 23 May 2019 00:20
By: Michel Cadot
  Help in building a Query
By: spirit3d on Mon, 20 May 2019
4 577 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 402 Tue, 21 May 2019 06:37
By: Bill B
  minus query using dblink
Oracle 12
By: sivakumar121 on Sat, 18 May 2019
4 530 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 644 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 1068 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 773 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 359 Fri, 17 May 2019 14:00
By: Bill B
  month as columns
12c
By: m.abdulhaq on Sun, 12 May 2019
4 645 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 534 Wed, 15 May 2019 15:05
By: buggleboy007
  Update in EXECUTE IMMEDIATE
Oracle 11G
By: RaShi.Raj on Mon, 11 April 2016
34 3736 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 502 Tue, 14 May 2019 15:57
By: unna
  Why does my SQL not work?
By: jvanh on Tue, 14 May 2019
10 473 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 1214 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 771 Mon, 06 May 2019 06:01
By: Bill B
  parent value of xmlquery
Oracle 12C
By: hakan_8 on Fri, 03 May 2019
4 664 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 848 Thu, 02 May 2019 09:54
By: cookiemonster
  Runtime data stored in tables
By: hapr1 on Wed, 01 May 2019
1 387 Wed, 01 May 2019 18:19
By: BlackSwan
  Design Question
12c
By: ora9a on Fri, 26 April 2019
17 1269 Wed, 01 May 2019 05:47
By: ora9a
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: Tue Jun 18 06:12:00 CDT 2019