OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL

Please read the OraFAQ Forum Guide before posting.

Please contribute good answers to the wiki.

Show: Today's Messages :: Unanswered Messages :: Polls :: Message Navigator

Topic	Replies	Views	Last message
Leading zeros in a spool file By: Mike Bentley on Wed, 20 December 2006	6	11879	Mon, 29 July 2019 09:00 By: Bill B
Load multiline data in table using sql loader Oracle 12c By: adfire05 on Mon, 15 July 2019	14	11877	Fri, 26 July 2019 12:31 By: adfire05
Select query took too long to execute on one schema but very little time on another scema oracle 11 g r2 RAC of 2 nodes, solaris 10 and ASM By: janakors on Wed, 24 July 2019	16	8372	Fri, 26 July 2019 07:42 By: Michel Cadot
How to use sysdate as a column header Oracle 11g By: chintan.patel on Wed, 24 July 2019	5	5488	Thu, 25 July 2019 07:39 By: Solomon Yakobson
Case insensitive in oracle 12c RDBMS 12.2..0.1 on linux By: evoradba on Wed, 24 July 2019	1	4067	Wed, 24 July 2019 14:16 By: Michel Cadot
How to get the file name from directory Oracle 10g By: sss111ind on Wed, 12 December 2012	15	16534	Mon, 22 July 2019 07:52 By: EdStevens
ALTER INDEX To Add the Extra columns Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: saipradyumn on Fri, 12 July 2019	5	5144	Thu, 18 July 2019 14:08 By: Lalit Kumar B
Sending table data in HTML format through PL/SQL Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production By: NewLife on Fri, 11 July 2008	17	123176	Tue, 16 July 2019 07:51 By: cookiemonster
MV Refresh On Commit Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: saipradyumn on Thu, 06 June 2019	2	6301	Mon, 15 July 2019 00:39 By: saipradyumn
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	6	9496	Mon, 15 July 2019 00:26 By: saipradyumn
Different Values of RAWTOHEX in Oracle 12c and 11g Oracle 12.1.0.2.0 and Oracle 11.2.0.1.0 Both Enterprise Editions By: Manoj.Gupta.91 on Fri, 12 July 2019	3	4810	Fri, 12 July 2019 10:31 By: Michel Cadot
MAX(DECODE Oracle 8i, Windows ver 6.1 By: kumarvk on Mon, 08 July 2019	7	6373	Thu, 11 July 2019 06:03 By: cookiemonster
Trying to Report on Date Periods within a table Oracle 12C By: mvs2019 on Sat, 06 July 2019	6	6534	Sun, 07 July 2019 20:48 By: mvs2019
Automatic abropting the long running job Oracle 12c By: sss111ind on Wed, 03 July 2019	8	9498	Sat, 06 July 2019 07:28 By: BlackSwan
How to Create variable out of Table Type Variable! By: ramya29p on Mon, 24 June 2019	7	8378	Mon, 24 June 2019 12:38 By: BlackSwan
Incorrect work of the sql query with JOIN. Oracle, 11g, Win 7 By: orajav on Thu, 13 June 2019	18	10199	Fri, 14 June 2019 05:50 By: orajav
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	13714	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	7353	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	8765	Wed, 12 June 2019 10:23 By: cookiemonster
Backup Oracle 11.1 , linux By: Manishkumar on Sun, 09 June 2019	20	10979	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	13784	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	7838	Thu, 06 June 2019 06:43 By: maik2910
Combining 3 queries into 1 Oracle11g By: ssyr on Wed, 05 June 2019	5	5372	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	5095	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	5800	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	5186	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	3950	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	4824	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	38813	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	6113	Fri, 24 May 2019 08:06 By: EdStevens
case if avec PL/SQL By: sawssen on Wed, 22 May 2019	1	4222	Thu, 23 May 2019 00:20 By: Michel Cadot
Help in building a Query By: spirit3d on Mon, 20 May 2019	4	6151	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	3895	Tue, 21 May 2019 06:37 By: Bill B
minus query using dblink Oracle 12 By: sivakumar121 on Sat, 18 May 2019	4	5656	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	9527	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	8294	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	9036	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	4102	Fri, 17 May 2019 14:00 By: Bill B
month as columns 12c By: m.abdulhaq on Sun, 12 May 2019	4	4225	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	4005	Wed, 15 May 2019 15:05 By: buggleboy007

Pages (1271): [ « ‹ 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 › »]

Goto Forum:

[ Syndicate this forum (XML) ] [

]

Legend

New Messages

No New messages

Locked (w/ unread messages) Locked

Locked

Moved to another forum

Current Time: Thu Apr 25 00:07:32 CDT 2024