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
Pattern Matching for Multivalue Oracle 11g R2 By: javed.khan on Tue, 03 May 2016	11	4993	Fri, 20 May 2016 09:48 By: Bill B
sysdate in the pivot in clause Oracle 11.2.0.3 By: pointers on Thu, 19 May 2016	6	6692	Fri, 20 May 2016 02:01 By: pointers
Transpose Columns to Row group by Oracle By: dimveg on Thu, 19 May 2016	3	2801	Fri, 20 May 2016 01:30 By: Barbara Boehmer
Query reporting Oracle 11g By: srinivas.k2005 on Thu, 19 May 2016	4	2900	Thu, 19 May 2016 14:18 By: Barbara Boehmer
split from Update 7% basic Salary by bb By: Salehin on Thu, 19 May 2016	2	1980	Thu, 19 May 2016 07:16 By: EdStevens
timestamp question By: desmond30 on Tue, 17 May 2016	4	3456	Wed, 18 May 2016 10:04 By: desmond30
MEMBER OF condition across DB Link 11g2 By: mjm22 on Tue, 17 May 2016	7	3590	Wed, 18 May 2016 04:32 By: mjm22
Not a group by expression (but not in sqlplus) VBA Windows 7 By: oteixeira on Tue, 17 May 2016	4	2904	Tue, 17 May 2016 12:13 By: Michel Cadot
Compare 2 tables and upadte 1 pl sql By: Helen_86 on Mon, 16 May 2016	13	5052	Tue, 17 May 2016 12:10 By: Michel Cadot
oracle server CPU spikes oracle 12c By: gorants on Sun, 15 May 2016	4	3917	Tue, 17 May 2016 08:10 By: javed.khan
Batch file to run sql script 11g By: harshadsp on Fri, 13 May 2016	33	13146	Tue, 17 May 2016 05:51 By: harshadsp
NUMBER to HEX, HEX to NUMBER Oracle 11gR2, Oracle Linux By: madhuridara on Tue, 10 May 2016	2	13445	Mon, 16 May 2016 10:28 By: madhuridara
oracle session leak oracle 12c By: gorants on Sun, 15 May 2016	3	3231	Sun, 15 May 2016 22:35 By: BlackSwan
Regular expression: letter category? Any version supporting regular expressions By: Michel Cadot on Sun, 15 May 2016	5	3539	Sun, 15 May 2016 14:32 By: Michel Cadot
attendance sheet oracle By: hisham99 on Thu, 12 May 2016	5	4563	Sun, 15 May 2016 13:59 By: hisham99
Analytical grouping of data Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: vduhan on Fri, 13 May 2016	4	2904	Fri, 13 May 2016 13:05 By: Michel Cadot
Execute Windows Command Oracle Database, 10g, Windows 7 By: azamkhan on Thu, 12 May 2016	25	9809	Fri, 13 May 2016 06:35 By: EdStevens
create stored procedure with cursor as an out argument By: pradeep92 on Thu, 12 May 2016	4	3119	Thu, 12 May 2016 14:40 By: Barbara Boehmer
Oracle Stored Procedure with Multiple Response to Calling Program Oracle 11.2.0.1.0 By: dansrnt on Thu, 12 May 2016	4	2633	Thu, 12 May 2016 09:46 By: dansrnt
create dummy rows Oracle 11.2.0.3 By: pointers on Mon, 28 March 2016	8	4978	Thu, 12 May 2016 06:53 By: pointers
net salary calculation 11g oracle By: nath123 on Tue, 10 May 2016	11	10637	Thu, 12 May 2016 03:15 By: cookiemonster
Hierarchy query help oracle 12.1.0.2.0, Linux By: sspn2010 on Mon, 09 May 2016	6	3848	Wed, 11 May 2016 14:42 By: sspn2010
Partition taking more space Oracle 11g By: s4.ora on Wed, 11 May 2016	4	2941	Wed, 11 May 2016 09:03 By: John Watson
External table not fully loaded 12c,windows NT By: pstanand on Tue, 10 May 2016	8	3427	Wed, 11 May 2016 07:54 By: pstanand
Query Analytics Oracle 11g By: srinivas.k2005 on Wed, 11 May 2016	2	2051	Wed, 11 May 2016 06:42 By: srinivas.k2005
help in query 10g, win8.1 By: rzkhan on Mon, 09 May 2016	9	4725	Tue, 10 May 2016 23:00 By: rzkhan
sql By: desmond30 on Tue, 10 May 2016	8	3226	Tue, 10 May 2016 11:31 By: Solomon Yakobson
search for text in views By: desmond30 on Mon, 21 March 2016	4	4271	Tue, 10 May 2016 11:29 By: Solomon Yakobson
VIRTUAL Column - Function Oracle 11g By: ORAGENASHOK on Tue, 10 May 2016	7	5342	Tue, 10 May 2016 07:31 By: Michel Cadot
Convert local time to GMT using off set By: rao_teertum@yahoo.com on Mon, 09 May 2016	5	3397	Mon, 09 May 2016 17:00 By: rao_teertum@yahoo.com
Dynamic File Creation using UTL_FILE Oracle 11G ( 1 2) By: harshadsp on Tue, 05 April 2016	76	21379	Mon, 09 May 2016 09:21 By: harshadsp
Table Partitioning: Oracle 10g By: oracle12c on Mon, 09 May 2016	1	2070	Mon, 09 May 2016 07:19 By: John Watson
What is the best method to fetch data from a table and write into a csv file. By: sibashishnayak on Mon, 09 May 2016	1	1752	Mon, 09 May 2016 06:24 By: EdStevens
Revoke insert and Update access from schema owner 11.0.2.10 By: OraFerro on Thu, 05 May 2016	9	3466	Sun, 08 May 2016 00:25 By: John Watson
select based on ratio from second table Oracle, 11.2.0.4 By: merlin1989 on Sat, 07 May 2016	14	4608	Sat, 07 May 2016 17:54 By: Barbara Boehmer
Index is not used when additing one more selection criteria 11g By: karthik4u on Sat, 07 May 2016	2	2209	Sat, 07 May 2016 11:48 By: BlackSwan
Preserving Blanks in External Table Oracle 12, Windows NT By: pstanand on Fri, 06 May 2016	2	3126	Sat, 07 May 2016 08:12 By: EdStevens
Sort PL/SQL Table Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit, Win 7 By: vikram_2050 on Thu, 05 May 2016	6	3687	Fri, 06 May 2016 12:26 By: Barbara Boehmer
Date Updation Oracle 12C Windows NT By: pstanand on Thu, 05 May 2016	15	6047	Fri, 06 May 2016 09:28 By: pstanand
How can I read a variable runtime in a stored proc? By: gouravhere on Wed, 04 May 2016	7	5502	Thu, 05 May 2016 12:54 By: Michel Cadot