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
QUERY HELP ORACLE 11G By: DivP on Wed, 31 August 2016	4	1755	Wed, 31 August 2016 15:16 By: DivP
finding previous quarter end date By: lappi on Tue, 30 August 2016	13	8303	Wed, 31 August 2016 08:22 By: Michel Cadot
Help required in SQL Analytic Funciton Oracle 11g 11.2.0.1.0 By: jimit_shaili on Wed, 31 August 2016	2	1462	Wed, 31 August 2016 06:55 By: Michel Cadot
Insert data into SYSTEM partitioned table using DB link Oracle 11g Release 2, Linux By: anil_mk on Tue, 30 August 2016	4	2503	Wed, 31 August 2016 05:34 By: anil_mk
query to write rows to column values 11.2.0.4 By: grpatwari on Tue, 31 May 2016	13	4342	Mon, 29 August 2016 23:00 By: grpatwari
Selective count with a condition Oracle SQL 11G By: vickytalware on Thu, 25 August 2016	8	14092	Fri, 26 August 2016 23:25 By: vickytalware
How to identify the partition type Oracle 11 By: saipradyumn on Tue, 23 August 2016	5	1874	Fri, 26 August 2016 02:46 By: saipradyumn
Minus Minutes 11g By: glmjoy on Fri, 26 August 2016	9	2091	Fri, 26 August 2016 02:43 By: glmjoy
Script Help SQL Developer By: kolpalamayaw on Tue, 16 August 2016	4	1820	Thu, 25 August 2016 09:40 By: ALEXWE
how to restrict set of data in oracle oracle,12.1.0.2.0 ,windows7 By: saini006 on Thu, 25 August 2016	3	1672	Thu, 25 August 2016 07:51 By: Michel Cadot
Query to get Middle Record from a table Oracle 11g By: arifs3738 on Wed, 24 August 2016	8	4276	Thu, 25 August 2016 06:37 By: EdStevens
Union of 4 different columns in Single Row SQL, PLSQL By: anil_apps on Wed, 24 August 2016	4	1738	Thu, 25 August 2016 00:44 By: Michel Cadot
Sequence partition clause DB12.x (and possibly earlier) By: John Watson on Tue, 23 August 2016	2	4196	Tue, 23 August 2016 03:15 By: John Watson
Need to correlate and reconcile two data sets with different number of records Oracle Database, 10g Rel.2 , Windows Server 2012 By: mazam on Mon, 22 August 2016	1	1839	Mon, 22 August 2016 13:54 By: Barbara Boehmer
How to remove duplicate value from type in SQL Oracle 11i,Toad By: victoryhendry on Tue, 16 August 2016	6	2874	Mon, 22 August 2016 04:51 By: sandeep_orafaq
connect by prior help 11G By: sanjuchand on Sat, 20 August 2016	4	2544	Sun, 21 August 2016 11:00 By: sanjuchand
Dropping tables in a stored procedure 119 By: simonrlee22 on Fri, 19 August 2016	8	2246	Fri, 19 August 2016 14:28 By: BlackSwan
Dynamic SQL Learning 11g By: Irish88 on Wed, 10 August 2016	7	2635	Thu, 18 August 2016 12:10 By: Irish88
ORA-01917 ERROR By: mfahimaamirgmailcom on Thu, 18 August 2016	2	2445	Thu, 18 August 2016 06:11 By: Michel Cadot
How to get a value that has never been updated Oracle Database:11.2.0.1.0; TOAD: 12.1, O/S: Windows 7 Professional 64 bit By: buggleboy007 on Wed, 17 August 2016	2	2172	Wed, 17 August 2016 21:33 By: buggleboy007
previous data oracle 11gr2 By: guddu_12 on Wed, 17 August 2016	7	2041	Wed, 17 August 2016 14:04 By: Michel Cadot
Renaming a table Oracle 11 By: saipradyumn on Tue, 16 August 2016	6	1830	Wed, 17 August 2016 07:28 By: Bill B
PL/SQL: ORA-00942: table or view does not exist Oracle 11g, 11.2.0.3.0 By: wtolentino on Tue, 16 August 2016	3	1923	Wed, 17 August 2016 06:45 By: wtolentino
Find unique and sorted field value By: amarbose on Tue, 16 August 2016	10	3455	Wed, 17 August 2016 06:28 By: Michel Cadot
keep only numeric values in a string oracle 11g, windows By: chinmay45 on Tue, 16 August 2016	18	4910	Wed, 17 August 2016 01:35 By: Michel Cadot
PLS-00231: By: desmond30 on Mon, 15 August 2016	7	4134	Tue, 16 August 2016 08:08 By: Michel Cadot
Update or create function paramater Oracle Database 10g Enterprise Edition ,10.2.0.4.0, linux64_86 By: abdo2203 on Sat, 13 August 2016	5	2067	Sat, 13 August 2016 09:36 By: abdo2203
Help reverse engineering pl sql query Oracle sql By: jprisk on Fri, 12 August 2016	4	2459	Fri, 12 August 2016 15:03 By: Barbara Boehmer
Repeat data based on count column Oracle 11g Release 2, Linux By: anil_mk on Thu, 11 August 2016	5	2216	Fri, 12 August 2016 07:23 By: anil_mk
Dynamic Update statement Error Oracle 9i By: cvs_1984 on Thu, 11 August 2016	2	1810	Thu, 11 August 2016 05:31 By: cvs_1984
Query help Oracle 12.1.0.2.0, Linux By: sspn2010 on Mon, 08 August 2016	6	2301	Tue, 09 August 2016 16:21 By: sspn2010
Check if value EXISTS in plsql table of record type 11G By: harshadsp on Wed, 03 August 2016	11	12012	Mon, 08 August 2016 05:57 By: harshadsp
SQL connectivity test oracle, 11g, AIX By: Prathikesh on Sat, 06 August 2016	24	5101	Mon, 08 August 2016 02:50 By: cookiemonster
UTL_DBWS error: ORA-29540: class oracle/jpub/runtime/dbws/DbwsProxy does not exist Oracle DB, 10g R2, Windows Server 2008R2 By: mdsirajoddin on Sat, 06 August 2016	12	9530	Sat, 06 August 2016 10:38 By: Michel Cadot
Sum from part of coloumn Oracle,11g Release 11.2.0.4.0, Solaris 11 By: nms123 on Fri, 05 August 2016	2	1429	Fri, 05 August 2016 09:47 By: nms123
Help using regexp_substr - Urgent Help needed Oracle 11 By: Member2014 on Thu, 04 August 2016	8	3583	Fri, 05 August 2016 08:41 By: Member2014
Regular expression search By: saipradyumn on Fri, 05 August 2016	2	1390	Fri, 05 August 2016 07:58 By: Solomon Yakobson
Count group data 12.1.0.2 By: bdtran on Sat, 02 July 2016	21	7520	Wed, 03 August 2016 23:44 By: bdtran
Make use of UNUSABLE_INDEX by uisnh HInt Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production By: saipradyumn on Wed, 27 July 2016	4	1839	Wed, 03 August 2016 13:37 By: Bill B
Replace Accented Characters By: ramya29p on Wed, 27 July 2016	21	14010	Wed, 03 August 2016 05:12 By: Michel Cadot