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
icon2.gif Empolyees doesn't have any reportess
oracle 11 g
By: saipradyumn on Fri, 27 May 2016
9 676 Sat, 28 May 2016 08:53
By: Michel Cadot
  Last Record
oracle 11g, 11.2.0.4 , windows
By: Satheesh.A on Fri, 27 May 2016
13 1000 Sat, 28 May 2016 06:37
By: Solomon Yakobson
  Indexes
oracle 11g
By: Satheesh.A on Fri, 27 May 2016
2 508 Fri, 27 May 2016 07:25
By: Satheesh.A
  Dynamic SQL Select query (merged)
PL/SQL
By: richard_oak on Thu, 26 May 2016
5 551 Thu, 26 May 2016 12:19
By: BlackSwan
  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 525 Thu, 26 May 2016 08:41
By: BlackSwan
  join table for top 5 and bottom 5
sql developer
By: nath123 on Wed, 25 May 2016
5 538 Thu, 26 May 2016 00:08
By: Michel Cadot
  function is not giving correct output
By: AmarendraSahoo2016 on Tue, 24 May 2016
4 449 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 594 Tue, 24 May 2016 21:35
By: arifs3738
  Problem while inserting data in unix env
By: amit.sonar on Mon, 23 May 2016
34 1288 Tue, 24 May 2016 09:33
By: Michel Cadot
  first tuesday of every month ?
sql developer
By: nath123 on Fri, 20 May 2016
5 990 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 743 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 907 Mon, 23 May 2016 07:56
By: BlackSwan
  IN (or) Equality Operator
SQL
By: kirankumarmutte on Fri, 20 May 2016
9 1718 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 1722 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 808 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 894 Fri, 20 May 2016 02:01
By: pointers
  Transpose Columns to Row group by
Oracle
By: dimveg on Thu, 19 May 2016
3 508 Fri, 20 May 2016 01:30
By: Barbara Boehmer
  Run dbms_scheduler.create_job with arguments
Oracle 11.2.0.1.0
By: dansrnt on Fri, 13 May 2016
9 690 Thu, 19 May 2016 20:35
By: dansrnt
  Query reporting
Oracle 11g
By: srinivas.k2005 on Thu, 19 May 2016
4 415 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 304 Thu, 19 May 2016 07:16
By: EdStevens
  Missing number in series of numbers
Oracle 11g, windows
By: Vijay55 on Wed, 18 May 2016
4 622 Thu, 19 May 2016 05:04
By: flyboy
  timestamp question
By: desmond30 on Tue, 17 May 2016
4 609 Wed, 18 May 2016 10:04
By: desmond30
  MEMBER OF condition across DB Link
11g2
By: mjm22 on Tue, 17 May 2016
7 632 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 519 Tue, 17 May 2016 12:13
By: Michel Cadot
icon5.gif Compare 2 tables and upadte 1
pl sql
By: Helen_86 on Mon, 16 May 2016
13 733 Tue, 17 May 2016 12:10
By: Michel Cadot
  oracle server CPU spikes
oracle 12c
By: gorants on Sun, 15 May 2016
4 558 Tue, 17 May 2016 08:10
By: javed.khan
  Batch file to run sql script
11g
By: harshadsp on Fri, 13 May 2016
33 2142 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 784 Mon, 16 May 2016 10:28
By: madhuridara
  oracle session leak
oracle 12c
By: gorants on Sun, 15 May 2016
3 581 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 544 Sun, 15 May 2016 14:32
By: Michel Cadot
  attendance sheet
oracle
By: hisham99 on Thu, 12 May 2016
5 1033 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 635 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 1035 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 423 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 442 Thu, 12 May 2016 09:46
By: dansrnt
  create dummy rows
Oracle 11.2.0.3
By: pointers on Mon, 28 March 2016
8 1525 Thu, 12 May 2016 06:53
By: pointers
  net salary calculation
11g oracle
By: nath123 on Tue, 10 May 2016
11 896 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 615 Wed, 11 May 2016 14:42
By: sspn2010
  Partition taking more space
Oracle 11g
By: s4.ora on Wed, 11 May 2016
4 886 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 758 Wed, 11 May 2016 07:54
By: pstanand
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: Sun Feb 25 16:02:22 CST 2018

Total time taken to generate the page: 0.01101 seconds