Home » SQL & PL/SQL » SQL & PL/SQL
Please read the OraFAQ Forum Guide before posting.
Please contribute good answers to the wiki.

    Replies Views Last message
  Reverse row to column and column to row
Oracle 11
By: iliyan_84@abv.bg on Thu, 26 May 2016
14 820 Sat, 28 May 2016 14:08
By: Michel Cadot
  Pattern recognition problem
12.1.0.2
By: bdtran on Thu, 26 May 2016
11 758 Sat, 04 June 2016 13:10
By: bdtran
  Different values of count(*) and num_rows of table
11g, 11.2.0.1, windows server 2008
By: ashishkumarmahanta80 on Thu, 26 May 2016
12 448 Thu, 26 May 2016 08:41
By: BlackSwan
  function is not giving correct output
By: AmarendraSahoo2016 on Tue, 24 May 2016
4 409 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 517 Tue, 24 May 2016 21:35
By: arifs3738
  Difference between Global Temporary Table and Collections in PLSQL
By: msyogi on Mon, 23 May 2016
6 641 Tue, 24 May 2016 08:30
By: Bill B
  first tuesday of every month ?
sql developer
By: nath123 on Fri, 20 May 2016
5 879 Tue, 24 May 2016 08:46
By: Bill B
  Query that gives many different values
By: Jdevil on Fri, 20 May 2016
22 1454 Sat, 11 June 2016 10:43
By: EdStevens
  IN (or) Equality Operator
SQL
By: kirankumarmutte on Fri, 20 May 2016
9 1652 Fri, 20 May 2016 16:16
By: John Watson
  Problem while inserting data in unix env
By: amit.sonar on Mon, 23 May 2016
34 1187 Tue, 24 May 2016 09:33
By: Michel Cadot
  Transpose Columns to Row group by
Oracle
By: dimveg on Thu, 19 May 2016
3 444 Fri, 20 May 2016 01:30
By: Barbara Boehmer
  split from Update 7% basic Salary by bb
By: Salehin on Thu, 19 May 2016
2 261 Thu, 19 May 2016 07:16
By: EdStevens
  sysdate in the pivot in clause
Oracle 11.2.0.3
By: pointers on Thu, 19 May 2016
6 753 Fri, 20 May 2016 02:01
By: pointers
  Query reporting
Oracle 11g
By: srinivas.k2005 on Thu, 19 May 2016
4 376 Thu, 19 May 2016 14:18
By: Barbara Boehmer
  Accessing Sub directory under Oracle directory
11g
By: harshadsp on Thu, 19 May 2016
12 1585 Thu, 06 July 2017 09:52
By: Bill B
  Display the columns of a table into rows delimited by comma
11.2.0.4
By: grpatwari on Wed, 18 May 2016
19 1643 Fri, 20 May 2016 09:54
By: Michel Cadot
  Missing number in series of numbers
Oracle 11g, windows
By: Vijay55 on Wed, 18 May 2016
4 530 Thu, 19 May 2016 05:04
By: flyboy
  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 823 Mon, 23 May 2016 07:56
By: BlackSwan
  timestamp question
By: desmond30 on Tue, 17 May 2016
4 534 Wed, 18 May 2016 10:04
By: desmond30
  Not a group by expression (but not in sqlplus)
VBA Windows 7
By: oteixeira on Tue, 17 May 2016
4 459 Tue, 17 May 2016 12:13
By: Michel Cadot
  MEMBER OF condition across DB Link
11g2
By: mjm22 on Tue, 17 May 2016
7 564 Wed, 18 May 2016 04:32
By: mjm22
icon5.gif Compare 2 tables and upadte 1
pl sql
By: Helen_86 on Mon, 16 May 2016
13 680 Tue, 17 May 2016 12:10
By: Michel Cadot
  oracle server CPU spikes
oracle 12c
By: gorants on Sun, 15 May 2016
4 480 Tue, 17 May 2016 08:10
By: javed.khan
  oracle session leak
oracle 12c
By: gorants on Sun, 15 May 2016
3 484 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 490 Sun, 15 May 2016 14:32
By: Michel Cadot
  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 564 Fri, 13 May 2016 13:05
By: Michel Cadot
  Run dbms_scheduler.create_job with arguments
Oracle 11.2.0.1.0
By: dansrnt on Fri, 13 May 2016
9 580 Thu, 19 May 2016 20:35
By: dansrnt
  Batch file to run sql script
11g
By: harshadsp on Fri, 13 May 2016
33 1895 Tue, 17 May 2016 05:51
By: harshadsp
  Oracle Stored Procedure with Multiple Response to Calling Program
Oracle 11.2.0.1.0
By: dansrnt on Thu, 12 May 2016
4 394 Thu, 12 May 2016 09:46
By: dansrnt
  Execute Windows Command
Oracle Database, 10g, Windows 7
By: azamkhan on Thu, 12 May 2016
25 945 Fri, 13 May 2016 06:35
By: EdStevens
  attendance sheet
oracle
By: hisham99 on Thu, 12 May 2016
5 905 Sun, 15 May 2016 13:59
By: hisham99
  Partition taking more space
Oracle 11g
By: s4.ora on Wed, 11 May 2016
4 807 Wed, 11 May 2016 09:03
By: John Watson
icon7.gif Update 7% basic Salary
SQL Plus 8.0 ( 1 2)
By: Salehin on Wed, 11 May 2016
44 2480 Mon, 20 June 2016 22:05
By: Salehin
  Query Analytics
Oracle 11g
By: srinivas.k2005 on Wed, 11 May 2016
2 372 Wed, 11 May 2016 06:42
By: srinivas.k2005
  NUMBER to HEX, HEX to NUMBER
Oracle 11gR2, Oracle Linux
By: madhuridara on Tue, 10 May 2016
2 671 Mon, 16 May 2016 10:28
By: madhuridara
  net salary calculation
11g oracle
By: nath123 on Tue, 10 May 2016
11 787 Thu, 12 May 2016 03:15
By: cookiemonster
  sql
By: desmond30 on Tue, 10 May 2016
8 523 Tue, 10 May 2016 11:31
By: Solomon Yakobson
  External table not fully loaded
12c,windows NT
By: pstanand on Tue, 10 May 2016
8 683 Wed, 11 May 2016 07:54
By: pstanand
  Hierarchy query help
oracle 12.1.0.2.0, Linux
By: sspn2010 on Mon, 09 May 2016
6 565 Wed, 11 May 2016 14:42
By: sspn2010
  VIRTUAL Column - Function
Oracle 11g
By: ORAGENASHOK on Tue, 10 May 2016
7 769 Tue, 10 May 2016 07:31
By: Michel Cadot
Goto Forum:
  
Legend New Messages New Messages   No New messages No New messages   Locked (w/ unread messages) Locked (w/ unread messages)   Locked Locked   Moved to another forum Moved to another forum

Current Time: Wed Sep 20 20:38:41 CDT 2017

Total time taken to generate the page: 0.06551 seconds