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
  ORA-01722: invalid number ORA-02063: preceding line from
By: mist598 on Thu, 15 December 2016
3 770 Thu, 15 December 2016 03:07
By: Michel Cadot
  Comparing CAST (multiset) with Bulk Collect
11.0.2.10
By: OraFerro on Wed, 14 December 2016
4 609 Wed, 14 December 2016 06:59
By: Solomon Yakobson
  Help in Listagg Query???
Oracle 11g
By: arifs3738 on Tue, 13 December 2016
3 475 Tue, 13 December 2016 03:14
By: pablolee
  Bulk bind a single attribute of a collection
Oracle 11.2.0.3
By: pointers on Wed, 14 December 2016
2 367 Wed, 14 December 2016 21:11
By: Barbara Boehmer
  create trigger error in SQL
By: equa on Fri, 09 December 2016
2 553 Fri, 09 December 2016 03:00
By: Michel Cadot
  ORA-30006 Resource Busy, acquired with Wait timeout expired
Oracle 10g, Forms 6i
By: chat2raj.s on Thu, 08 December 2016
13 2329 Thu, 08 December 2016 06:35
By: chat2raj.s
  Update Vs Delete&insertion
Oracle 11
By: saipradyumn on Mon, 12 December 2016
9 692 Thu, 15 December 2016 00:47
By: saipradyumn
  Sending a Password protected PDF using utl_smtp
By: dineshkumar18 on Mon, 12 December 2016
8 913 Tue, 13 December 2016 08:09
By: Michel Cadot
  AND criteria in where clause
By: blyzz on Wed, 07 December 2016
5 643 Mon, 12 December 2016 07:20
By: Solomon Yakobson
  Package Specification varaible
Oracle 11g
By: saipradyumn on Wed, 07 December 2016
14 1071 Fri, 09 December 2016 10:39
By: Michel Cadot
icon3.gif Trigger on Materialized View Log tables
ORACLE 11G Version 11.2.0.3.0
By: arunrajv@yahoo.com on Wed, 07 December 2016
7 682 Wed, 07 December 2016 23:02
By: arunrajv@yahoo.com
  Long data type in oracle
Oracle 11
By: saipradyumn on Tue, 06 December 2016
20 1322 Fri, 09 December 2016 09:51
By: BlackSwan
  SYS.DBMS_APPLICATION_INFO.READ_CLIENT_INFO bad result
By: pcouas on Mon, 05 December 2016
7 592 Tue, 06 December 2016 01:03
By: Michel Cadot
  Query For N number to top Sales in Region
oracle 10 g
By: annu-agi on Sun, 04 December 2016
6 521 Mon, 05 December 2016 01:18
By: Michel Cadot
  materialize view logs rfresh
oracle 11gr2
By: guddu_12 on Fri, 02 December 2016
5 1026 Mon, 05 December 2016 08:29
By: Bill B
  How to check if time is attached with date?
10.2.0
By: bluetooth420 on Wed, 30 November 2016
11 1045 Fri, 02 December 2016 03:14
By: cookiemonster
  dynamic sql to grant privilege
11g
By: raj85844 on Wed, 30 November 2016
17 1762 Fri, 16 December 2016 05:24
By: raj85844
  how to search for two characters in any sequence, with or without alphanumeric characters in between
Oracle 11g, 12c
By: namitanamburi on Tue, 29 November 2016
13 826 Tue, 29 November 2016 15:36
By: Bill B
  Function MAX
Oracle 11g
By: tomekw on Thu, 01 December 2016
3 598 Thu, 01 December 2016 10:08
By: Michel Cadot
  How to pass date parameters in dynamic sql?
PL sql
By: nukala on Mon, 28 November 2016
8 877 Tue, 29 November 2016 07:38
By: EdStevens
  Function returns Record - How to select
By: vactirio on Fri, 25 November 2016
8 860 Sat, 26 November 2016 06:44
By: vactirio
  using rownum
oracle 10 g
By: akash123 on Fri, 25 November 2016
14 996 Fri, 25 November 2016 07:06
By: Bill B
  Trigger to prevent update/delete/insert operation
By: ram_new_to_oracle on Thu, 24 November 2016
4 861 Fri, 25 November 2016 03:18
By: cookiemonster
  How to generate a insert script as it is what ever we running the insert script?
insert into dept(deptno,dname,loc) values (70,'PERSONNEL','DALLAS')
By: narendraenamala on Thu, 24 November 2016
9 925 Sat, 26 November 2016 04:40
By: Michel Cadot
  SQL Query Update
11g
By: glmjoy on Thu, 24 November 2016
4 498 Thu, 24 November 2016 06:11
By: msol25
  complex query
oracle
By: bikashp on Wed, 23 November 2016
1 512 Wed, 23 November 2016 06:35
By: Michel Cadot
  Oracle Outer join Operator(+) with operand of OR or IN
Oracle, 11g, Windows 7
By: azamkhan on Mon, 23 January 2017
1 336 Mon, 23 January 2017 00:22
By: Michel Cadot
  Element exists in a collection
Oracle 11.2.0.3
By: pointers on Fri, 02 December 2016
3 737 Fri, 02 December 2016 06:43
By: Solomon Yakobson
  Trigger to prevent delete according to select
11.0.2.10
By: OraFerro on Tue, 22 November 2016
9 927 Thu, 24 November 2016 08:16
By: ALEXWE
  Show all months between 2 months in a group by query
Oracle 11g
By: avni on Mon, 21 November 2016
1 674 Mon, 21 November 2016 03:09
By: Michel Cadot
  Please provide best approach to design ETL in Oracle.
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: msol25 on Thu, 24 November 2016
4 463 Thu, 24 November 2016 07:20
By: John Watson
  Correct order of data in Hierarchical Query
Oracle 12c
By: ramjss on Sat, 19 November 2016
13 1272 Tue, 06 December 2016 04:29
By: ramjss
  electronic data sharding
By: sudeepto chattaraj on Fri, 18 November 2016
14 1136 Tue, 22 November 2016 07:26
By: EdStevens
  Update Table Based On Another Table
oracle 11g, windows server
By: morissa on Fri, 18 November 2016
14 4791 Tue, 22 November 2016 03:38
By: cookiemonster
  Rows not populating
Oracle DB 12c
By: krishna.orcl97 on Fri, 18 November 2016
9 694 Fri, 18 November 2016 14:18
By: BlackSwan
  Oracle 11g Ntile function on top of Dense_rank
By: raj85844 on Wed, 16 November 2016
1 420 Wed, 16 November 2016 23:36
By: raj85844
  Calling procedure from trigger
Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - 64bit Windows 7
By: SW26477 on Wed, 16 November 2016
2 555 Wed, 16 November 2016 10:32
By: Michel Cadot
icon9.gif PL/SQL Email
Oracle 11gr2
By: VariableReset on Sat, 12 November 2016
3 732 Sat, 12 November 2016 06:48
By: VariableReset
  spool sql data in excel multi sheets
By: Preeti123456 on Thu, 10 November 2016
3 745 Fri, 11 November 2016 04:17
By: pablolee
  Need to match combination string at database
Oracle 11g, AIX server
By: Shan.kumar on Thu, 10 November 2016
12 7677 Mon, 14 November 2016 00:21
By: Shan.kumar
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 Nov 22 05:05:20 CST 2017

Total time taken to generate the page: 0.03460 seconds