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
  Oracle Stored Procedure with Multiple Response to Calling Program
Oracle 11.2.0.1.0
By: dansrnt on Thu, 12 May 2016
4 280 Thu, 12 May 2016 09:46
By: dansrnt
  create dummy rows
Oracle 11.2.0.3
By: pointers on Mon, 28 March 2016
8 1290 Thu, 12 May 2016 06:53
By: pointers
  net salary calculation
11g oracle
By: nath123 on Tue, 10 May 2016
11 571 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 451 Wed, 11 May 2016 14:42
By: sspn2010
  Partition taking more space
Oracle 11g
By: s4.ora on Wed, 11 May 2016
4 261 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 499 Wed, 11 May 2016 07:54
By: pstanand
  Query Analytics
Oracle 11g
By: srinivas.k2005 on Wed, 11 May 2016
2 263 Wed, 11 May 2016 06:42
By: srinivas.k2005
  help in query
10g, win8.1
By: rzkhan on Mon, 09 May 2016
9 591 Tue, 10 May 2016 23:00
By: rzkhan
  sql
By: desmond30 on Tue, 10 May 2016
8 350 Tue, 10 May 2016 11:31
By: Solomon Yakobson
  search for text in views
By: desmond30 on Mon, 21 March 2016
4 476 Tue, 10 May 2016 11:29
By: Solomon Yakobson
  VIRTUAL Column - Function
Oracle 11g
By: ORAGENASHOK on Tue, 10 May 2016
7 394 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 371 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 1878 Mon, 09 May 2016 09:21
By: harshadsp
  Table Partitioning:
Oracle 10g
By: oracle12c on Mon, 09 May 2016
1 238 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 275 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 433 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 484 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 279 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 308 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 433 Fri, 06 May 2016 12:26
By: Barbara Boehmer
  Date Updation
Oracle 12C Windows NT
By: pstanand on Thu, 05 May 2016
15 560 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 494 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 525 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 412 Tue, 03 May 2016 10:18
By: ThomasG
  Alphanumeric Sequence Generator
By: msyogi on Tue, 03 May 2016
7 456 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 438 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 411 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 596 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 476 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 373 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 776 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 838 Fri, 29 April 2016 13:30
By: Barbara Boehmer
  Update Query
Oracle 12C Windows NT
By: pstanand on Thu, 28 April 2016
8 499 Thu, 28 April 2016 12:29
By: Bill B
  Oracle Lock
Oracle 10g
By: prashant_ora on Thu, 28 April 2016
6 359 Thu, 28 April 2016 12:28
By: Bill B
  Dynamic selection of data in query
oracle 11g
By: rocky_007 on Thu, 28 April 2016
7 463 Thu, 28 April 2016 10:24
By: Bill B
  Index on composite foreign key
Oracle 11
By: RaShi.Raj on Thu, 28 April 2016
11 483 Thu, 28 April 2016 10:06
By: Bill B
  Hierarchical Query (merged)
Oracle 10g
By: lokimisc on Wed, 27 April 2016
7 554 Thu, 28 April 2016 07:51
By: Michel Cadot
  Stale Materialised view
Oracle 10.2.0.4.0
By: brown_zzz on Thu, 28 April 2016
3 343 Thu, 28 April 2016 06:24
By: brown_zzz
  Partitioning Tables
Oracle 11g, Unix
By: ninan on Sat, 23 April 2016
11 761 Wed, 27 April 2016 13:56
By: jyeager
  Joining four tables..need help
By: dbJuniorAdmin on Sun, 24 April 2016
12 525 Tue, 26 April 2016 12:11
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: Sat Dec 03 22:35:49 CST 2016

Total time taken to generate the page: 0.15194 seconds