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
  Determine Incomplete Orders
Oracle 11g
By: stun66 on Wed, 11 November 2015
4 580 Thu, 12 November 2015 03:49
By: mnitu
  PLSQL Collection index by varchar
By: wantsunny007 on Mon, 09 November 2015
21 824 Mon, 09 November 2015 15:06
By: wantsunny007
  Need Help in SQL Query
Oracle 11g
By: arifs3738 on Wed, 04 November 2015
22 1056 Mon, 09 November 2015 10:40
By: Michel Cadot
  sql query help
Oracle 11g
By: arifs3738 on Sun, 08 November 2015
6 611 Mon, 09 November 2015 07:28
By: Michel Cadot
  Oracle Regular Expression - Remove space between alphabetic tokens of length 1 within a string
Oracle 11.2
By: orauser001 on Thu, 05 November 2015
10 718 Sat, 07 November 2015 23:00
By: orauser001
  find updated table name
oracle 11gr2
By: guddu_12 on Thu, 05 November 2015
12 583 Thu, 05 November 2015 09:38
By: BlackSwan
icon5.gif i want to use temporary data source for next time and it is going in that way
11g
By: graphe on Wed, 04 November 2015
2 442 Thu, 05 November 2015 06:17
By: graphe
  Out of SQL Query
Oracle 11g
By: arifs3738 on Wed, 04 November 2015
3 399 Wed, 04 November 2015 06:33
By: arifs3738
  Materialized View Refresh Issue
Oracle 11g 64 bit
By: fatimacognos on Mon, 02 November 2015
3 547 Wed, 04 November 2015 04:46
By: JNagtzaam
  Update blob Column
Oracle 11g
By: thiruvari on Tue, 03 November 2015
13 570 Wed, 04 November 2015 04:40
By: Michel Cadot
  Nested table as a out parameter in procedure
11g db, windows 7
By: aspire on Tue, 03 November 2015
3 286 Tue, 03 November 2015 12:30
By: aspire
  Complex query (merged)
10g
By: m.abdulhaq on Sun, 01 November 2015
8 769 Tue, 03 November 2015 11:39
By: m.abdulhaq
  stored procedure to Inserting new rows and updating existing rows
11.2.0.3
By: amy.wilson on Mon, 02 November 2015
7 565 Tue, 03 November 2015 07:39
By: sandeep_orafaq
  Test query for SORT (merged)
12c
By: gkrishn on Mon, 02 November 2015
5 437 Mon, 02 November 2015 13:29
By: Michel Cadot
  i want to upload a file in database using plsql
10g
By: sudheerips on Mon, 02 November 2015
6 433 Mon, 02 November 2015 09:17
By: John Watson
  a column may not be outer-joined to a subquery
By: javon13 on Fri, 30 October 2015
10 686 Mon, 02 November 2015 07:03
By: javon13
  case statement
pl/sql
By: amazeme on Fri, 30 October 2015
2 415 Fri, 30 October 2015 12:25
By: amazeme
  query
By: chatwidravi on Tue, 27 October 2015
7 460 Fri, 30 October 2015 11:23
By: Michel Cadot
  Stored Procedure in migrating data
oracle 11.2.0.3
By: amy.wilson on Tue, 27 October 2015
10 823 Fri, 30 October 2015 03:39
By: javon13
  Sending SMS through Oracle Database
By: sarfraz_attari on Sat, 16 September 2006
25 12119 Thu, 29 October 2015 23:56
By: jagadekar
  ERROR CODE IS 1 User-Defined Exception Instead of ORA-00001: unique constraint (SCOTT.PK_EMP_UP) vi
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
By: rajesh_oracle on Wed, 28 October 2015
3 415 Thu, 29 October 2015 01:00
By: Michel Cadot
  Insert, delete and update At a time
Oracle 11g, windows
By: Vijay55 on Wed, 28 October 2015
4 313 Wed, 28 October 2015 09:10
By: BlackSwan
  Oracle Stored procedure takes long time to initiate / execute - (from package)
Oracle 11.2.0.3, Linux x86 64
By: hitesh.bhatt on Wed, 28 October 2015
3 282 Wed, 28 October 2015 07:51
By: BlackSwan
  Coping one cursor results into another cursor
oracle 11g
By: aravind.peddola@gmail.com on Wed, 28 October 2015
1 274 Wed, 28 October 2015 01:35
By: Michel Cadot
  Inclusion of duplicate records
By: rohit_shinez on Tue, 27 October 2015
2 284 Tue, 27 October 2015 13:43
By: rohit_shinez
  explicit and implicit functions in oracle
By: letolagal on Tue, 27 October 2015
3 364 Tue, 27 October 2015 09:59
By: John Watson
  How to keep only one branch after connect by
Oracle 11g - 11.2.0.3
By: ric90 on Mon, 26 October 2015
2 346 Mon, 26 October 2015 07:58
By: ric90
  Searching through entire table.
By: jimjohn on Mon, 19 October 2015
10 2289 Mon, 26 October 2015 06:50
By: EdStevens
  remote database migration
Oracle 11.2.0.3
By: deb171100 on Mon, 26 October 2015
7 379 Mon, 26 October 2015 06:46
By: EdStevens
  To Split data based on dates
By: rohit_shinez on Tue, 13 October 2015
20 9993 Sun, 25 October 2015 18:19
By: Barbara Boehmer
  Compare values based on range
By: rohit_shinez on Sat, 24 October 2015
27 667 Sun, 25 October 2015 13:28
By: Michel Cadot
  Is there a limitation of connect by for Partitioned tables
Oracle 11g
By: gentleman777us on Fri, 23 October 2015
1 284 Fri, 23 October 2015 12:15
By: Michel Cadot
  Need answer for below block
By: rajesh_oracle on Fri, 23 October 2015
1 350 Fri, 23 October 2015 02:13
By: Michel Cadot
  Unique hash based on user database objects.
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: tmcallister on Wed, 21 October 2015
7 607 Thu, 22 October 2015 19:23
By: BlackSwan
  get the remote DB instance name
Oracle 9i Release2 , HP UNIX
By: live4learn on Wed, 21 October 2015
5 2422 Wed, 21 October 2015 13:24
By: Solomon Yakobson
  interview question asked (merged 3)
By: purnima1 on Wed, 21 October 2015
3 455 Wed, 21 October 2015 10:47
By: Michel Cadot
  How to filter records from UNION ALL query
By: toitdoctor on Tue, 20 October 2015
4 2107 Wed, 21 October 2015 08:11
By: Michel Cadot
  Parallel Procedure Run
Oracle 11g, Windows 7
By: Vijay55 on Wed, 21 October 2015
2 1700 Wed, 21 October 2015 03:05
By: Michel Cadot
  Select with Time Range
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0
By: Duane on Mon, 19 October 2015
4 1918 Tue, 20 October 2015 09:42
By: Duane
  Insert into table from another table based on joining column
Oracle 10
By: pratik4891 on Tue, 20 October 2015
4 1793 Tue, 20 October 2015 07:49
By: Michel Cadot
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: Fri Feb 12 17:16:07 CST 2016

Total time taken to generate the page: 0.15267 seconds