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
set target table flag as D if rows deleted at source oracle 11.2 By: deb171100 on Thu, 08 October 2015	2	1470	Fri, 09 October 2015 02:28 By: sandeep_orafaq
required date month year query oracle 10g express edition By: sudheerips on Fri, 02 October 2015	10	2404	Thu, 08 October 2015 08:02 By: Bill B
query correction required 11g By: amy.wilson on Wed, 07 October 2015	5	1450	Wed, 07 October 2015 23:21 By: Michel Cadot
CTE Queries 11g ( 1 2) By: amy.wilson on Wed, 30 September 2015	43	5384	Wed, 07 October 2015 08:11 By: flyboy
Checking the parameter inside Procedure (merged 2) By: hypesslearner on Wed, 07 October 2015	3	1254	Wed, 07 October 2015 06:25 By: Michel Cadot
oracle procedure oracle 10g ( 1 2) By: arun888 on Mon, 27 July 2015	61	13289	Tue, 06 October 2015 21:55 By: BlackSwan
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	3464	Tue, 06 October 2015 01:08 By: Michel Cadot
SQL with group by Oracle SQL 11g By: ramagirisrinivas on Fri, 02 October 2015	12	2224	Mon, 05 October 2015 08:52 By: Michel Cadot
Understand Difference between queries By: purnima1 on Thu, 01 October 2015	5	1677	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	1374	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	2274	Thu, 01 October 2015 09:17 By: cookiemonster
Check Constraints having alphanumeric Oracle 10g By: lokimisc on Wed, 30 September 2015	9	2306	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	2231	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	2227	Thu, 01 October 2015 05:34 By: Michel Cadot
Replace string based on condition 10g By: m.abdulhaq on Thu, 01 October 2015	5	1302	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	1430	Thu, 01 October 2015 02:28 By: Michel Cadot
Use of Force View By: ashok_nr23 on Mon, 09 January 2006	5	9395	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	1167	Wed, 30 September 2015 16:12 By: emyk
MERGE and SEQUENCE Oracle 11g By: yepp on Tue, 29 September 2015	9	9494	Wed, 30 September 2015 08:10 By: Solomon Yakobson
Recursive query oracle11.2.0.3 By: vasudevaviswa on Wed, 30 September 2015	1	1686	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	1820	Mon, 28 September 2015 19:07 By: BlackSwan
query rewrite By: gidiyap on Sun, 27 September 2015	4	1610	Mon, 28 September 2015 04:59 By: sandeep_orafaq
NVL vs IS NULL 12c By: deepakdot on Thu, 24 September 2015	12	26828	Fri, 25 September 2015 12:28 By: Michel Cadot
Procedure call through java By: rohit_shinez on Fri, 25 September 2015	3	1193	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	1801	Wed, 23 September 2015 22:44 By: Duane
% with ROWNUM SQL By: battaarchana on Tue, 22 September 2015	11	1954	Wed, 23 September 2015 07:39 By: Michel Cadot
Calling Procedure 11g By: P1Oracle on Thu, 17 September 2015	4	1725	Wed, 23 September 2015 07:10 By: sandeep_orafaq
Rownum By: satheesh_ss on Wed, 18 July 2012	14	4165	Tue, 22 September 2015 09:01 By: Solomon Yakobson
PLSQL_OPTIMIZE_LEVEL 12.x By: John Watson on Tue, 22 September 2015	1	1318	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	2776	Tue, 22 September 2015 04:42 By: cookiemonster
How to create named DEFAULT constraint Oracle SQL By: battaarchana on Tue, 15 September 2015	4	2133	Tue, 22 September 2015 03:25 By: battaarchana
Simple procedure select into procedure By: jclouser on Mon, 21 September 2015	5	1725	Mon, 21 September 2015 15:02 By: Littlefoot
How To Trunc Date In Oracle By: swti6690 on Mon, 21 September 2015	6	2387	Mon, 21 September 2015 07:16 By: cookiemonster
How to select last rate of Product 10g By: manisngpl on Sat, 19 September 2015	4	1562	Mon, 21 September 2015 04:47 By: dude4084
merge statement (merged :) By: sa_dwhite on Sat, 19 September 2015	15	3007	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	1867	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	1382	Sun, 20 September 2015 20:49 By: hungman
pl/sql By: ORA456 on Sun, 20 September 2015	4	1608	Sun, 20 September 2015 11:43 By: ORA456
DBMS_OUTPUT 11g By: P1Oracle on Thu, 17 September 2015	11	2236	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	3540	Thu, 17 September 2015 10:45 By: cookiemonster