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
How to keep only one branch after connect by Oracle 11g - 11.2.0.3 By: ric90 on Mon, 26 October 2015	2	2349	Mon, 26 October 2015 07:58 By: ric90
Searching through entire table. By: jimjohn on Mon, 19 October 2015	10	5513	Mon, 26 October 2015 06:50 By: EdStevens
remote database migration Oracle 11.2.0.3 By: deb171100 on Mon, 26 October 2015	7	3097	Mon, 26 October 2015 06:46 By: EdStevens
To Split data based on dates By: rohit_shinez on Tue, 13 October 2015	20	15759	Sun, 25 October 2015 18:19 By: Barbara Boehmer
Compare values based on range By: rohit_shinez on Sat, 24 October 2015	27	7048	Sun, 25 October 2015 13:28 By: Michel Cadot
Is there a limitation of connect by for Partitioned tables Oracle 11g By: gentleman777us on Fri, 23 October 2015	1	1891	Fri, 23 October 2015 12:15 By: Michel Cadot
Need answer for below block By: rajesh_oracle on Fri, 23 October 2015	1	1860	Fri, 23 October 2015 02:13 By: Michel Cadot
Unique hash based on user database objects. Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: tmcallister on Wed, 21 October 2015	7	3224	Thu, 22 October 2015 19:23 By: BlackSwan
get the remote DB instance name Oracle 9i Release2 , HP UNIX By: live4learn on Wed, 21 October 2015	5	7994	Wed, 21 October 2015 13:24 By: Solomon Yakobson
interview question asked (merged 3) By: purnima1 on Wed, 21 October 2015	3	1965	Wed, 21 October 2015 10:47 By: Michel Cadot
How to filter records from UNION ALL query By: toitdoctor on Tue, 20 October 2015	4	3847	Wed, 21 October 2015 08:11 By: Michel Cadot
Parallel Procedure Run Oracle 11g, Windows 7 By: Vijay55 on Wed, 21 October 2015	2	3355	Wed, 21 October 2015 03:05 By: Michel Cadot
Select with Time Range Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 By: Duane on Mon, 19 October 2015	4	3883	Tue, 20 October 2015 09:42 By: Duane
Insert into table from another table based on joining column Oracle 10 By: pratik4891 on Tue, 20 October 2015	4	3755	Tue, 20 October 2015 07:49 By: Michel Cadot
Filling values Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 By: manubatham20 on Mon, 19 October 2015	2	2072	Mon, 19 October 2015 10:40 By: manubatham20
user schema can't create or alter job (merged 3) oracle 12GR2 By: agung_prw on Thu, 15 October 2015	20	10927	Mon, 19 October 2015 03:19 By: gazzag
Need few clarification on Alter table. Oracle 11G, WIN7 By: gopieee16 on Fri, 16 October 2015	6	3956	Mon, 19 October 2015 02:16 By: gopieee16
in, out parameters By: wisdomofmetis on Sat, 17 October 2015	2	2372	Sat, 17 October 2015 07:51 By: Solomon Yakobson
Create table with two tablespaces oracle 11g By: raopatwariyahoocom on Fri, 16 October 2015	8	3651	Fri, 16 October 2015 11:22 By: John Watson
To replace value where the date falls Oracle 11g By: rohit_shinez on Fri, 16 October 2015	3	2239	Fri, 16 October 2015 10:50 By: rohit_shinez
binary to hexadecimal conversion oracle 11gr2 By: guddu_12 on Fri, 16 October 2015	5	6594	Fri, 16 October 2015 10:27 By: John Watson
I need to process a string with arithmetic operators By: spgun on Thu, 15 October 2015	3	2117	Thu, 15 October 2015 11:44 By: Bill B
split data with levels 11.2.0.3 By: amy.wilson on Fri, 09 October 2015	18	6524	Thu, 15 October 2015 02:18 By: flyboy
fine tuning my sql query for a grouping report oracle 10g, oracle forms and reports developer suite By: lacchhii on Wed, 14 October 2015	1	1930	Thu, 15 October 2015 01:25 By: Michel Cadot
questions about creating function By: wisdomofmetis on Tue, 13 October 2015	3	2672	Wed, 14 October 2015 09:48 By: CraigB
Requirement to extract sql script output and attach the same in a email and send to multiple users 11g By: avinashkk on Tue, 06 October 2015	9	4119	Tue, 13 October 2015 09:36 By: Bill B
Regular Expression Oracle 11.2.0.3 By: pointers on Thu, 08 October 2015	4	3335	Tue, 13 October 2015 09:27 By: Bill B
How To See Latest created Table Including Time in oracle. Is there any table for it? Oarcle 11g By: graphe on Thu, 08 October 2015	7	3783	Tue, 13 October 2015 09:22 By: Bill B
HOW TO STORE ROWID DATA BY USING ROWID DATA TYPE? oracle 11g By: graphe on Tue, 13 October 2015	6	3101	Tue, 13 October 2015 08:53 By: Bill B
groups in regexp_instr Oracle 10g By: m.abdulhaq on Wed, 07 October 2015	6	2920	Tue, 13 October 2015 04:12 By: m.abdulhaq
How to get weeknum for the given date By: blyzz on Fri, 09 October 2015	4	3630	Mon, 12 October 2015 14:17 By: Michel Cadot
single row subquery returns more than one row 11g R2 By: manoj12 on Mon, 12 October 2015	4	2501	Mon, 12 October 2015 08:05 By: cookiemonster
what is the main usage of execute immediate. 11g By: sudheerips on Mon, 12 October 2015	3	2212	Mon, 12 October 2015 05:08 By: _jum
Rownum per day Oracle DB 11.2.0.4 By: DirkHamburg on Fri, 09 October 2015	2	1868	Fri, 09 October 2015 07:13 By: DirkHamburg
set target table flag as D if rows deleted at source oracle 11.2 By: deb171100 on Thu, 08 October 2015	2	2136	Fri, 09 October 2015 02:28 By: sandeep_orafaq
required date month year query oracle 10g express edition By: sudheerips on Fri, 02 October 2015	10	4295	Thu, 08 October 2015 08:02 By: Bill B
query correction required 11g By: amy.wilson on Wed, 07 October 2015	5	2610	Wed, 07 October 2015 23:21 By: Michel Cadot
CTE Queries 11g ( 1 2) By: amy.wilson on Wed, 30 September 2015	43	11055	Wed, 07 October 2015 08:11 By: flyboy
Checking the parameter inside Procedure (merged 2) By: hypesslearner on Wed, 07 October 2015	3	2247	Wed, 07 October 2015 06:25 By: Michel Cadot
oracle procedure oracle 10g ( 1 2) By: arun888 on Mon, 27 July 2015	61	21536	Tue, 06 October 2015 21:55 By: BlackSwan