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
Pagination Oracle 12 C By: satya_ora on Sun, 22 April 2018	3	2840	Mon, 23 April 2018 06:42 By: Solomon Yakobson
Handle return empty cursor in SP output parameter 11.0.2.10 By: OraFerro on Mon, 16 April 2018	9	4980	Mon, 23 April 2018 04:54 By: OraFerro
Polish Characters are missing through the SQLPLUS Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: saipradyumn on Wed, 18 April 2018	2	3410	Mon, 23 April 2018 04:44 By: saipradyumn
Need Help In Dates sql Oraccle By: Djpats on Sat, 21 April 2018	3	2717	Sat, 21 April 2018 20:20 By: Solomon Yakobson
SQL rollup count every day By: dinavahi.saradhi@gmail.co on Thu, 19 April 2018	1	2783	Thu, 19 April 2018 10:43 By: BlackSwan
Dropping a Primary Key constraint Oracle Database 11g Enterprise Edition Release 11.2.0.4.0, Windows 10 Professional By: buggleboy007 on Mon, 16 April 2018	15	4866	Wed, 18 April 2018 10:22 By: buggleboy007
modification date for package SP 11.0.2.10 By: OraFerro on Mon, 16 April 2018	4	2729	Tue, 17 April 2018 23:55 By: OraFerro
Please help for resolving error for PIPELINED table function call Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production By: msol25 on Mon, 16 April 2018	2	2823	Mon, 16 April 2018 05:51 By: msol25
Need Help In Plsql Procedure Plsql By: Djpats on Sat, 14 April 2018	3	3356	Mon, 16 April 2018 03:23 By: cookiemonster
divide string into multiple parts By: suji6281 on Sat, 14 April 2018	13	6971	Mon, 16 April 2018 01:46 By: _jum
Problem in adding Html code in PL/SQL procedure By: Djpats on Sat, 14 April 2018	3	3574	Mon, 16 April 2018 00:34 By: Djpats
multiple selects after with clauses By: dinavahi.saradhi@gmail.co on Thu, 12 April 2018	3	2949	Fri, 13 April 2018 00:10 By: Barbara Boehmer
group timestamp column hourly By: dinavahi.saradhi@gmail.co on Wed, 11 April 2018	3	2711	Wed, 11 April 2018 13:00 By: Michel Cadot
365 days always oracle 11g, linux By: hisham99 on Sun, 08 April 2018	14	7006	Wed, 11 April 2018 09:41 By: JPBoileau
ORA-14097: column type or size mismatch in ALTER TABLE EXCHANGE PARTITION Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: saipradyumn on Sat, 07 April 2018	7	4623	Wed, 11 April 2018 09:14 By: saipradyumn
Oracle 12C error tracing and debugging issue (merged 2) By: ImSandip on Mon, 09 April 2018	5	3802	Mon, 09 April 2018 09:42 By: BlackSwan
Spell out numbers to words By: Cyrille PETIT on Thu, 14 March 2002	17	16431	Fri, 06 April 2018 12:12 By: Solomon Yakobson
Answer the query Oracle 11g Query By: Lokesh A on Thu, 05 April 2018	2	2647	Fri, 06 April 2018 08:04 By: joy_division
UNUSABLE INDEX on Partition table Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: saipradyumn on Tue, 03 April 2018	3	3066	Tue, 03 April 2018 08:52 By: saipradyumn
Resource allocation problem Oracle 12c- 12.2.0.1.0 By: suneeshvr on Mon, 02 April 2018	5	3296	Mon, 02 April 2018 21:11 By: suneeshvr
Administering queue Oracle 11.2.0.3, AIX By: arijit2004 on Fri, 30 March 2018	13	4556	Sat, 31 March 2018 04:53 By: arijit2004
getting error "table table1 is mutating, trigger/function may no" on executing trigger ORacle 11g By: gold14388 on Thu, 29 March 2018	8	4786	Fri, 30 March 2018 10:59 By: BlackSwan
identifier 'PACK_GEO.TRAN001' must be declared AIX, Oracle 11.2.0.3 By: arijit2004 on Fri, 30 March 2018	2	2712	Fri, 30 March 2018 06:29 By: arijit2004
How to get this table from that Database PL/SQL Developer, unknown, Win 10 By: Nanex on Thu, 29 March 2018	2	2779	Thu, 29 March 2018 08:30 By: joy_division
How to insert table alias in query Oracle 11g By: ssyr on Wed, 28 March 2018	2	2380	Thu, 29 March 2018 01:53 By: Michel Cadot
oracle Trigger for E-mail notifications !! oracle 11g By: shipon_97 on Sun, 25 March 2018	10	4721	Mon, 26 March 2018 23:57 By: shipon_97
How to log error using UTL_CALL_STACK Oracle 12c By: sss111ind on Wed, 07 March 2018	6	3755	Mon, 26 March 2018 07:16 By: Bill B
Merge 2 or more rows into 1 oracle 12c By: laredoeneko on Fri, 23 March 2018	7	4227	Sat, 24 March 2018 02:35 By: John Watson
Display Comma Separated Values 11g By: glmjoy on Wed, 21 March 2018	9	4253	Fri, 23 March 2018 11:34 By: glmjoy
Oracle 10 vs Oracle 12: order from SELECT statement Oracle12 By: basileus on Wed, 14 March 2018	15	7432	Fri, 23 March 2018 07:53 By: cookiemonster
Transaction 2 happen within 60 days of Transaction 1 Oracle Database 12c Enterprise Edition 12.1.0.2.0 By: Saz on Tue, 20 March 2018	13	7521	Wed, 21 March 2018 11:56 By: Saz
Comma Seprate 11g By: glmjoy on Mon, 19 March 2018	4	2986	Tue, 20 March 2018 18:19 By: glmjoy
return records based on records By: mist598 on Mon, 19 March 2018	5	3072	Tue, 20 March 2018 14:20 By: Barbara Boehmer
Arranging row data in column Oracel 10G, Windows 10 By: anil029 on Tue, 20 March 2018	1	2336	Tue, 20 March 2018 07:44 By: BlackSwan
How To Count Total number of rows deleted by DELETE and reset counter after some condition Oracle11g By: ssyr on Thu, 15 March 2018	9	4294	Thu, 15 March 2018 06:13 By: ssyr
Help on running difference sql query (2 merged by CM) oracle 11g By: bharathi89 on Wed, 14 March 2018	6	3049	Wed, 14 March 2018 21:21 By: bharathi89
How Can I Execute Table Name in Order without using ORDER BY Clayuse Oracle11g By: ssyr on Tue, 13 March 2018	6	2842	Wed, 14 March 2018 05:37 By: msol25
Help required for taking distinct count without using DISTINCT keyword By: ramya29p on Mon, 12 March 2018	7	3159	Tue, 13 March 2018 13:11 By: EdStevens
Import data from excel to oracle Db By: malu on Mon, 12 March 2018	3	4025	Tue, 13 March 2018 13:06 By: EdStevens
select more rows and insert less oracle 11gr2 By: guddu_12 on Tue, 06 March 2018	6	3046	Tue, 13 March 2018 09:16 By: msol25