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
Include if else in sql statement By: hypesslearner on Mon, 20 July 2015	22	8049	Thu, 30 July 2015 16:07 By: Bill B
NUMERIC DENOMINATION SQL NAV 6 By: rukku2015 on Sun, 26 July 2015	2	2732	Thu, 30 July 2015 08:12 By: Solomon Yakobson
Need a query to get the ouput in an expected format By: nyaduguru on Wed, 29 July 2015	5	3509	Thu, 30 July 2015 02:11 By: Lalit Kumar B
Joining By: Nasir.azeem on Wed, 29 July 2015	3	2625	Wed, 29 July 2015 09:40 By: LKBrwn_DBA
Max on Sum By: zoe2003 on Mon, 20 April 2015	18	7459	Wed, 29 July 2015 02:45 By: cookiemonster
concatenate the values in the o/p By: mist598 on Mon, 27 July 2015	13	6349	Mon, 27 July 2015 06:09 By: Lalit Kumar B
query taking lot of time to execute ORACLE 11g By: manoj12 on Mon, 20 July 2015	18	8661	Mon, 27 July 2015 05:42 By: pablolee
Update to_char(date,'YYYY') oracle 10g By: nciteamo on Sun, 26 July 2015	3	7060	Mon, 27 July 2015 02:06 By: nciteamo
Split column to rows in Oracle Sql By: vspn on Wed, 22 July 2015	10	16140	Mon, 27 July 2015 01:25 By: Michel Cadot
History Tables Search Criteria windows By: oraranjangmailcom on Thu, 23 July 2015	7	3727	Mon, 27 July 2015 00:19 By: Michel Cadot
ORA-01732: data manipulation operation not legal on this view By: Ashu_26 on Sun, 26 July 2015	6	72418	Sun, 26 July 2015 02:48 By: Michel Cadot
Rewriting a sql with NOT to avoid the NOT and OR clause Oracle 11.2.0.5 By: orausern on Sat, 25 July 2015	3	2467	Sat, 25 July 2015 14:27 By: Michel Cadot
Transpose columns Oracle 11g By: rohit_shinez on Thu, 23 July 2015	1	2729	Fri, 24 July 2015 10:40 By: LKBrwn_DBA
SUM & Cursor Oracle Database 11.2.0.1; Centos By: nqtrung on Fri, 24 July 2015	4	5427	Fri, 24 July 2015 01:57 By: nqtrung
how to trapping error in SQL using SYS.DBMS_XMLGEN oracle 11g redhat By: Freewilly3d on Thu, 23 July 2015	4	5129	Thu, 23 July 2015 10:55 By: Lalit Kumar B
how to clear the output data using utl_file? By: mist598 on Tue, 21 July 2015	12	5200	Thu, 23 July 2015 05:43 By: mist598
Like in Order by Oracle 11g By: Xandot on Tue, 21 July 2015	7	3530	Wed, 22 July 2015 13:59 By: Bill B
Covert unique string to unique number Oracle 10 By: brown_zzz on Wed, 22 July 2015	4	3248	Wed, 22 July 2015 12:42 By: John Watson
Oracle trigger name and after end of the trigger name if mismatch, trigger is compiled and no error. Oracle 11g : bug By: victoryhendry on Tue, 21 July 2015	5	2945	Wed, 22 July 2015 05:01 By: gazzag
all_scheduler_job_run_details session_id column Oracle 11g By: dag1ngapr1nce on Tue, 21 July 2015	15	6119	Tue, 21 July 2015 09:27 By: dag1ngapr1nce
German Character Set Oracle 11.2.0.1, RHEL By: suddhasatwa_oracle on Tue, 21 July 2015	2	2272	Tue, 21 July 2015 08:26 By: mnitu
Creating SQL String Oracle 11g By: Xandot on Mon, 20 July 2015	8	4209	Tue, 21 July 2015 07:52 By: Michel Cadot
Issue with Number Conversion !! Oracle 11.2.0.1, RHEL By: suddhasatwa_oracle on Mon, 06 July 2015	5	3968	Tue, 21 July 2015 04:02 By: suddhasatwa_oracle
Bulk collect limit on what basis we will keep By: sasank54 on Mon, 20 July 2015	2	2126	Tue, 21 July 2015 02:06 By: Michel Cadot
linking gv$sql and gv$session 11g By: dag1ngapr1nce on Thu, 16 July 2015	14	9242	Mon, 20 July 2015 08:46 By: dag1ngapr1nce
Error with Delete Trigger Oracle By: mattfriend on Sun, 19 July 2015	7	3792	Mon, 20 July 2015 07:29 By: mattfriend
How to Split the Records Oracle 10g By: rahulsf on Mon, 20 July 2015	3	1964	Mon, 20 July 2015 04:53 By: Michel Cadot
procedure error ger end of file By: naga_raju on Sat, 18 July 2015	2	3278	Sat, 18 July 2015 05:09 By: flyboy
copy one table to another table hp unix By: arun888 on Fri, 12 June 2015	29	11065	Sat, 18 July 2015 02:39 By: pablolee
25% lowest sal Oracle, Oracle Database 11g Express Edition Release 11.2.0.2.0 ,Win 7 Pro By: shumail on Wed, 15 July 2015	15	5826	Fri, 17 July 2015 17:05 By: shumail
Wrong results with combination of Boolean, Left Join and To_Char Oracle 12c, Windows Server 2012 By: RFoersterj on Wed, 08 July 2015	8	4205	Fri, 17 July 2015 12:11 By: RFoersterj
How to retrieve parent and child in different columns when they exist in a single column. Db2 9.7 By: ankita.anand on Thu, 16 July 2015	16	6425	Thu, 16 July 2015 08:26 By: ankita.anand
Extraction from BLOB data type Oracle 11g, Linux By: ANILKUYI on Thu, 16 July 2015	1	2841	Thu, 16 July 2015 01:17 By: Lalit Kumar B
match/merge steps win7 32 bit / owb 11g r2 By: freestyle on Wed, 08 July 2015	25	10986	Wed, 15 July 2015 06:18 By: freestyle
Merge using row order 11.2.0.1.0 By: OraFerro on Tue, 14 July 2015	3	2764	Wed, 15 July 2015 00:02 By: Michel Cadot
Same serial for a group Oracle 11g By: vspn on Mon, 06 July 2015	30	10372	Tue, 14 July 2015 23:59 By: Michel Cadot
Disabling unique constraints and data warehousing query By: GusGF on Tue, 14 July 2015	5	3246	Tue, 14 July 2015 05:10 By: GusGF
Rowcount Oracle 11g By: P1Oracle on Mon, 13 July 2015	9	4966	Tue, 14 July 2015 04:48 By: Michel Cadot
Select Query based on closed / reopened flag By: simramkumar on Mon, 13 July 2015	5	3589	Mon, 13 July 2015 04:50 By: Michel Cadot
To tune a PL/SQL block 12c, 11g By: 13478 on Sun, 12 July 2015	6	3917	Mon, 13 July 2015 03:27 By: cookiemonster