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
case By: palpali on Mon, 30 March 2015	7	3312	Tue, 31 March 2015 01:07 By: palpali
Split CLOB column to multiple columns within a row Oracle 11g By: as1986 on Thu, 19 February 2015	23	16545	Mon, 30 March 2015 23:43 By: as1986
sql 9I ,10G ,11GDIFFERENCE SQL LEVEL 9I,10G,11G By: duttatarun on Mon, 30 March 2015	7	4809	Mon, 30 March 2015 05:25 By: Michel Cadot
Query regarding Outer Join Oracle 11g , Windows 7 By: rakeshramm on Wed, 25 March 2015	9	5144	Sat, 28 March 2015 10:29 By: Kevin Meade
SQL query (merged 3) By: sunny1234 on Thu, 26 March 2015	13	4952	Fri, 27 March 2015 06:21 By: Solomon Yakobson
Converting Prompt syntax into regular sql Oracle IDE 4.0 By: haryshenoy on Thu, 26 March 2015	1	1886	Thu, 26 March 2015 12:18 By: Michel Cadot
insert statement w/o having unique constraint error By: suji6281 on Thu, 26 March 2015	3	2290	Thu, 26 March 2015 12:16 By: Michel Cadot
pl sql error oracle 11g,windows 7 By: hcdba on Thu, 26 March 2015	10	4368	Thu, 26 March 2015 10:48 By: Solomon Yakobson
Using TYPE within an SQL IN statement Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 By: Duane on Tue, 24 March 2015	19	6460	Thu, 26 March 2015 01:28 By: Michel Cadot
request for solution By: pramodnawle on Wed, 25 March 2015	3	2891	Wed, 25 March 2015 14:22 By: Littlefoot
Enforcing a particular execution plan Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: manubatham20 on Wed, 25 March 2015	3	2882	Wed, 25 March 2015 11:56 By: manubatham20
need conditional quantity insert into table oracle By: niteshtet on Tue, 24 March 2015	6	3972	Wed, 25 March 2015 06:32 By: niteshtet
Query help Oracle 11.2.0.4, Linux By: sspn2010 on Tue, 24 March 2015	4	2890	Tue, 24 March 2015 15:27 By: sspn2010
merging two queries to create a table sql By: palpali on Mon, 23 March 2015	14	6342	Tue, 24 March 2015 07:12 By: palpali
DBMS_JOB TO run every saturday starting next saturday oracle 11g Release2 By: azeem87 on Wed, 18 March 2015	6	4566	Mon, 23 March 2015 09:35 By: azeem87
synonyms Developer 6i, Databse 11G R2,window 7 ultimate By: kilimanjaro on Thu, 19 March 2015	13	6149	Sun, 22 March 2015 07:37 By: EdStevens
REGEXP_REPLACE Help NEEDED.... Oracle, 11.2.3, AIX By: eastbay_oracle on Thu, 19 March 2015	3	2277	Thu, 19 March 2015 16:59 By: eastbay_oracle
EXISTS SQL QUERY By: palpali on Thu, 19 March 2015	15	5985	Thu, 19 March 2015 14:48 By: Michel Cadot
need query based on the below requirement Oracle 10g By: vasu.bods703 on Thu, 19 March 2015	5	3419	Thu, 19 March 2015 13:34 By: joy_division
Need to identify columns not referenced in UPDATE SET clause. By: gajini on Wed, 18 March 2015	4	3000	Thu, 19 March 2015 11:05 By: EdStevens
Result in same rows plsql By: mehboob110233 on Thu, 19 March 2015	8	4726	Thu, 19 March 2015 09:24 By: Lalit Kumar B
SQL date overlapping By: sanodani on Wed, 18 March 2015	16	5956	Thu, 19 March 2015 08:45 By: Michel Cadot
Handle duplicates during direct load path in SQL LOADER By: hemantakhandare@gmail.com on Wed, 18 March 2015	5	3086	Thu, 19 March 2015 01:20 By: Michel Cadot
Optimization ideas in view creation of subselect 10g R2 x64 , windows 2008 enterprise By: clementstore on Tue, 17 March 2015	12	4681	Wed, 18 March 2015 22:15 By: clementstore
row to column convert By: jaggy on Wed, 18 March 2015	3	2071	Wed, 18 March 2015 13:17 By: Michel Cadot
PRAGMA_INLINE (Overloading) 11g By: vippysharma on Wed, 18 March 2015	2	2457	Wed, 18 March 2015 11:01 By: Solomon Yakobson
Cumulative agreegating strings Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: manubatham20 on Tue, 17 March 2015	12	4513	Wed, 18 March 2015 10:08 By: manubatham20
Query history and present table Oracle 10g By: sss111ind on Wed, 18 March 2015	8	3262	Wed, 18 March 2015 07:59 By: sss111ind
Use ALter table in PL/SQL block Oracle 11g By: vmehta on Tue, 17 March 2015	2	3385	Wed, 18 March 2015 07:58 By: Bill B
CASE in WHERE Clause sql By: palpali on Wed, 18 March 2015	3	3345	Wed, 18 March 2015 03:03 By: Michel Cadot
Adding analytic function-based column changes another column result Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production By: lewap02 on Fri, 13 March 2015	11	5536	Wed, 18 March 2015 02:45 By: Michel Cadot
OCI8 ERROR oracle 10g By: asifkhan1990.cse on Wed, 18 March 2015	1	2521	Wed, 18 March 2015 01:12 By: Michel Cadot
create dynamic view based on metadata Oracle 11gR2/12c By: ravikanth_b on Mon, 16 March 2015	7	3214	Mon, 16 March 2015 19:11 By: ravikanth_b
rank Developer 6i, Databse 11G R2,window 7 ultimate By: kilimanjaro on Wed, 04 March 2015	8	4268	Mon, 16 March 2015 15:22 By: Bill B
Why "SQL command not properly ended" error on one and not on the other? Oracle SQL By: Adam Brave on Mon, 16 March 2015	5	4307	Mon, 16 March 2015 06:49 By: Michel Cadot
having clause is working before group by , why ? oracle 10g By: jgjeetu on Mon, 16 March 2015	2	2061	Mon, 16 March 2015 06:08 By: jgjeetu
Query execution changes in oracle 11.2.0.4.5 version oracle 11.2.0.4.5 By: avineshr on Sun, 15 March 2015	14	6561	Sun, 15 March 2015 03:45 By: John Watson
Query the newest records oracle11g By: zhaoquer on Sat, 14 March 2015	3	2766	Sat, 14 March 2015 07:06 By: Michel Cadot
ORA-01427: single-row subquery returns more than one row Oracle 11g By: na.dharma@gmail.com on Fri, 13 March 2015	4	2868	Fri, 13 March 2015 11:54 By: Solomon Yakobson
2 count query results manipulation By: ketangarg86 on Thu, 12 March 2015	5	3644	Fri, 13 March 2015 07:38 By: Solomon Yakobson