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
Index is not used when additing one more selection criteria 11g By: karthik4u on Sat, 07 May 2016	2	1476	Sat, 07 May 2016 11:48 By: BlackSwan
Preserving Blanks in External Table Oracle 12, Windows NT By: pstanand on Fri, 06 May 2016	2	2200	Sat, 07 May 2016 08:12 By: EdStevens
Sort PL/SQL Table Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit, Win 7 By: vikram_2050 on Thu, 05 May 2016	6	2391	Fri, 06 May 2016 12:26 By: Barbara Boehmer
Date Updation Oracle 12C Windows NT By: pstanand on Thu, 05 May 2016	15	3615	Fri, 06 May 2016 09:28 By: pstanand
How can I read a variable runtime in a stored proc? By: gouravhere on Wed, 04 May 2016	7	3841	Thu, 05 May 2016 12:54 By: Michel Cadot
ORA-30928: Connect by filtering phase runs out of temp tablespace 30928. 00000 - "Connect by filter Oracle 11G R2 By: Kanagaraj2007 on Tue, 03 May 2016	5	4998	Wed, 04 May 2016 04:46 By: Michel Cadot
How to suppress messages from FTP server? 11.2 By: YIMORAF on Sun, 01 May 2016	4	2111	Tue, 03 May 2016 10:18 By: ThomasG
Alphanumeric Sequence Generator By: msyogi on Tue, 03 May 2016	7	2956	Tue, 03 May 2016 05:28 By: msyogi
SQL Query to fetch not matching records 12 C Windows NT By: pstanand on Mon, 02 May 2016	5	1663	Tue, 03 May 2016 02:10 By: Michel Cadot
HELP TO FORM DYNAMIC INSERT QUERY IN PL/SQL By: ibnelyas on Fri, 29 April 2016	4	1643	Tue, 03 May 2016 01:53 By: muhammadadnan198@gmail.co
Unable to get values from associative arrays into a different procedure Database:11.2.0.1.0; O/S: Linux 3.0.101-0.47.71-default x86_64 By: buggleboy007 on Mon, 25 April 2016	11	3212	Mon, 02 May 2016 20:08 By: buggleboy007
how to match multiple wildcards via metadata table By: joy_division on Fri, 29 April 2016	5	2540	Mon, 02 May 2016 16:15 By: Barbara Boehmer
call a web service in a function in plsql oracle 10g By: shahrezaei on Sat, 30 April 2016	1	2312	Sat, 30 April 2016 07:24 By: BlackSwan
error creating external via dbms_utility.exec_ddl_statement@myDB Oracle 11.2.9.1.0 By: gunderj on Mon, 25 April 2016	12	4690	Sat, 30 April 2016 06:58 By: gunderj
Trigger to prevent delete based on SQL statement 11.0.2.10 By: OraFerro on Thu, 28 April 2016	22	5605	Fri, 29 April 2016 13:30 By: Barbara Boehmer
Update Query Oracle 12C Windows NT By: pstanand on Thu, 28 April 2016	8	2069	Thu, 28 April 2016 12:29 By: Bill B
Oracle Lock Oracle 10g By: prashant_ora on Thu, 28 April 2016	6	1538	Thu, 28 April 2016 12:28 By: Bill B
Dynamic selection of data in query oracle 11g By: rocky_007 on Thu, 28 April 2016	7	1712	Thu, 28 April 2016 10:24 By: Bill B
Index on composite foreign key Oracle 11 By: RaShi.Raj on Thu, 28 April 2016	11	3453	Thu, 28 April 2016 10:06 By: Bill B
Hierarchical Query (merged) Oracle 10g By: lokimisc on Wed, 27 April 2016	7	4956	Thu, 28 April 2016 07:51 By: Michel Cadot
Stale Materialised view Oracle 10.2.0.4.0 By: brown_zzz on Thu, 28 April 2016	3	5285	Thu, 28 April 2016 06:24 By: brown_zzz
Partitioning Tables Oracle 11g, Unix By: ninan on Sat, 23 April 2016	11	2372	Wed, 27 April 2016 13:56 By: jyeager
Joining four tables..need help By: dbJuniorAdmin on Sun, 24 April 2016	12	3184	Tue, 26 April 2016 12:11 By: Bill B
narration in one line By: shahzad-ul-hasan on Fri, 01 April 2016	12	4338	Tue, 26 April 2016 01:50 By: per0per0
get row counts daily Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production By: TorontoTrader on Mon, 25 April 2016	4	1463	Mon, 25 April 2016 11:43 By: TorontoTrader
Please help for regexp_replace in oracle 11g Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit By: msol25 on Mon, 25 April 2016	3	1420	Mon, 25 April 2016 07:37 By: msol25
Nested cursor expressions DB 12.1.0.2 By: John Watson on Fri, 22 April 2016	25	3927	Sun, 24 April 2016 10:39 By: John Watson
with clause logic By: sivaparam on Mon, 04 April 2016	33	6042	Sun, 24 April 2016 06:55 By: Bill B
need to get row count for database with 20 k tables oracle 11 g By: TorontoTrader on Thu, 21 April 2016	12	3972	Fri, 22 April 2016 15:14 By: Solomon Yakobson
Dynamic SQL - with CONCAT function Oracle 11g By: ORAGENASHOK on Thu, 21 April 2016	9	2238	Fri, 22 April 2016 06:18 By: Solomon Yakobson
Dbms_schedule Oracle Database, 10g, Windows 7 By: azamkhan on Fri, 22 April 2016	2	2014	Fri, 22 April 2016 03:08 By: cookiemonster
Nested table with object type ORACLE 11g By: ORAGENASHOK on Sat, 09 April 2016	14	9814	Thu, 21 April 2016 13:23 By: Barbara Boehmer
Error when create policy after create view. What is the problem? PLSQL By: quytrieu on Tue, 05 April 2016	3	1496	Thu, 21 April 2016 07:31 By: Solomon Yakobson
Counting overlapping ID's in intersection tables. Oracle, 12.1.0.1, AIX 7.1 By: posefant on Wed, 20 April 2016	25	3733	Thu, 21 April 2016 06:00 By: posefant
Date Functions Oracle 10g By: Danny Freeman on Tue, 05 April 2016	4	1765	Wed, 20 April 2016 15:58 By: Bill B
Group By clause in inline view Oracle Database 10g, Toad 9.7, Windows 7 By: lancer26 on Mon, 18 April 2016	6	1890	Wed, 20 April 2016 13:44 By: live4learn
Ids of unique error type Oracle 11.2.0.3 By: pointers on Tue, 19 April 2016	7	1781	Wed, 20 April 2016 07:11 By: pointers
need to modify the column datatype from varchar to number By: saipavan.plsql on Wed, 06 April 2016	3	1559	Tue, 19 April 2016 13:23 By: Bill B
TO_DATE formating Oracle 11.2.0.3 By: pointers on Tue, 19 April 2016	5	1759	Tue, 19 April 2016 08:34 By: cookiemonster
query to right outer join and sum up Oracle 11.2.0.3 By: pointers on Tue, 19 April 2016	5	1387	Tue, 19 April 2016 07:00 By: pointers