OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL

Please read the OraFAQ Forum Guide before posting.

Please contribute good answers to the wiki.

Show: Today's Messages :: Unanswered Messages :: Polls :: Message Navigator

Topic	Replies	Views	Last message
What is the Difference b/w Up datable Views and Non-Up datable Views their uses Oracle 11g By: graphe on Thu, 01 October 2015	13	6299	Tue, 06 October 2015 01:08 By: Michel Cadot
SQL with group by Oracle SQL 11g By: ramagirisrinivas on Fri, 02 October 2015	12	4141	Mon, 05 October 2015 08:52 By: Michel Cadot
Understand Difference between queries By: purnima1 on Thu, 01 October 2015	5	2939	Mon, 05 October 2015 04:29 By: purnima1
insert data into column same table oracle,11.2.0.3,win 07 By: ORA456 on Sat, 03 October 2015	2	2045	Sat, 03 October 2015 09:22 By: Michel Cadot
HOW TO UPDATE ONE FIELD IN A TABLE BASED ON OTHER ? ORACLE 11G By: ibnelyas on Thu, 01 October 2015	9	4033	Thu, 01 October 2015 09:17 By: cookiemonster
Check Constraints having alphanumeric Oracle 10g By: lokimisc on Wed, 30 September 2015	9	4058	Thu, 01 October 2015 09:13 By: lokimisc
DBMS_AQ 10.1.0.5.0 - 64bit, Windows 7 By: suyogsheth on Thu, 01 October 2015	4	3436	Thu, 01 October 2015 06:38 By: Michel Cadot
SQL*Net message from dblink Oracle 11g By: mad_man12 on Thu, 01 October 2015	7	3493	Thu, 01 October 2015 05:34 By: Michel Cadot
Replace string based on condition 10g By: m.abdulhaq on Thu, 01 October 2015	5	2305	Thu, 01 October 2015 04:20 By: m.abdulhaq
Oracle Defined Function (DECODE) oracle all versions By: adi_gang on Thu, 01 October 2015	1	2100	Thu, 01 October 2015 02:28 By: Michel Cadot
Use of Force View By: ashok_nr23 on Mon, 09 January 2006	5	10766	Thu, 01 October 2015 01:03 By: graphe
Unable to pass date variables into a stored procedure Oracle SQL By: emyk on Wed, 30 September 2015	2	1868	Wed, 30 September 2015 16:12 By: emyk
MERGE and SEQUENCE Oracle 11g By: yepp on Tue, 29 September 2015	9	11890	Wed, 30 September 2015 08:10 By: Solomon Yakobson
Recursive query oracle11.2.0.3 By: vasudevaviswa on Wed, 30 September 2015	1	2393	Wed, 30 September 2015 04:29 By: Lalit Kumar B
No numbers on Imbalance and Variance... 11.2.0.3.x and Solaris 10 By: James Bennett on Mon, 28 September 2015	5	2784	Mon, 28 September 2015 19:07 By: BlackSwan
query rewrite By: gidiyap on Sun, 27 September 2015	4	2529	Mon, 28 September 2015 04:59 By: sandeep_orafaq
NVL vs IS NULL 12c By: deepakdot on Thu, 24 September 2015	12	29076	Fri, 25 September 2015 12:28 By: Michel Cadot
Procedure call through java By: rohit_shinez on Fri, 25 September 2015	3	2013	Fri, 25 September 2015 11:25 By: Michel Cadot
Using Procedure/Function in a Select Statement Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 By: Duane on Wed, 23 September 2015	8	3230	Wed, 23 September 2015 22:44 By: Duane
% with ROWNUM SQL By: battaarchana on Tue, 22 September 2015	11	3587	Wed, 23 September 2015 07:39 By: Michel Cadot
Calling Procedure 11g By: P1Oracle on Thu, 17 September 2015	4	2659	Wed, 23 September 2015 07:10 By: sandeep_orafaq
Rownum By: satheesh_ss on Wed, 18 July 2012	14	7312	Tue, 22 September 2015 09:01 By: Solomon Yakobson
PLSQL_OPTIMIZE_LEVEL 12.x By: John Watson on Tue, 22 September 2015	1	2008	Tue, 22 September 2015 04:46 By: cookiemonster
Get Max Value of Date Column With Condition 11g By: elmousa68 on Tue, 22 September 2015	13	4250	Tue, 22 September 2015 04:42 By: cookiemonster
How to create named DEFAULT constraint Oracle SQL By: battaarchana on Tue, 15 September 2015	4	3004	Tue, 22 September 2015 03:25 By: battaarchana
Simple procedure select into procedure By: jclouser on Mon, 21 September 2015	5	2703	Mon, 21 September 2015 15:02 By: Littlefoot
How To Trunc Date In Oracle By: swti6690 on Mon, 21 September 2015	6	3600	Mon, 21 September 2015 07:16 By: cookiemonster
How to select last rate of Product 10g By: manisngpl on Sat, 19 September 2015	4	2557	Mon, 21 September 2015 04:47 By: dude4084
merge statement (merged :) By: sa_dwhite on Sat, 19 September 2015	15	5363	Mon, 21 September 2015 02:58 By: flyboy
how to loop within sql statement without using PL/SQL Block By: ramya29p on Thu, 17 September 2015	6	2969	Mon, 21 September 2015 01:21 By: Michel Cadot
query same table multiple times Oracle DB 11gR2 By: hungman on Sun, 20 September 2015	0	1818	Sun, 20 September 2015 20:49 By: hungman
pl/sql By: ORA456 on Sun, 20 September 2015	4	2541	Sun, 20 September 2015 11:43 By: ORA456
DBMS_OUTPUT 11g By: P1Oracle on Thu, 17 September 2015	11	4185	Thu, 17 September 2015 14:09 By: Michel Cadot
SQL to get amounts by type Oracle RDBMS 11G By: oteixeira on Thu, 17 September 2015	25	6756	Thu, 17 September 2015 10:45 By: cookiemonster
Pivot By: tunny2014 on Thu, 17 September 2015	8	4481	Thu, 17 September 2015 09:03 By: BlackSwan
Query running fine in TOAD and SQL developer but very slow in Server ( oracle DB) [merged 2] By: saurabh.sha on Fri, 11 September 2015	20	13975	Thu, 17 September 2015 07:04 By: cookiemonster
Table patition and aautomate sub partition. By: raopatwariyahoocom on Tue, 15 September 2015	9	9369	Wed, 16 September 2015 11:49 By: BlackSwan
Options for definitions of INDEXES used by CONSTRAINTS By: mjm22 on Tue, 15 September 2015	2	3435	Wed, 16 September 2015 01:56 By: John Watson
Dynamic SQL in cursor By: phiroc on Mon, 14 September 2015	21	7120	Tue, 15 September 2015 11:05 By: cookiemonster
Using constants By: phiroc on Mon, 14 September 2015	5	2971	Tue, 15 September 2015 10:40 By: phiroc