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
Query to delete two weeks old data. Oracle 11g By: ajaykumarkona on Thu, 12 September 2013	3	498	Thu, 12 September 2013 13:16 By: Lalit Kumar B
dbms_lob.substr Oracle version 12.01, UNIX By: johanndut on Wed, 11 September 2013	13	957	Thu, 12 September 2013 02:10 By: johanndut
insert select in PLSQL Oracle 9i By: doron.simchoni on Sun, 08 September 2013	13	953	Thu, 12 September 2013 02:04 By: flyboy
Next multiple of 10 value for the given integer Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: saipradyumn on Tue, 10 September 2013	18	1246	Thu, 12 September 2013 01:35 By: saipradyumn
using regexp_replace to eliminate duplicate string with delimeter 11g Release 11.2.0.3.0 - 64bit Production By: lijok on Wed, 11 September 2013	12	507	Wed, 11 September 2013 19:25 By: ebrian
WILD CARD search Oracle 11g By: developer12 on Wed, 04 September 2013	5	629	Wed, 11 September 2013 14:30 By: Lalit Kumar B
Error: PLS-00103 in package ( 1 2) By: mist598 on Wed, 11 September 2013	40	1348	Wed, 11 September 2013 07:50 By: mist598
how to find the parent/host procedure's name within the procedure any version of oracle(preferrably 10g onwards) By: shashikoor1 on Fri, 06 September 2013	5	563	Wed, 11 September 2013 06:14 By: shashikoor1
mysql to oracle oracle 11g By: vkanuri on Fri, 06 September 2013	9	853	Wed, 11 September 2013 00:51 By: Michel Cadot
Select column values into array By: mvrk on Tue, 10 September 2013	10	566	Tue, 10 September 2013 13:51 By: LKBrwn_DBA
Oracle materialized view does not refresh in the package By: Oracletwister on Tue, 10 September 2013	6	525	Tue, 10 September 2013 04:51 By: Lalit Kumar B
delete non-ASCII characters Oracle 11g By: rc3d on Mon, 09 September 2013	14	892	Tue, 10 September 2013 02:56 By: Maaher
Dynamic SQL (column name) help 11g By: biohazardbill on Mon, 09 September 2013	23	1088	Tue, 10 September 2013 02:28 By: Maaher
Remove line breaks in Select statement Oracle By: SteveShephard on Mon, 09 September 2013	3	395	Mon, 09 September 2013 13:29 By: Lalit Kumar B
Plsql update query oracle 11g,linux By: shivarajnaik on Sun, 08 September 2013	5	478	Mon, 09 September 2013 02:31 By: Lalit Kumar B
Breaking up an expression to evaluate Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit By: dwitisabat@gmail.com on Wed, 04 September 2013	15	845	Fri, 06 September 2013 22:53 By: Lalit Kumar B
Enabling the Constraint With Enable No Validate By: saipradyumn on Thu, 05 September 2013	3	467	Fri, 06 September 2013 22:21 By: ebrian
select max date and Pk oracle 11g By: miroconnect@yahoo.com on Fri, 06 September 2013	4	519	Fri, 06 September 2013 15:47 By: miroconnect@yahoo.com
Connect by limit issue oracle 11g By: siraj.accet@gmail.com on Mon, 26 August 2013	17	1245	Fri, 06 September 2013 07:41 By: siraj.accet@gmail.com
Extracts subsets in the same query Oracle 11g By: athensromania on Thu, 05 September 2013	4	463	Fri, 06 September 2013 00:51 By: Michel Cadot
Get Total Sales Dollar Amount from two tables without cursor Oracle 9i By: amsteel on Wed, 28 August 2013	22	1294	Wed, 04 September 2013 20:17 By: amsteel
Hierarchial query - CONNECT_BY_LOOP Oracle 11g R2 By: nvembu on Wed, 04 September 2013	2	308	Wed, 04 September 2013 12:22 By: Michel Cadot
How to Select data when it has a single quote in the value. PL/SQL on Win 7 Pro 64bit By: jfranchi on Wed, 04 September 2013	8	723	Wed, 04 September 2013 11:14 By: pablolee
please convert this procedure to oracle. Oracle 11g By: ramya_162 on Wed, 04 September 2013	7	752	Wed, 04 September 2013 08:05 By: pablolee
Getting error when record type is used. Oracle 11g By: ajaykumarkona on Tue, 03 September 2013	16	862	Wed, 04 September 2013 01:43 By: _jum
set transaction use rollback oracle 9i By: doron.simchoni on Sat, 31 August 2013	21	1154	Tue, 03 September 2013 15:44 By: Lalit Kumar B
Need help to generate Procedure Execution LOG By: xbubai on Tue, 03 September 2013	21	974	Tue, 03 September 2013 07:58 By: gazzag
CREATE TABLE: tablename with data from subselect (variable) Oracle 10g By: oranooob on Mon, 02 September 2013	8	772	Tue, 03 September 2013 07:48 By: oranooob
get numbers which is not in the ORACLE 10G,sOLARIS By: prejib on Sun, 01 September 2013	9	815	Mon, 02 September 2013 14:05 By: Lalit Kumar B
Locking and foreign key indexes 9.2.0.8 By: Amine on Sun, 01 September 2013	33	2055	Mon, 02 September 2013 13:56 By: Lalit Kumar B
Simple example of (not) using an index By: Lalit Kumar B on Fri, 23 August 2013	8	761	Mon, 02 September 2013 12:57 By: Lalit Kumar B
Advice for procedure oracle ,10.2,windows95 By: krajasekhar.v on Mon, 02 September 2013	3	534	Mon, 02 September 2013 06:07 By: Michel Cadot
simple problem of creating a table inside execute immediate, but can not debug the error Oracle 10g, Win7 By: nischalinn on Tue, 27 August 2013	23	1562	Mon, 02 September 2013 05:59 By: gazzag
What is the Worng in this Code Oracle 11gr1 OEL5.5 64bit By: 9390512774 on Sun, 01 September 2013	2	490	Sun, 01 September 2013 10:53 By: Michel Cadot
How to scheduling a job from 8 am to 8 pm Oracle 10g By: sss111ind on Fri, 30 August 2013	8	693	Sat, 31 August 2013 06:38 By: sss111ind
Read csv File from Shared Location Oracle 10G, Windows XP By: sumedh7 on Fri, 30 August 2013	2	457	Sat, 31 August 2013 03:09 By: Littlefoot
creating a temporary table oracle 10g By: lacchhii on Fri, 30 August 2013	6	670	Fri, 30 August 2013 21:37 By: lacchhii
query help (if, else) oracle 11.2.0.3 By: BeefStu on Fri, 30 August 2013	1	243	Fri, 30 August 2013 15:18 By: Michel Cadot
Difference between two declaration. By: VIP2013 on Thu, 29 August 2013	5	476	Fri, 30 August 2013 03:36 By: pablolee
PLS-00497: cannot mix between single row and multi-row (BULK) in INTO list Oracle 11g By: pradeepashwathnarayan9 on Fri, 30 August 2013	2	487	Fri, 30 August 2013 03:15 By: cookiemonster