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
  NUMBER to HEX, HEX to NUMBER
Oracle 11gR2, Oracle Linux
By: madhuridara on Tue, 10 May 2016
2 547 Mon, 16 May 2016 10:28
By: madhuridara
  oracle session leak
oracle 12c
By: gorants on Sun, 15 May 2016
3 379 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 419 Sun, 15 May 2016 14:32
By: Michel Cadot
  attendance sheet
oracle
By: hisham99 on Thu, 12 May 2016
5 748 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 471 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 793 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 315 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 323 Thu, 12 May 2016 09:46
By: dansrnt
  create dummy rows
Oracle 11.2.0.3
By: pointers on Mon, 28 March 2016
8 1364 Thu, 12 May 2016 06:53
By: pointers
  net salary calculation
11g oracle
By: nath123 on Tue, 10 May 2016
11 654 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 491 Wed, 11 May 2016 14:42
By: sspn2010
  Partition taking more space
Oracle 11g
By: s4.ora on Wed, 11 May 2016
4 303 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 562 Wed, 11 May 2016 07:54
By: pstanand
  Query Analytics
Oracle 11g
By: srinivas.k2005 on Wed, 11 May 2016
2 305 Wed, 11 May 2016 06:42
By: srinivas.k2005
  help in query
10g, win8.1
By: rzkhan on Mon, 09 May 2016
9 643 Tue, 10 May 2016 23:00
By: rzkhan
  sql
By: desmond30 on Tue, 10 May 2016
8 395 Tue, 10 May 2016 11:31
By: Solomon Yakobson
  search for text in views
By: desmond30 on Mon, 21 March 2016
4 533 Tue, 10 May 2016 11:29
By: Solomon Yakobson
  VIRTUAL Column - Function
Oracle 11g
By: ORAGENASHOK on Tue, 10 May 2016
7 494 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 433 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 2015 Mon, 09 May 2016 09:21
By: harshadsp
  Table Partitioning:
Oracle 10g
By: oracle12c on Mon, 09 May 2016
1 268 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 312 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 492 Sun, 08 May 2016 00:25
By: John Watson
icon5.gif select based on ratio from second table
Oracle, 11.2.0.4
By: merlin1989 on Sat, 07 May 2016
14 534 Sat, 07 May 2016 17:54
By: Barbara Boehmer
  Index is not used when additing one more selection criteria
11g
By: karthik4u on Sat, 07 May 2016
2 331 Sat, 07 May 2016 11:48
By: BlackSwan
  Preserving Blanks in External Table
Oracle 12, Windows NT
By: pstanand on Fri, 06 May 2016
2 362 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 516 Fri, 06 May 2016 12:26
By: Barbara Boehmer
  Date Updation
Oracle 12C Windows NT
By: pstanand on Thu, 05 May 2016
15 610 Fri, 06 May 2016 09:28
By: pstanand
  How can I read a variable runtime in a stored proc?
By: gouravhere on Wed, 04 May 2016
7 603 Thu, 05 May 2016 12:54
By: Michel Cadot
  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 702 Wed, 04 May 2016 04:46
By: Michel Cadot
  How to suppress messages from FTP server?
11.2
By: YIMORAF on Sun, 01 May 2016
4 511 Tue, 03 May 2016 10:18
By: ThomasG
  Alphanumeric Sequence Generator
By: msyogi on Tue, 03 May 2016
7 554 Tue, 03 May 2016 05:28
By: msyogi
  SQL Query to fetch not matching records
12 C Windows NT
By: pstanand on Mon, 02 May 2016
5 490 Tue, 03 May 2016 02:10
By: Michel Cadot
  HELP TO FORM DYNAMIC INSERT QUERY IN PL/SQL
By: ibnelyas on Fri, 29 April 2016
4 482 Tue, 03 May 2016 01:53
By: muhammadadnan198@gmail.co
  Unable to get values from associative arrays into a different procedure
Database:11.2.0.1.0; O/S: Linux 3.0.101-0.47.71-default x86_64
By: buggleboy007 on Mon, 25 April 2016
11 641 Mon, 02 May 2016 20:08
By: buggleboy007
  how to match multiple wildcards via metadata table
By: joy_division on Fri, 29 April 2016
5 526 Mon, 02 May 2016 16:15
By: Barbara Boehmer
  call a web service in a function in plsql
oracle 10g
By: shahrezaei on Sat, 30 April 2016
1 442 Sat, 30 April 2016 07:24
By: BlackSwan
  error creating external via dbms_utility.exec_ddl_statement@myDB
Oracle 11.2.9.1.0
By: gunderj on Mon, 25 April 2016
12 846 Sat, 30 April 2016 06:58
By: gunderj
  Trigger to prevent delete based on SQL statement
11.0.2.10
By: OraFerro on Thu, 28 April 2016
22 887 Fri, 29 April 2016 13:30
By: Barbara Boehmer
  Update Query
Oracle 12C Windows NT
By: pstanand on Thu, 28 April 2016
8 553 Thu, 28 April 2016 12:29
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: Wed Mar 29 14:10:26 CDT 2017

Total time taken to generate the page: 0.07156 seconds