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
Identify bottlenecks in queries Oracle, Oracle Database 11g Express Edition Release 11.2.0.2.0 ,Win 7 Pro By: shumail on Sun, 24 May 2015	13	5568	Fri, 29 May 2015 11:10 By: shumail
better query other than multiple for loop's? By: mist598 on Fri, 29 May 2015	8	3902	Fri, 29 May 2015 09:43 By: BlackSwan
Increasing Initrans for Partitioned table without re-creating it Oracle 11g (11.2.0.4) By: venkatesh_b on Wed, 27 May 2015	11	21938	Thu, 28 May 2015 14:50 By: BlackSwan
Interview questions By: purnima1 on Mon, 25 May 2015	8	4467	Thu, 28 May 2015 01:25 By: Michel Cadot
Procedure is taking more time to execute oracle 10g windows 7 By: nayana08 on Thu, 21 May 2015	22	6408	Tue, 26 May 2015 14:01 By: John Watson
Problem with calculating hours oracle sql 10g By: ifti6650 on Mon, 25 May 2015	9	4351	Mon, 25 May 2015 10:13 By: BlackSwan
Need Help on query oracle 10g By: samyms on Sun, 10 May 2015	9	3970	Fri, 22 May 2015 08:19 By: BlackSwan
Select max date in row of columns. . . Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: fluffycone on Thu, 21 May 2015	5	4079	Thu, 21 May 2015 14:01 By: EdStevens
string aggregation oracle 11g By: patneel on Thu, 21 May 2015	2	2179	Thu, 21 May 2015 12:47 By: Michel Cadot
date Format error sql oracle By: palpali on Thu, 21 May 2015	9	5083	Thu, 21 May 2015 09:13 By: Bill B
Error in execution of Trigger oracle 10g By: jgjeetu on Thu, 21 May 2015	11	4265	Thu, 21 May 2015 08:49 By: Bill B
does any one use oracle v12? oracle v12 By: LargeHadronCollider on Thu, 21 May 2015	13	5050	Thu, 21 May 2015 07:26 By: LargeHadronCollider
Error using INTO clause in execute immediate oracle 10g By: jgjeetu on Thu, 21 May 2015	4	3335	Thu, 21 May 2015 05:12 By: jgjeetu
DELETING of RECORDS simultaneously. By: saipavan.plsql on Wed, 20 May 2015	6	3811	Thu, 21 May 2015 03:41 By: naga.oracle
Date validation 11g By: rohit_shinez on Sat, 16 May 2015	9	4271	Wed, 20 May 2015 07:23 By: Lalit Kumar B
Row length of table in Oracle By: irfankundi786@yahoo.com on Mon, 18 May 2015	24	6682	Wed, 20 May 2015 05:21 By: Michel Cadot
ERROR-ORA-06533: Subscript beyond count By: ritubhayana on Wed, 20 May 2015	2	5452	Wed, 20 May 2015 03:28 By: Michel Cadot
Round Robin implementaion through sql script Oracle 10g By: virmahi on Thu, 19 August 2010	22	16820	Wed, 20 May 2015 02:51 By: cookiemonster
Subquery with multiple rows oracle db 10g By: aruntutor on Tue, 19 May 2015	3	2416	Wed, 20 May 2015 01:00 By: flyboy
Dirty read issues By: raj_te on Fri, 15 May 2015	7	3727	Tue, 19 May 2015 08:04 By: Bill B
what is the difference between "generated always as" and "as" at the time of creating virtual column oracle 11g By: jgjeetu on Tue, 19 May 2015	3	2591	Tue, 19 May 2015 06:17 By: Lalit Kumar B
regexp_replace comma separated whole string Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: manubatham20 on Mon, 18 May 2015	10	3907	Mon, 18 May 2015 14:58 By: manubatham20
Asp.Net Application hangs until oracle package is recompiled Oracle Database 11g Release 11.2.0.1.0 64bit CentOS 6.5 By: praveenpraj on Tue, 27 January 2015	8	4426	Mon, 18 May 2015 03:40 By: praveenpraj
Procedure creation error - PLS-00103 Oracle 11.2.0.3, Linux x86 64 By: hitesh.bhatt on Mon, 18 May 2015	6	14253	Mon, 18 May 2015 03:00 By: Lalit Kumar B
vpd condition with joins in DataWarehouse oracle 11g By: Droryash on Thu, 14 May 2015	6	4227	Mon, 18 May 2015 00:55 By: Droryash
Calculation of Day, month and year Oracle 11g, Window 7 By: Bilal Khan on Fri, 15 May 2015	6	3543	Sun, 17 May 2015 13:41 By: Barbara Boehmer
Format check on varchar check!! Oracle 11g By: kaltiimaar on Sun, 17 May 2015	15	5473	Sun, 17 May 2015 09:55 By: Michel Cadot
Inserting records in Table using cursor Oracle 11g ( 1 2) By: rohit_shinez on Sun, 10 May 2015	41	12296	Sat, 16 May 2015 08:13 By: BlackSwan
Row level lock after updation windows 7,oracle 10g, form builder 10g By: hcdba on Fri, 15 May 2015	8	4057	Fri, 15 May 2015 09:12 By: Lalit Kumar B
Select best 2 value out of 3 three values Oracle 11g, Window 7 By: Bilal Khan on Thu, 14 May 2015	5	2977	Fri, 15 May 2015 01:54 By: Bilal Khan
replace number in column By: hassan08 on Wed, 13 May 2015	6	3201	Thu, 14 May 2015 11:39 By: Michel Cadot
Viewing Object values in select and fill (multiple rows) 11.2.0.1.0 By: OraFerro on Thu, 14 May 2015	4	2544	Thu, 14 May 2015 11:36 By: Michel Cadot
dbms_scheduler -WeekDays scheduling program. Oracle 11g, Windows By: vicktorz on Thu, 14 May 2015	2	2022	Thu, 14 May 2015 07:38 By: BlackSwan
want data of all columns in a single column (no concatenate) oracle 10g/11g By: jgjeetu on Thu, 14 May 2015	7	3486	Thu, 14 May 2015 07:35 By: jgjeetu
Query using Partitioning Oracle 11 G release R1 By: saurabh.sha on Wed, 13 May 2015	4	2848	Thu, 14 May 2015 07:32 By: John Watson
To take Previous date Oracle 11g By: rohit_shinez on Wed, 13 May 2015	8	3257	Wed, 13 May 2015 16:28 By: John Watson
Transpose/Pivot with all combination By: jjxxs on Wed, 13 May 2015	2	2051	Wed, 13 May 2015 08:20 By: Michel Cadot
CREATE ANY PACKAGE alternative Oracle 10g By: Gnans on Wed, 13 May 2015	4	2341	Wed, 13 May 2015 08:09 By: mnitu
Temporary table space error Oracle 8i By: harshal_lagwankar on Tue, 12 May 2015	11	4795	Wed, 13 May 2015 00:43 By: harshal_lagwankar
Trigger associated with two Database By: jknath on Mon, 11 May 2015	3	2532	Tue, 12 May 2015 08:10 By: Bill B