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
  Not a group by expression (but not in sqlplus)
VBA Windows 7
By: oteixeira on Tue, 17 May 2016
4 472 Tue, 17 May 2016 12:13
By: Michel Cadot
  MEMBER OF condition across DB Link
11g2
By: mjm22 on Tue, 17 May 2016
7 578 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 688 Tue, 17 May 2016 12:10
By: Michel Cadot
  oracle server CPU spikes
oracle 12c
By: gorants on Sun, 15 May 2016
4 494 Tue, 17 May 2016 08:10
By: javed.khan
  oracle session leak
oracle 12c
By: gorants on Sun, 15 May 2016
3 491 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 500 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 575 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 621 Thu, 19 May 2016 20:35
By: dansrnt
  Batch file to run sql script
11g
By: harshadsp on Fri, 13 May 2016
33 1924 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 404 Thu, 12 May 2016 09:46
By: dansrnt
  Execute Windows Command
Oracle Database, 10g, Windows 7
By: azamkhan on Thu, 12 May 2016
25 965 Fri, 13 May 2016 06:35
By: EdStevens
  attendance sheet
oracle
By: hisham99 on Thu, 12 May 2016
5 933 Sun, 15 May 2016 13:59
By: hisham99
  Partition taking more space
Oracle 11g
By: s4.ora on Wed, 11 May 2016
4 836 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 2495 Mon, 20 June 2016 22:05
By: Salehin
  Query Analytics
Oracle 11g
By: srinivas.k2005 on Wed, 11 May 2016
2 383 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 692 Mon, 16 May 2016 10:28
By: madhuridara
  net salary calculation
11g oracle
By: nath123 on Tue, 10 May 2016
11 797 Thu, 12 May 2016 03:15
By: cookiemonster
  sql
By: desmond30 on Tue, 10 May 2016
8 530 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 693 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 575 Wed, 11 May 2016 14:42
By: sspn2010
  VIRTUAL Column - Function
Oracle 11g
By: ORAGENASHOK on Tue, 10 May 2016
7 811 Tue, 10 May 2016 07:31
By: Michel Cadot
  create stored procedure with cursor as an out argument
By: pradeep92 on Thu, 12 May 2016
4 386 Thu, 12 May 2016 14:40
By: Barbara Boehmer
  join table for top 5 and bottom 5
sql developer
By: nath123 on Wed, 25 May 2016
5 488 Thu, 26 May 2016 00:08
By: Michel Cadot
  help in query
10g, win8.1
By: rzkhan on Mon, 09 May 2016
9 733 Tue, 10 May 2016 23:00
By: rzkhan
  Table Partitioning:
Oracle 10g
By: oracle12c on Mon, 09 May 2016
1 328 Mon, 09 May 2016 07:19
By: John Watson
  Convert local time to GMT using off set
By: rao_teertum@yahoo.com on Mon, 09 May 2016
5 524 Mon, 09 May 2016 17:00
By: rao_teertum@yahoo.com
  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 347 Mon, 09 May 2016 06:24
By: EdStevens
  Index is not used when additing one more selection criteria
11g
By: karthik4u on Sat, 07 May 2016
2 419 Sat, 07 May 2016 11:48
By: BlackSwan
icon5.gif select based on ratio from second table
Oracle, 11.2.0.4
By: merlin1989 on Sat, 07 May 2016
14 870 Sat, 07 May 2016 17:54
By: Barbara Boehmer
  Preserving Blanks in External Table
Oracle 12, Windows NT
By: pstanand on Fri, 06 May 2016
2 474 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 630 Fri, 06 May 2016 12:26
By: Barbara Boehmer
  Date Updation
Oracle 12C Windows NT
By: pstanand on Thu, 05 May 2016
15 832 Fri, 06 May 2016 09:28
By: pstanand
  Revoke insert and Update access from schema owner
11.0.2.10
By: OraFerro on Thu, 05 May 2016
9 663 Sun, 08 May 2016 00:25
By: John Watson
  How can I read a variable runtime in a stored proc?
By: gouravhere on Wed, 04 May 2016
7 810 Thu, 05 May 2016 12:54
By: Michel Cadot
  Pattern Matching for Multivalue
Oracle 11g R2
By: javed.khan on Tue, 03 May 2016
11 745 Fri, 20 May 2016 09:48
By: Bill B
  ORA-30928: Connect by filtering phase runs out of temp tablespace 30928. 00000 - "Connect by filter
Oracle 11G R2
By: Kanagaraj2007 on Tue, 03 May 2016
5 995 Wed, 04 May 2016 04:46
By: Michel Cadot
  SQL Query to fetch not matching records
12 C Windows NT
By: pstanand on Mon, 02 May 2016
5 581 Tue, 03 May 2016 02:10
By: Michel Cadot
  call a web service in a function in plsql
oracle 10g
By: shahrezaei on Sat, 30 April 2016
1 569 Sat, 30 April 2016 07:24
By: BlackSwan
  how to match multiple wildcards via metadata table
By: joy_division on Fri, 29 April 2016
5 654 Mon, 02 May 2016 16:15
By: Barbara Boehmer
  Oracle Lock
Oracle 10g
By: prashant_ora on Thu, 28 April 2016
6 459 Thu, 28 April 2016 12:28
By: Bill B
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: Tue Oct 17 19:21:31 CDT 2017

Total time taken to generate the page: 0.05964 seconds