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
require output in described order oracle 11g By: jgjeetu on Sun, 21 June 2015	3	2407	Sun, 21 June 2015 08:37 By: jgjeetu
Managing the backup tables Oracle, 11g By: scorpy90 on Sat, 20 June 2015	2	2614	Sat, 20 June 2015 14:16 By: John Watson
Generate Start - End date 11.2 By: lott42_gmail on Fri, 19 June 2015	2	2547	Fri, 19 June 2015 13:42 By: lott42_gmail
'Free text' select statment Oracle 4.0.2.15.21 By: SteveShephard on Fri, 19 June 2015	2	2228	Fri, 19 June 2015 06:54 By: Michel Cadot
Split rows into columns 4.0.2.15.21 By: SteveShephard on Fri, 19 June 2015	3	2591	Fri, 19 June 2015 06:52 By: Michel Cadot
Cross tab SQL query Oracle 9i By: tarasasu on Mon, 15 June 2015	13	5599	Fri, 19 June 2015 03:23 By: pablolee
Function declartation oracle 10g By: arun888 on Fri, 19 June 2015	3	2103	Fri, 19 June 2015 02:40 By: arun888
dynamic input value passing ORACLE 10G By: arun888 on Thu, 18 June 2015	3	2166	Thu, 18 June 2015 09:47 By: Michel Cadot
PL SQL - Need to create archive table - [MERGED] By: rajivgandhiram on Tue, 16 June 2015	6	3702	Wed, 17 June 2015 01:42 By: Lalit Kumar B
Create VIEW retrieving from dynamically configured table/queries By: gtriant on Thu, 11 June 2015	20	7120	Tue, 16 June 2015 16:03 By: gtriant
How To Check Images with Zero Bytes in Size on BLOB column datatype Oracle 11.2.0.3.0 By: wtolentino on Mon, 15 June 2015	9	4235	Tue, 16 June 2015 07:20 By: wtolentino
Sysdate with time interval parameter Oracle 11i By: RADHAKAN on Mon, 15 June 2015	16	6058	Tue, 16 June 2015 03:22 By: Michel Cadot
Read a string char by char and compare Oracle 11g Solaris 11 By: apenkov on Mon, 15 June 2015	11	5302	Tue, 16 June 2015 02:06 By: apenkov
How to alter the varchar column to number datatype oracle 11i By: Jothish on Fri, 12 June 2015	25	11158	Mon, 15 June 2015 03:02 By: pablolee
Interview Question oracle 11g By: anniepeteroracle on Mon, 15 June 2015	4	3223	Mon, 15 June 2015 02:06 By: Lalit Kumar B
IBM DB2 to Oracle PLSQL Current Day and day code conversion By: pumelayurika on Fri, 12 June 2015	11	6951	Mon, 15 June 2015 00:06 By: Michel Cadot
merge columns from 2 different tables oracle 10g By: nciteamo on Fri, 12 June 2015	1	2759	Fri, 12 June 2015 06:09 By: bugfox
Duplicate Data Oracle 11g By: plsql_guy on Sat, 23 May 2015	36	12183	Fri, 12 June 2015 03:11 By: Michel Cadot
Procedure or Function Oracle 109, Windows Server / 7 By: roni_a180 on Thu, 11 June 2015	3	2685	Thu, 11 June 2015 08:08 By: cookiemonster
Difference 9i By: glmjoy on Wed, 10 June 2015	5	3011	Wed, 10 June 2015 23:59 By: Michel Cadot
What we should use for better function or procedure By: aaditya321 on Mon, 18 August 2014	10	5468	Wed, 10 June 2015 00:54 By: Michel Cadot
SQL query help By: Developer9 on Mon, 08 June 2015	8	3878	Wed, 10 June 2015 00:50 By: Michel Cadot
cumulative sum Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production By: naga.oracle on Tue, 09 June 2015	9	4705	Tue, 09 June 2015 11:53 By: naga.oracle
Fast query paging for large table Oracle 12c,Oracle Linux 6.4 By: fabi88 on Tue, 09 June 2015	3	2554	Tue, 09 June 2015 03:21 By: Michel Cadot
ORA-30036 while running a Procedure 9i By: Jaise on Mon, 08 June 2015	7	3285	Mon, 08 June 2015 14:55 By: Michel Cadot
ORA-02437: cannot validate (TAGICRM.PK_RISK_GRID) - primary key violated 11g, 11.2.0.1, window7 By: ashishkumarmahanta80 on Tue, 02 June 2015	12	10438	Mon, 08 June 2015 07:36 By: BlackSwan
SQL query help oracle 11g By: gorants on Sun, 07 June 2015	5	3044	Mon, 08 June 2015 01:40 By: Lalit Kumar B
Date range from table Oracle 11G, Windows 7 By: mach_9 on Thu, 04 June 2015	6	3442	Fri, 05 June 2015 04:42 By: Littlefoot
Invalid table alias with left join behaves differently on different versions Ver : 10.2.0.5, 11.2.0.2, 11.2.0.3, 12.1.0.1 OS : Windows, Linux By: Lalit Kumar B on Fri, 05 June 2015	3	3978	Fri, 05 June 2015 04:10 By: Lalit Kumar B
How to get recursive result Oracle 11.2.0.1.0 - 64bit, Linux By: gold_oracl on Wed, 03 June 2015	2	2298	Thu, 04 June 2015 09:10 By: gold_oracl
Show the total of records with last record 11.2.0.1.0 By: OraFerro on Thu, 04 June 2015	7	4025	Thu, 04 June 2015 05:35 By: OraFerro
compare columns in two tables and trigger something when the condn fails By: kiranrathodkr916 on Thu, 04 June 2015	1	2244	Thu, 04 June 2015 03:47 By: Lalit Kumar B
Create dummy records using Model clause with condition for date field 11.2.0.1.0 By: OraFerro on Mon, 01 June 2015	3	2743	Wed, 03 June 2015 06:15 By: OraFerro
Question on Cursor Oracle 11g Windows By: brm2015 on Tue, 02 June 2015	4	2772	Tue, 02 June 2015 08:06 By: Michel Cadot
SQL & xml By: sanodani on Tue, 02 June 2015	4	2558	Tue, 02 June 2015 06:00 By: Michel Cadot
Inserting mathematical symbol ≤ in Oracle table Oracle 11g By: Roshnie on Tue, 02 June 2015	4	5548	Tue, 02 June 2015 02:54 By: Lalit Kumar B
select first row after appying order by for multiple records oracle 11g By: knowit2015 on Mon, 01 June 2015	2	2636	Mon, 01 June 2015 11:39 By: Michel Cadot
dbms_scheduler 10g By: m.abdulhaq on Fri, 29 May 2015	24	7892	Mon, 01 June 2015 03:21 By: m.abdulhaq
Recursive Hierarchy Help By: kiekar on Thu, 21 May 2015	3	16651	Sun, 31 May 2015 13:45 By: Michel Cadot
Displaying calculated field with selected rows and Adding row according to date condition 11.2.0.1.0 By: OraFerro on Thu, 28 May 2015	5	3050	Sat, 30 May 2015 23:50 By: OraFerro