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
first tuesday of every month ? sql developer By: nath123 on Fri, 20 May 2016	5	4442	Tue, 24 May 2016 08:46 By: Bill B
Difference between Global Temporary Table and Collections in PLSQL By: msyogi on Mon, 23 May 2016	6	3076	Tue, 24 May 2016 08:30 By: Bill B
Moving data older than 2 years in all fact tables to respective archive tables & purging data Oracle 11g , SQL Developer, Windows By: krisc2499 on Sat, 21 May 2016	10	3094	Mon, 23 May 2016 07:56 By: BlackSwan
IN (or) Equality Operator SQL By: kirankumarmutte on Fri, 20 May 2016	9	3778	Fri, 20 May 2016 16:16 By: John Watson
Display the columns of a table into rows delimited by comma 11.2.0.4 By: grpatwari on Wed, 18 May 2016	19	4401	Fri, 20 May 2016 09:54 By: Michel Cadot
Pattern Matching for Multivalue Oracle 11g R2 By: javed.khan on Tue, 03 May 2016	11	3168	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	5027	Fri, 20 May 2016 02:01 By: pointers
Transpose Columns to Row group by Oracle By: dimveg on Thu, 19 May 2016	3	1822	Fri, 20 May 2016 01:30 By: Barbara Boehmer
Query reporting Oracle 11g By: srinivas.k2005 on Thu, 19 May 2016	4	1948	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	1230	Thu, 19 May 2016 07:16 By: EdStevens
timestamp question By: desmond30 on Tue, 17 May 2016	4	2162	Wed, 18 May 2016 10:04 By: desmond30
MEMBER OF condition across DB Link 11g2 By: mjm22 on Tue, 17 May 2016	7	1989	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	1839	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	2982	Tue, 17 May 2016 12:10 By: Michel Cadot
oracle server CPU spikes oracle 12c By: gorants on Sun, 15 May 2016	4	2058	Tue, 17 May 2016 08:10 By: javed.khan
Batch file to run sql script 11g By: harshadsp on Fri, 13 May 2016	33	8651	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	11841	Mon, 16 May 2016 10:28 By: madhuridara
oracle session leak oracle 12c By: gorants on Sun, 15 May 2016	3	2114	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	2200	Sun, 15 May 2016 14:32 By: Michel Cadot
attendance sheet oracle By: hisham99 on Thu, 12 May 2016	5	3130	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	1779	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	5500	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	1878	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	1279	Thu, 12 May 2016 09:46 By: dansrnt
create dummy rows Oracle 11.2.0.3 By: pointers on Mon, 28 March 2016	8	3299	Thu, 12 May 2016 06:53 By: pointers
net salary calculation 11g oracle By: nath123 on Tue, 10 May 2016	11	8155	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	2336	Wed, 11 May 2016 14:42 By: sspn2010
Partition taking more space Oracle 11g By: s4.ora on Wed, 11 May 2016	4	1700	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	2040	Wed, 11 May 2016 07:54 By: pstanand
Query Analytics Oracle 11g By: srinivas.k2005 on Wed, 11 May 2016	2	1283	Wed, 11 May 2016 06:42 By: srinivas.k2005
help in query 10g, win8.1 By: rzkhan on Mon, 09 May 2016	9	3008	Tue, 10 May 2016 23:00 By: rzkhan
sql By: desmond30 on Tue, 10 May 2016	8	1784	Tue, 10 May 2016 11:31 By: Solomon Yakobson
search for text in views By: desmond30 on Mon, 21 March 2016	4	2870	Tue, 10 May 2016 11:29 By: Solomon Yakobson
VIRTUAL Column - Function Oracle 11g By: ORAGENASHOK on Tue, 10 May 2016	7	3636	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	2124	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	12248	Mon, 09 May 2016 09:21 By: harshadsp
Table Partitioning: Oracle 10g By: oracle12c on Mon, 09 May 2016	1	1433	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	1162	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	2168	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	2935	Sat, 07 May 2016 17:54 By: Barbara Boehmer