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
Variable in PLSQL PLSQL Version 9 By: rbs100 on Sun, 12 July 2015	2	1915	Sun, 12 July 2015 09:29 By: BlackSwan
Swift message insert script oracle 11g By: Nusrat on Mon, 06 July 2015	10	8302	Sun, 12 July 2015 02:22 By: Nusrat
Default Value 11g database By: cool06prashant on Fri, 10 July 2015	3	2373	Sat, 11 July 2015 00:36 By: Michel Cadot
ORA-2014 on RLS-enabled table with double FGA policy RDBMS 11.2.0.3, Windows 2008 R2, 64-bit By: Alien on Fri, 10 July 2015	0	2449	Fri, 10 July 2015 14:43 By: Alien
Interesting explain plan output/puzzle 11.2.0.4.0 By: Roachcoach on Mon, 06 July 2015	8	6661	Fri, 10 July 2015 14:27 By: Alien
Get data from various partitions with having one extra column Oracle, Oracle Database 11g Express Edition Release 11.2.0.2.0 ,Win 7 Pro By: shumail on Wed, 08 July 2015	12	5794	Thu, 09 July 2015 05:18 By: pablolee
Partition table - High_Value in DD-MON-YYYY format Oracle 11.2.0.3, Linux x86 64 By: hitesh.bhatt on Thu, 09 July 2015	3	3643	Thu, 09 July 2015 05:17 By: Michel Cadot
How to use computed result of one row in the next row for inserting in table Oracle 11g By: raman.virk on Thu, 09 July 2015	0	2222	Thu, 09 July 2015 02:33 By: raman.virk
How to update substring using sql oracle 11g By: gorants on Wed, 08 July 2015	6	3725	Wed, 08 July 2015 12:07 By: BlackSwan
Extracting the Numeric values from a column in oracle Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: msinha8 on Tue, 07 July 2015	2	2198	Tue, 07 July 2015 08:53 By: msinha8
PL/SQL Cursor Oracle Database 12.1.0.2; Centos By: nqtrung on Tue, 07 July 2015	12	5693	Tue, 07 July 2015 03:57 By: pablolee
SQL query help oracle 11g By: gorants on Mon, 06 July 2015	8	3747	Tue, 07 July 2015 00:05 By: Michel Cadot
To get start and end date of month By: rohit_shinez on Mon, 06 July 2015	26	8004	Mon, 06 July 2015 12:40 By: BlackSwan
Oracle SQL Customization Oracle 12C By: deepakdot on Sat, 04 July 2015	12	5263	Mon, 06 July 2015 07:02 By: deepakdot
DRL for a particular condition By: saipavan.plsql on Mon, 06 July 2015	3	3149	Mon, 06 July 2015 05:00 By: Michel Cadot
want to delete 42k duplicate rows from table 18 mill rows 10g By: cplusplus1 on Wed, 01 July 2015	19	7684	Mon, 06 July 2015 02:32 By: pablolee
Last four weeks data Oracle 12c By: imranhemani on Sun, 05 July 2015	2	2663	Mon, 06 July 2015 00:02 By: Michel Cadot
need select query based on pl sql table oracle 11g By: mvrkr44 on Mon, 29 June 2015	2	2210	Sun, 05 July 2015 00:48 By: Kevin Meade
SQL Where Limitation Linux RHAT 6.5 on using oracle 11.2.0.4 By: ma251436 on Mon, 29 June 2015	6	4067	Sun, 05 July 2015 00:45 By: Kevin Meade
Data selection on basis of columns from two consecutive rows (merged) 11g oracle database , window os By: pankajmaurya55 on Sat, 04 July 2015	8	52560	Sat, 04 July 2015 04:57 By: Lalit Kumar B
SUM CASE date difference calculation Oracle SQL By: bowgieman on Thu, 02 July 2015	16	7279	Fri, 03 July 2015 11:07 By: Lalit Kumar B
construct full date based on value yyyymm 11g By: cplusplus1 on Fri, 23 January 2015	26	9535	Thu, 02 July 2015 11:27 By: Lalit Kumar B
REGEXP_REPLACE for different name variations Oracle 11g By: madsen on Wed, 01 July 2015	5	3035	Wed, 01 July 2015 08:57 By: Michel Cadot
REGEXP_REPLACE DISTINCT Mixed results ORACLE 11 By: skyschrei on Tue, 23 June 2015	14	8685	Wed, 01 July 2015 04:56 By: mnitu
Optimize PL/SQL code and get rid of one by one If then else statement check Oracle 11g By: raman.virk on Mon, 29 June 2015	6	4578	Tue, 30 June 2015 02:48 By: pablolee
is there any way to convert number into integer? oracle 11g By: mvrkr44 on Tue, 30 June 2015	16	6569	Tue, 30 June 2015 02:14 By: Roachcoach
Trigger on table to update other table APEX, Oracle 10g By: luijk008 on Sun, 28 June 2015	4	3547	Mon, 29 June 2015 14:03 By: Bill B
Execute a sql script depending on number of records in a table 11.2.0.4 on Linux By: orausern on Mon, 29 June 2015	8	3172	Mon, 29 June 2015 11:12 By: orausern
Oracle Table last access detail Oracle 11g By: ashish.tiwari on Fri, 26 June 2015	5	6050	Sun, 28 June 2015 00:27 By: Lalit Kumar B
default value on update in oracle 11G Oracle 11G , Windows 7 By: live4learn on Thu, 25 June 2015	2	6971	Fri, 26 June 2015 10:22 By: Bill B
Date format help oracle 11g By: gorants on Thu, 25 June 2015	3	2705	Fri, 26 June 2015 06:56 By: EdStevens
Update Join.. Oracle 11.2.0.4/Windows 64 bit By: sant_new1 on Thu, 25 June 2015	4	3421	Thu, 25 June 2015 10:23 By: sant_new1
pl/sql statement ignored By: raja_rani on Wed, 24 June 2015	9	8878	Thu, 25 June 2015 03:20 By: cookiemonster
Compressing the partitions 11.2..0.4 By: varunvir on Thu, 18 June 2015	8	4086	Wed, 24 June 2015 06:44 By: Roachcoach
Update a column in table only if a condition is met for number of values for a field in other table By: suhaas on Fri, 19 June 2015	10	5707	Tue, 23 June 2015 13:33 By: Bill B
Substitute variable in script oracle 11g r2 By: ajaapba on Mon, 22 June 2015	7	3482	Tue, 23 June 2015 09:20 By: gazzag
Date Parameter Issue By: dilip.nnitw@gmail.com on Mon, 22 June 2015	3	3445	Tue, 23 June 2015 04:13 By: dilip.nnitw@gmail.com
Design to Validate Staging records (merged) ORACLE 11g By: jagadeesh.nraj on Mon, 15 June 2015	10	5792	Mon, 22 June 2015 13:39 By: ravikanth_b
SQL Query Case and Count Oracle By: elements92 on Fri, 19 June 2015	6	3729	Mon, 22 June 2015 05:11 By: cookiemonster
date format from string Oracle 11g By: mape on Fri, 19 June 2015	16	6840	Mon, 22 June 2015 04:22 By: cookiemonster