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
  External table not fully loaded
12c,windows NT
By: pstanand on Tue, 10 May 2016
8 433 Wed, 11 May 2016 07:54
By: pstanand
  Query Analytics
Oracle 11g
By: srinivas.k2005 on Wed, 11 May 2016
2 220 Wed, 11 May 2016 06:42
By: srinivas.k2005
  help in query
10g, win8.1
By: rzkhan on Mon, 09 May 2016
9 521 Tue, 10 May 2016 23:00
By: rzkhan
  sql
By: desmond30 on Tue, 10 May 2016
8 312 Tue, 10 May 2016 11:31
By: Solomon Yakobson
  search for text in views
By: desmond30 on Mon, 21 March 2016
4 427 Tue, 10 May 2016 11:29
By: Solomon Yakobson
  VIRTUAL Column - Function
Oracle 11g
By: ORAGENASHOK on Tue, 10 May 2016
7 297 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 304 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 1722 Mon, 09 May 2016 09:21
By: harshadsp
  Table Partitioning:
Oracle 10g
By: oracle12c on Mon, 09 May 2016
1 192 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 234 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 378 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 422 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 245 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 274 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 349 Fri, 06 May 2016 12:26
By: Barbara Boehmer
  Date Updation
Oracle 12C Windows NT
By: pstanand on Thu, 05 May 2016
15 480 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 383 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 365 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 345 Tue, 03 May 2016 10:18
By: ThomasG
  Alphanumeric Sequence Generator
By: msyogi on Tue, 03 May 2016
7 370 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 367 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 346 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 514 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 391 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 297 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 655 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 766 Fri, 29 April 2016 13:30
By: Barbara Boehmer
  Update Query
Oracle 12C Windows NT
By: pstanand on Thu, 28 April 2016
8 440 Thu, 28 April 2016 12:29
By: Bill B
  Oracle Lock
Oracle 10g
By: prashant_ora on Thu, 28 April 2016
6 302 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 407 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 425 Thu, 28 April 2016 10:06
By: Bill B
  Hierarchical Query (merged)
Oracle 10g
By: lokimisc on Wed, 27 April 2016
7 450 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 265 Thu, 28 April 2016 06:24
By: brown_zzz
  Partitioning Tables
Oracle 11g, Unix
By: ninan on Sat, 23 April 2016
11 673 Wed, 27 April 2016 13:56
By: jyeager
  Joining four tables..need help
By: dbJuniorAdmin on Sun, 24 April 2016
12 469 Tue, 26 April 2016 12:11
By: Bill B
  narration in one line
By: shahzad-ul-hasan on Fri, 01 April 2016
12 689 Tue, 26 April 2016 01:50
By: per0per0
  get row counts daily
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
By: TorontoTrader on Mon, 25 April 2016
4 251 Mon, 25 April 2016 11:43
By: TorontoTrader
  Please help for regexp_replace in oracle 11g
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit
By: msol25 on Mon, 25 April 2016
3 279 Mon, 25 April 2016 07:37
By: msol25
  Nested cursor expressions
DB 12.1.0.2
By: John Watson on Fri, 22 April 2016
25 830 Sun, 24 April 2016 10:39
By: John Watson
  with clause logic
By: sivaparam on Mon, 04 April 2016
33 1124 Sun, 24 April 2016 06:55
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 Jul 30 13:54:29 CDT 2016

Total time taken to generate the page: 0.09565 seconds