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
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	1842	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	1485	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	1143	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	937	Wed, 28 October 2015 01:35 By: Michel Cadot
Inclusion of duplicate records By: rohit_shinez on Tue, 27 October 2015	2	1237	Tue, 27 October 2015 13:43 By: rohit_shinez
explicit and implicit functions in oracle By: letolagal on Tue, 27 October 2015	3	2607	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	1626	Mon, 26 October 2015 07:58 By: ric90
Searching through entire table. By: jimjohn on Mon, 19 October 2015	10	3912	Mon, 26 October 2015 06:50 By: EdStevens
remote database migration Oracle 11.2.0.3 By: deb171100 on Mon, 26 October 2015	7	1743	Mon, 26 October 2015 06:46 By: EdStevens
To Split data based on dates By: rohit_shinez on Tue, 13 October 2015	20	13026	Sun, 25 October 2015 18:19 By: Barbara Boehmer
Compare values based on range By: rohit_shinez on Sat, 24 October 2015	27	3075	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	941	Fri, 23 October 2015 12:15 By: Michel Cadot
Need answer for below block By: rajesh_oracle on Fri, 23 October 2015	1	1172	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	1941	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	6206	Wed, 21 October 2015 13:24 By: Solomon Yakobson
interview question asked (merged 3) By: purnima1 on Wed, 21 October 2015	3	1235	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	3063	Wed, 21 October 2015 08:11 By: Michel Cadot
Parallel Procedure Run Oracle 11g, Windows 7 By: Vijay55 on Wed, 21 October 2015	2	2707	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	3037	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	2893	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	1353	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	7878	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	2825	Mon, 19 October 2015 02:16 By: gopieee16
in, out parameters By: wisdomofmetis on Sat, 17 October 2015	2	1574	Sat, 17 October 2015 07:51 By: Solomon Yakobson
Create table with two tablespaces oracle 11g By: raopatwariyahoocom on Fri, 16 October 2015	8	2203	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	1519	Fri, 16 October 2015 10:50 By: rohit_shinez
binary to hexadecimal conversion oracle 11gr2 By: guddu_12 on Fri, 16 October 2015	5	5463	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	1265	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	4140	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	1362	Thu, 15 October 2015 01:25 By: Michel Cadot
questions about creating function By: wisdomofmetis on Tue, 13 October 2015	3	1791	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	2501	Tue, 13 October 2015 09:36 By: Bill B
Regular Expression Oracle 11.2.0.3 By: pointers on Thu, 08 October 2015	4	2178	Tue, 13 October 2015 09:27 By: Bill B
How To See Latest created Table Including Time in oracle. Is there any table for it? Oarcle 11g By: graphe on Thu, 08 October 2015	7	2321	Tue, 13 October 2015 09:22 By: Bill B
HOW TO STORE ROWID DATA BY USING ROWID DATA TYPE? oracle 11g By: graphe on Tue, 13 October 2015	6	1937	Tue, 13 October 2015 08:53 By: Bill B
groups in regexp_instr Oracle 10g By: m.abdulhaq on Wed, 07 October 2015	6	1849	Tue, 13 October 2015 04:12 By: m.abdulhaq
How to get weeknum for the given date By: blyzz on Fri, 09 October 2015	4	2367	Mon, 12 October 2015 14:17 By: Michel Cadot
single row subquery returns more than one row 11g R2 By: manoj12 on Mon, 12 October 2015	4	1514	Mon, 12 October 2015 08:05 By: cookiemonster
what is the main usage of execute immediate. 11g By: sudheerips on Mon, 12 October 2015	3	1364	Mon, 12 October 2015 05:08 By: _jum
Rownum per day Oracle DB 11.2.0.4 By: DirkHamburg on Fri, 09 October 2015	2	1255	Fri, 09 October 2015 07:13 By: DirkHamburg