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
Confusion about data length in CLOB type variable in PL/SQL Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit By: mokarem on Tue, 20 January 2015	5	401	Wed, 21 January 2015 21:59 By: mokarem
Want to split value based on space if no space want to show null in second column 11g By: cplusplus1 on Mon, 19 January 2015	4	993	Wed, 21 January 2015 18:30 By: cplusplus1
How to control the inserting the new records when it cross the limits 11g, Window 8 By: Bilal Khan on Tue, 09 December 2014	21	1066	Wed, 21 January 2015 10:17 By: Solomon Yakobson
display group name By: sudeshna_bio08 on Tue, 20 January 2015	5	650	Tue, 20 January 2015 09:22 By: Lalit Kumar B
Finding SQL Query ... Oracle 11.2.0.1 on Linux By: suddhasatwa_oracle on Tue, 20 January 2015	5	667	Tue, 20 January 2015 06:26 By: Michel Cadot
How to get right side value after comma 11g By: cplusplus1 on Mon, 19 January 2015	7	767	Tue, 20 January 2015 00:18 By: Michel Cadot
issue with a select query using row_number oracle pl/sql By: marouene.lm on Thu, 15 January 2015	12	383	Mon, 19 January 2015 21:28 By: Barbara Boehmer
Logic to create new column in Oracle database - Multiple conditions making it more challenging By: tableaudev2010 on Fri, 16 January 2015	11	952	Sat, 17 January 2015 06:39 By: EdStevens
CR/LR in column Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 By: Duane on Fri, 16 January 2015	34	1165	Fri, 16 January 2015 13:40 By: Duane
XML Count rollup Oracle 10g By: zpele on Fri, 16 January 2015	4	676	Fri, 16 January 2015 12:36 By: BlackSwan
cursor_for_loop allows PL/SQL SELECT..INTO statement By: Lalit Kumar B on Mon, 12 January 2015	9	1122	Fri, 16 January 2015 10:04 By: Michel Cadot
How to calculate in percent in sql query? By: aaditya321 on Tue, 13 January 2015	31	1986	Thu, 15 January 2015 06:21 By: Lalit Kumar B
pl sql to XML conversion 11g ( 1 2) By: saniya on Tue, 13 January 2015	44	1884	Thu, 15 January 2015 01:03 By: Michel Cadot
SQL query for a project scheduler 11.2.0.3 By: Amine on Fri, 09 January 2015	21	3810	Wed, 14 January 2015 13:25 By: Amine
Handle duplicate Configurations (merged) By: jg5111 on Mon, 12 January 2015	21	1118	Wed, 14 January 2015 05:14 By: Lalit Kumar B
rownum query Oracle 10g By: sss111ind on Wed, 14 January 2015	10	959	Wed, 14 January 2015 02:22 By: sss111ind
Table Access Full Oracle 9i By: fairdaus on Tue, 13 January 2015	3	570	Tue, 13 January 2015 07:55 By: BlackSwan
Rollback in DBMS_PARALLEL_EXECUTE ORACLE 11G By: aravind.peddola@gmail.com on Tue, 13 January 2015	1	472	Tue, 13 January 2015 02:47 By: Michel Cadot
convert comma separated string to IN clause Oracle version 11g R2 By: robh0502 on Mon, 12 January 2015	5	256	Mon, 12 January 2015 14:22 By: Solomon Yakobson
LOB By: manishdba007 on Sun, 11 January 2015	3	873	Sun, 11 January 2015 12:15 By: Michel Cadot
How to count working day By: aaditya321 on Wed, 03 September 2014	17	1826	Sat, 10 January 2015 09:17 By: Lalit Kumar B
how to run PLSQL procedure in foreground in SQL command prompt By: victoryhendry on Fri, 09 January 2015	17	1518	Sat, 10 January 2015 08:20 By: BlackSwan
How to find Nth weekday from current date? Oracle 11g By: Oracle_Walker on Thu, 08 January 2015	8	2963	Sat, 10 January 2015 00:30 By: Michel Cadot
Generate flat file size more than 32767 oracle 11g By: gbpatelin on Fri, 09 January 2015	1	205	Fri, 09 January 2015 17:35 By: BlackSwan
Table design help By: gorants on Fri, 09 January 2015	12	793	Fri, 09 January 2015 14:51 By: gorants
calling proc with packag giving no output By: mist598 on Thu, 08 January 2015	5	1799	Fri, 09 January 2015 01:48 By: flyboy
how to loop and duplicate a string 11G By: kmmchan on Thu, 08 January 2015	2	1824	Fri, 09 January 2015 00:37 By: Michel Cadot
different outputs on same parameter (datatype date) while using 'like' and '=' oracle 10g By: jgjeetu on Thu, 08 January 2015	11	1108	Thu, 08 January 2015 09:42 By: Solomon Yakobson
Need to get only decimal values upto 2 digits if we have nothing in decimal points that has to be 0 oracle 11g R2 By: suramsmanu on Sun, 04 January 2015	6	2030	Thu, 08 January 2015 02:37 By: Lalit Kumar B
creation of view by passing the values dynamically 11.2.0.1 By: grpatwari on Wed, 07 January 2015	10	2953	Thu, 08 January 2015 00:58 By: grpatwari
How to find tables with nullable Unique Keys Oracle 11.2.0.4 By: testoli on Wed, 07 January 2015	1	1216	Wed, 07 January 2015 04:47 By: Michel Cadot
SYS_CONTEXT('USERENV','TERMINAL') gives "unknown" result in SQL Developer tool[split] By: prejib on Mon, 05 January 2015	9	243	Tue, 06 January 2015 10:14 By: Michel Cadot
Delete using a CTE By: system243trd on Tue, 06 January 2015	6	482	Tue, 06 January 2015 07:21 By: Lalit Kumar B
Sql querry needed for scenario By: asbh123 on Tue, 06 January 2015	16	2133	Tue, 06 January 2015 05:56 By: Michel Cadot
Check for missing records in 75 million records per day Oracle 11g R2 (11.2.0.3.0), OS: Red Hat Enterprice Linux By: bgraupe on Mon, 05 January 2015	20	2189	Tue, 06 January 2015 04:21 By: bgraupe
Find a column Name using data Oracle By: hrdeepakkumar on Mon, 05 January 2015	6	2047	Tue, 06 January 2015 04:11 By: Lalit Kumar B
Sql Querry based on condition By: asbh123 on Wed, 10 December 2014	2	2478	Tue, 06 January 2015 03:03 By: asbh123
Insert Query in between rows - SQL Oracle 11g By: rohit_shinez on Mon, 05 January 2015	20	337	Mon, 05 January 2015 14:21 By: EdStevens
Update statement updates all rows Oracle 7 By: rmccleave559 on Mon, 05 January 2015	14	297	Mon, 05 January 2015 09:38 By: cookiemonster
String to Number conversion Oracle 11G By: sinpeak on Mon, 05 January 2015	3	710	Mon, 05 January 2015 07:11 By: Maaher