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
Reference Partitioning Oracle 11g By: srinivas.k2005 on Thu, 12 March 2015	2	2290	Fri, 13 March 2015 02:53 By: srinivas.k2005
How to Exclude Locked Rows from Select 11.2.0.3.0 By: supiash on Thu, 12 March 2015	11	12695	Thu, 12 March 2015 20:17 By: cookiemonster
Dynamic SQL - How to convert a varchar2 variable to use as a column name in a select statement Oracle SQL By: Adam Brave on Wed, 11 March 2015	13	6983	Thu, 12 March 2015 10:04 By: gazzag
NO COPY parameters By: ppatel87 on Tue, 10 March 2015	5	3780	Wed, 11 March 2015 20:33 By: Kevin Meade
String Compress 11G By: Yuvraaj on Tue, 03 March 2015	11	7095	Wed, 11 March 2015 07:26 By: gazzag
cursor and loop oracle10g By: asifkhan1990.cse on Mon, 09 March 2015	7	4249	Wed, 11 March 2015 05:19 By: Michel Cadot
Complex comparision query 10g By: m.abdulhaq on Tue, 10 March 2015	6	3175	Wed, 11 March 2015 00:08 By: m.abdulhaq
How to remove the NULL values from SELECT clause By: samiran_cts on Mon, 09 March 2015	16	6513	Tue, 10 March 2015 05:25 By: samiran_cts
How to restrict the inserting a record through a oracle trigger oracle 10g By: shivas1177 on Sat, 07 March 2015	17	8110	Mon, 09 March 2015 04:10 By: Michel Cadot
SQLPLUS PLS-00103 Encountered 'INSERT' By: MiraclePlease on Thu, 05 March 2015	35	25455	Sat, 07 March 2015 18:50 By: MiraclePlease
How to perform a checksum to a table? Oracle SQL 11 By: Adam Brave on Fri, 06 March 2015	3	7353	Sat, 07 March 2015 16:04 By: EdStevens
Datapump error inside SQL dev 11.2.0.1 By: oradba888 on Sat, 07 March 2015	4	3786	Sat, 07 March 2015 15:33 By: BlackSwan
Foreign Keys without supporting index By: Kevin Meade on Thu, 05 March 2015	6	5565	Sat, 07 March 2015 14:58 By: Solomon Yakobson
rowid and index oracle 10g By: asifkhan1990.cse on Thu, 05 March 2015	3	2568	Sat, 07 March 2015 01:58 By: asifkhan1990.cse
How to use package dbms_sqlhash without privileges? By: Adam Brave on Fri, 06 March 2015	4	7955	Sat, 07 March 2015 01:48 By: John Watson
datatype conversion --- INTERVAL DAY(9) TO SECOND(6) ---> HH24:MI Oracle 11.2.0.4/ Redhad 6.3 By: sbmk_design on Fri, 06 March 2015	1	2921	Fri, 06 March 2015 06:43 By: Solomon Yakobson
Happy 2015 my dear friends! :D Oracle form 6i - Oracle 11G By: xebec on Thu, 05 March 2015	1	1766	Thu, 05 March 2015 12:00 By: Michel Cadot
Writing a Hierarchical Query without using the connect by prior Oracle By: sachinj on Wed, 04 March 2015	8	4161	Thu, 05 March 2015 07:38 By: Michel Cadot
Which system table I can check these grants available in my database or not? Oracle 11g By: na.dharma@gmail.com on Thu, 05 March 2015	5	3030	Thu, 05 March 2015 06:24 By: Roachcoach
synonyms parameter Developer 6i, Databse 11G R2,window 7 ultimate By: kilimanjaro on Wed, 04 March 2015	4	2754	Wed, 04 March 2015 13:52 By: Michel Cadot
complete refresh of materialized view works fine, but non-complete doesn't Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: ecivgamer on Wed, 04 March 2015	0	3036	Wed, 04 March 2015 13:05 By: ecivgamer
Varray to Columns with defaults By: bharathram on Wed, 04 March 2015	7	2944	Wed, 04 March 2015 11:22 By: Michel Cadot
Regexp_Substr Oracle 10g By: Xandot on Wed, 04 March 2015	4	2590	Wed, 04 March 2015 08:23 By: Xandot
Adding a row based on a value By: system243trd on Tue, 03 March 2015	8	3683	Wed, 04 March 2015 00:44 By: Michel Cadot
Fetching table sql inside code Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: manubatham20 on Mon, 02 March 2015	4	3230	Tue, 03 March 2015 11:42 By: manubatham20
Creating a salary report. Having trouble calculating previous salary. Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production By: rappaj on Fri, 27 February 2015	12	6130	Tue, 03 March 2015 03:45 By: cookiemonster
Storing varying number of columns in table Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: manubatham20 on Tue, 24 February 2015	28	10441	Mon, 02 March 2015 22:46 By: BlackSwan
How to get the connect string from the data base Oracle 11g By: saipradyumn on Mon, 02 March 2015	9	4721	Mon, 02 March 2015 07:10 By: Michel Cadot
SQL or PL/SQL method required to fill up the values based on other table values 10.2.0.1.0 By: bluetooth420 on Sat, 28 February 2015	11	5607	Sun, 01 March 2015 12:12 By: bluetooth420
Need to calculate a Set No. from a Data set Oracle Database, 10g Rel.2, Windows-7 By: mazam on Wed, 25 February 2015	14	5376	Sat, 28 February 2015 22:32 By: mazam
need the out put based on max date By: mist598 on Fri, 27 February 2015	12	4639	Fri, 27 February 2015 08:34 By: BlackSwan
how to return a row based on count using multiple tables SQL Query By: suji6281 on Thu, 26 February 2015	7	3080	Thu, 26 February 2015 11:29 By: suji6281
Using oracle object oracle 11g By: manns on Wed, 18 February 2015	14	5795	Thu, 26 February 2015 10:11 By: manns
Nested table as in parameter 11g By: manns on Wed, 18 February 2015	6	3018	Thu, 26 February 2015 10:09 By: manns
How do I use SQL column values as column names 11.2.0.4.0 By: grpatwari on Wed, 25 February 2015	3	2619	Thu, 26 February 2015 05:51 By: Lalit Kumar B
Order by with WITH clause Oracle 10g By: sss111ind on Thu, 26 February 2015	3	2283	Thu, 26 February 2015 05:31 By: sss111ind
How to handle unknown number of variables By: Nuggit on Thu, 19 February 2015	14	6054	Thu, 26 February 2015 02:34 By: mnitu
creation of records with respect to the delimited data from a column of base table By: saralay on Tue, 24 February 2015	5	2943	Wed, 25 February 2015 07:31 By: Kevin Meade
Oracle dbms scheduler Oracle 11g By: veeraiahmannem on Tue, 24 February 2015	10	4397	Wed, 25 February 2015 07:13 By: sss111ind
using function in select statement giving same value ( 1 2) By: mist598 on Tue, 24 February 2015	41	13215	Tue, 24 February 2015 09:11 By: BlackSwan