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
  stored procedure to Inserting new rows and updating existing rows
11.2.0.3
By: amy.wilson on Mon, 02 November 2015
7 738 Tue, 03 November 2015 07:39
By: sandeep_orafaq
  Test query for SORT (merged)
12c
By: gkrishn on Mon, 02 November 2015
5 535 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 554 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 955 Mon, 02 November 2015 07:03
By: javon13
  case statement
pl/sql
By: amazeme on Fri, 30 October 2015
2 504 Fri, 30 October 2015 12:25
By: amazeme
  query
By: chatwidravi on Tue, 27 October 2015
7 577 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 967 Fri, 30 October 2015 03:39
By: javon13
  Sending SMS through Oracle Database
By: sarfraz_attari on Sat, 16 September 2006
25 12966 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 534 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 401 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 370 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 336 Wed, 28 October 2015 01:35
By: Michel Cadot
  Inclusion of duplicate records
By: rohit_shinez on Tue, 27 October 2015
2 410 Tue, 27 October 2015 13:43
By: rohit_shinez
  explicit and implicit functions in oracle
By: letolagal on Tue, 27 October 2015
3 510 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 509 Mon, 26 October 2015 07:58
By: ric90
  Searching through entire table.
By: jimjohn on Mon, 19 October 2015
10 2451 Mon, 26 October 2015 06:50
By: EdStevens
  remote database migration
Oracle 11.2.0.3
By: deb171100 on Mon, 26 October 2015
7 509 Mon, 26 October 2015 06:46
By: EdStevens
  To Split data based on dates
By: rohit_shinez on Tue, 13 October 2015
20 10236 Sun, 25 October 2015 18:19
By: Barbara Boehmer
  Compare values based on range
By: rohit_shinez on Sat, 24 October 2015
27 889 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 366 Fri, 23 October 2015 12:15
By: Michel Cadot
  Need answer for below block
By: rajesh_oracle on Fri, 23 October 2015
1 453 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 780 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 2576 Wed, 21 October 2015 13:24
By: Solomon Yakobson
  interview question asked (merged 3)
By: purnima1 on Wed, 21 October 2015
3 536 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 2230 Wed, 21 October 2015 08:11
By: Michel Cadot
  Parallel Procedure Run
Oracle 11g, Windows 7
By: Vijay55 on Wed, 21 October 2015
2 1836 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 2013 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 1933 Tue, 20 October 2015 07:49
By: Michel Cadot
  Filling values
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0
By: manubatham20 on Mon, 19 October 2015
2 445 Mon, 19 October 2015 10:40
By: manubatham20
  user schema can't create or alter job (merged 3)
oracle 12GR2
By: agung_prw on Thu, 15 October 2015
20 4993 Mon, 19 October 2015 03:19
By: gazzag
  Need few clarification on Alter table.
Oracle 11G, WIN7
By: gopieee16 on Fri, 16 October 2015
6 626 Mon, 19 October 2015 02:16
By: gopieee16
  in, out parameters
By: wisdomofmetis on Sat, 17 October 2015
2 500 Sat, 17 October 2015 07:51
By: Solomon Yakobson
  Create table with two tablespaces
oracle 11g
By: raopatwariyahoocom on Fri, 16 October 2015
8 454 Fri, 16 October 2015 11:22
By: John Watson
  To replace value where the date falls
Oracle 11g
By: rohit_shinez on Fri, 16 October 2015
3 472 Fri, 16 October 2015 10:50
By: rohit_shinez
  binary to hexadecimal conversion
oracle 11gr2
By: guddu_12 on Fri, 16 October 2015
5 416 Fri, 16 October 2015 10:27
By: John Watson
  I need to process a string with arithmetic operators
By: spgun on Thu, 15 October 2015
3 452 Thu, 15 October 2015 11:44
By: Bill B
  split data with levels
11.2.0.3
By: amy.wilson on Fri, 09 October 2015
18 1776 Thu, 15 October 2015 02:18
By: flyboy
  fine tuning my sql query for a grouping report
oracle 10g, oracle forms and reports developer suite
By: lacchhii on Wed, 14 October 2015
1 452 Thu, 15 October 2015 01:25
By: Michel Cadot
  questions about creating function
By: wisdomofmetis on Tue, 13 October 2015
3 613 Wed, 14 October 2015 09:48
By: CraigB
  Requirement to extract sql script output and attach the same in a email and send to multiple users
11g
By: avinashkk on Tue, 06 October 2015
9 998 Tue, 13 October 2015 09:36
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 Oct 01 17:45:27 CDT 2016

Total time taken to generate the page: 0.13225 seconds