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 :: Show Polls :: Message Navigator

Topic	Replies	Views	Last message
Add a new column on first position of table in existing table. Oracle 11g By: na.dharma@gmail.com on Thu, 16 January 2014	8	670	Fri, 17 January 2014 01:18 By: Michel Cadot
Primary Key in another Index Oracle 11g, 11.2.0.2 Linux 64b By: sujitm30 on Thu, 16 January 2014	3	284	Fri, 17 January 2014 01:15 By: evivek
cursor loop oracle 11 g By: simplesanju on Wed, 15 January 2014	2	315	Thu, 16 January 2014 03:35 By: simplesanju
Time out error in JAVA application when backend package is calling By: na.dharma@gmail.com on Thu, 16 January 2014	5	274	Thu, 16 January 2014 01:16 By: Michel Cadot
why would this query return three rows? By: nataliafoster26 on Wed, 15 January 2014	2	265	Wed, 15 January 2014 15:11 By: Michel Cadot
SQL to generate sequential numbers for each repeating row and reset upon new key Oracle 9i R2 By: yasar2002 on Wed, 11 December 2013	4	712	Wed, 15 January 2014 08:01 By: Michel Cadot
Want to use date variable value in select query 11g By: cplusplus1 on Tue, 14 January 2014	7	928	Tue, 14 January 2014 09:44 By: cookiemonster
ORA-01481: invalid number format model By: jackxu on Tue, 14 January 2014	4	547	Tue, 14 January 2014 09:43 By: BlackSwan
How to find last sunday of month By: aaditya321 on Tue, 14 January 2014	5	316	Tue, 14 January 2014 07:52 By: Solomon Yakobson
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired while gathering stats Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit By: athensromania on Mon, 13 January 2014	8	771	Tue, 14 January 2014 04:03 By: ThomasG
Search String oracle 10g,win xp By: Xandot on Tue, 14 January 2014	2	296	Tue, 14 January 2014 02:47 By: Xandot
Syntax for similar Pattern between the tables Oracle 10 and 11g By: imransi17@gmail.com on Mon, 13 January 2014	2	252	Tue, 14 January 2014 00:15 By: Michel Cadot
Can someone help me with this By: pingiliarjun on Thu, 09 January 2014	6	364	Mon, 13 January 2014 15:56 By: Bill B
Re: XML issue (split from hijacked thread http://www.orafaq.com/forum/t/189540/) By: KimberlyDeborah on Sat, 11 January 2014	2	236	Mon, 13 January 2014 04:45 By: KimberlyDeborah
correct week number oracle 11g By: guddu_12 on Fri, 10 January 2014	5	383	Mon, 13 January 2014 04:38 By: guddu_12
Find the last process in string oracle 10g,win xp By: Xandot on Fri, 10 January 2014	2	252	Sun, 12 January 2014 11:50 By: Xandot
Permutation combination ORACLE PL/SQL By: banyan_sg on Wed, 08 January 2014	18	888	Sun, 12 January 2014 04:34 By: Solomon Yakobson
Case statement not working Oracle 11g By: kumaran22 on Fri, 10 January 2014	2	198	Fri, 10 January 2014 15:23 By: Michel Cadot
i wanto to return One single row into column. Oracle 11g By: na.dharma@gmail.com on Fri, 10 January 2014	5	486	Fri, 10 January 2014 12:54 By: pablolee
How to display the letter starting with "B" followed by number only. Oracle 11g By: ajaykumarkona on Thu, 09 January 2014	13	670	Fri, 10 January 2014 05:22 By: gazzag
How to find total no of employee and no of employee in given years By: aaditya321 on Tue, 07 January 2014	8	498	Fri, 10 January 2014 04:14 By: cookiemonster
User who executed the Job oracle 10.1.0.2.0 By: pstanand on Fri, 10 January 2014	1	167	Fri, 10 January 2014 01:38 By: Michel Cadot
Please provide equivalent update for this merge query. Oracle 11g By: ajaykumarkona on Thu, 09 January 2014	5	293	Thu, 09 January 2014 22:17 By: BlackSwan
Loops Oracle 11g, XP By: rajivn786 on Wed, 08 January 2014	4	330	Thu, 09 January 2014 13:08 By: rajivn786
To display count for each day in a month 10g By: 367364 on Mon, 06 January 2014	21	933	Thu, 09 January 2014 12:43 By: Solomon Yakobson
How to read UNCOMMITED data in Oracle? Oracle 11g Enterprise Edition 11.2.0.1.0 - Linux 2.6 By: usaha1 on Thu, 09 January 2014	12	523	Thu, 09 January 2014 05:46 By: usaha1
SELECT * FROM OPENQUERY([127.0.0.1],'@cmd') (merged) By: phuong on Mon, 21 May 2007	7	1700	Wed, 08 January 2014 18:33 By: BlackSwan
UPDATE only rows which match another table By: alexandercioby on Tue, 07 January 2014	7	597	Wed, 08 January 2014 15:19 By: joy_division
weighted average or moving average calculation for stock Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod By: hissam78 on Sat, 04 January 2014	3	390	Wed, 08 January 2014 13:54 By: hissam78
compare null in decode By: mist598 on Wed, 08 January 2014	7	446	Wed, 08 January 2014 12:19 By: Solomon Yakobson
Group the same values and show the ascending order. Oracle 11g By: na.dharma@gmail.com on Wed, 08 January 2014	2	126	Wed, 08 January 2014 10:10 By: BlackSwan
sql code error meaning Oracle 11g, Win7 By: nischalinn on Wed, 08 January 2014	10	418	Wed, 08 January 2014 06:11 By: pablolee
Read a .csv file which has more than 45000 Characters By: sivakarthick on Wed, 08 January 2014	7	335	Wed, 08 January 2014 04:31 By: gazzag
can a string be used with IN within a query? 11g By: VAC357 on Tue, 07 January 2014	5	260	Tue, 07 January 2014 14:14 By: Michel Cadot
duplicate column By: nataliafoster26 on Mon, 06 January 2014	9	541	Tue, 07 January 2014 07:12 By: gazzag
DML written on a script autocommits after a DDL in the same script without any commit statements? oracle,10g,xp By: evivek on Tue, 07 January 2014	3	188	Tue, 07 January 2014 05:07 By: evivek
Dynamic Column List in Select query oracle 11g linux By: deepa_balu on Mon, 06 January 2014	5	343	Tue, 07 January 2014 03:28 By: dariyoosh
Can a procedure have multiple OUT sy_refcursor oracle 11g By: gentleman777us on Mon, 06 January 2014	4	272	Tue, 07 January 2014 02:13 By: Michel Cadot
How to Display Multiple rows in a single row but in different columns Oracle 11.2 By: deepugun on Mon, 06 January 2014	6	462	Tue, 07 January 2014 01:57 By: Lalit Kumar B
Decode explanation By: mist598 on Mon, 06 January 2014	2	230	Tue, 07 January 2014 00:03 By: mist598