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
function is not giving correct output By: AmarendraSahoo2016 on Tue, 24 May 2016	4	1676	Wed, 25 May 2016 02:54 By: Michel Cadot
Need to populate two more columns Oracle 11g By: arifs3738 on Tue, 24 May 2016	7	2115	Tue, 24 May 2016 21:35 By: arifs3738
Problem while inserting data in unix env By: amit.sonar on Mon, 23 May 2016	34	5619	Tue, 24 May 2016 09:33 By: Michel Cadot
first tuesday of every month ? sql developer By: nath123 on Fri, 20 May 2016	5	4490	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	3126	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	3132	Mon, 23 May 2016 07:56 By: BlackSwan
IN (or) Equality Operator SQL By: kirankumarmutte on Fri, 20 May 2016	9	3802	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	4452	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	3230	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	5100	Fri, 20 May 2016 02:01 By: pointers
Transpose Columns to Row group by Oracle By: dimveg on Thu, 19 May 2016	3	1874	Fri, 20 May 2016 01:30 By: Barbara Boehmer
Query reporting Oracle 11g By: srinivas.k2005 on Thu, 19 May 2016	4	1987	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	1266	Thu, 19 May 2016 07:16 By: EdStevens
timestamp question By: desmond30 on Tue, 17 May 2016	4	2202	Wed, 18 May 2016 10:04 By: desmond30
MEMBER OF condition across DB Link 11g2 By: mjm22 on Tue, 17 May 2016	7	2019	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	1871	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	3031	Tue, 17 May 2016 12:10 By: Michel Cadot
oracle server CPU spikes oracle 12c By: gorants on Sun, 15 May 2016	4	2106	Tue, 17 May 2016 08:10 By: javed.khan
Batch file to run sql script 11g By: harshadsp on Fri, 13 May 2016	33	8708	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	11980	Mon, 16 May 2016 10:28 By: madhuridara
oracle session leak oracle 12c By: gorants on Sun, 15 May 2016	3	2150	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	2239	Sun, 15 May 2016 14:32 By: Michel Cadot
attendance sheet oracle By: hisham99 on Thu, 12 May 2016	5	3165	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	1817	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	5563	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	1916	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	1313	Thu, 12 May 2016 09:46 By: dansrnt
create dummy rows Oracle 11.2.0.3 By: pointers on Mon, 28 March 2016	8	3343	Thu, 12 May 2016 06:53 By: pointers
net salary calculation 11g oracle By: nath123 on Tue, 10 May 2016	11	8230	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	2374	Wed, 11 May 2016 14:42 By: sspn2010
Partition taking more space Oracle 11g By: s4.ora on Wed, 11 May 2016	4	1733	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	2082	Wed, 11 May 2016 07:54 By: pstanand
Query Analytics Oracle 11g By: srinivas.k2005 on Wed, 11 May 2016	2	1315	Wed, 11 May 2016 06:42 By: srinivas.k2005
help in query 10g, win8.1 By: rzkhan on Mon, 09 May 2016	9	3034	Tue, 10 May 2016 23:00 By: rzkhan
sql By: desmond30 on Tue, 10 May 2016	8	1816	Tue, 10 May 2016 11:31 By: Solomon Yakobson
search for text in views By: desmond30 on Mon, 21 March 2016	4	2918	Tue, 10 May 2016 11:29 By: Solomon Yakobson
VIRTUAL Column - Function Oracle 11g By: ORAGENASHOK on Tue, 10 May 2016	7	3681	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	2184	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	12343	Mon, 09 May 2016 09:21 By: harshadsp
Table Partitioning: Oracle 10g By: oracle12c on Mon, 09 May 2016	1	1472	Mon, 09 May 2016 07:19 By: John Watson