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
Hierarchical queries with aggregation 11.2.0.3 By: grpatwari on Tue, 21 April 2015	3	3169	Tue, 21 April 2015 08:02 By: grpatwari
Convert date to weeks in the month and days Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.8.0 - Production Oracle ORACLE PL/SQL V10.1.0.4.2 - Pr By: anumoses58 on Mon, 20 April 2015	36	9588	Mon, 20 April 2015 14:16 By: EdStevens
External Tables Linux 5.5, Oracle 10g, Windows xp By: ORA2015 on Wed, 25 March 2015	25	8427	Mon, 20 April 2015 13:07 By: ORA2015
Date functions By: P1Oracle on Mon, 20 April 2015	10	3931	Mon, 20 April 2015 12:40 By: P1Oracle
DBMS_CRYPTO 11g database By: vippysharma on Mon, 20 April 2015	5	3263	Mon, 20 April 2015 06:32 By: vippysharma
Same Query taking significantly different time on different days Oracle 11g By: saurabh.sha on Wed, 15 April 2015	3	2413	Sun, 19 April 2015 13:09 By: Kevin Meade
how to decide when to go for local vs global partitioned index on a table Oracle 11g By: rishuk on Tue, 14 April 2015	7	4008	Sun, 19 April 2015 13:01 By: Kevin Meade
multilagual charactor 10g,11g By: dsatya10 on Sun, 19 April 2015	14	7673	Sun, 19 April 2015 12:56 By: Michel Cadot
SQL query help oracle 11g By: gorants on Sat, 18 April 2015	2	2389	Sat, 18 April 2015 12:20 By: Barbara Boehmer
MAT view - Start with & Next Oracle 12g By: Oracle_Walker on Wed, 15 April 2015	9	5168	Fri, 17 April 2015 01:12 By: Michel Cadot
get data from two tables By: ketangarg86 on Thu, 16 April 2015	2	2684	Thu, 16 April 2015 14:54 By: Michel Cadot
Need to know about some basic for explain plan Oracle, Oracle Database 11g Express Edition Release 11.2.0.2.0 ,Win 7 Pro By: shumail on Wed, 15 April 2015	6	4610	Thu, 16 April 2015 07:01 By: mnitu
Procedure altered with compilation errors 11.2.0.4 By: krish96 on Tue, 14 April 2015	6	10120	Wed, 15 April 2015 13:30 By: Bill B
SQL/PLSQL HOW TO USE MIN FUNCTION USED IN WHERE CONDITION By: ifti6650 on Sun, 12 April 2015	6	4029	Wed, 15 April 2015 05:21 By: Lalit Kumar B
Connect by Level Clarification Required Oracle 11gr2 By: ind9 on Tue, 14 April 2015	2	2155	Tue, 14 April 2015 08:31 By: Solomon Yakobson
how to find out AM PM from date column oracle 10g By: jgjeetu on Tue, 14 April 2015	9	4564	Tue, 14 April 2015 06:43 By: EdStevens
Update Time Zone Oracle Database 12c, 12.1.0.2, Oracle Linux 6.5 64-bit By: askuncoro on Thu, 09 April 2015	3	4020	Mon, 13 April 2015 08:25 By: Bill B
Query Help Oracle 11g By: sadasivam.samyappan on Sun, 12 April 2015	1	2029	Sun, 12 April 2015 07:28 By: Michel Cadot
plsql function/package By: lexonsteel on Sat, 11 April 2015	2	2674	Sat, 11 April 2015 08:10 By: John Watson
MultiByte Chars in a Column 11.2.0.4.0 By: Yuvraaj on Thu, 09 April 2015	5	4456	Sat, 11 April 2015 00:31 By: Michel Cadot
Conditional Insert statement in pl/sql By: suji6281 on Thu, 09 April 2015	12	5326	Fri, 10 April 2015 08:22 By: cookiemonster
SQL Oracle 11g By: jen804 on Thu, 09 April 2015	2	2407	Fri, 10 April 2015 02:50 By: cookiemonster
help in writing query oracle 11 g By: simplesanju on Thu, 09 April 2015	2	2839	Thu, 09 April 2015 07:43 By: Michel Cadot
Materialized is getting invalid after refresh Oracle Database 11g Release 11.2.0.3.0 By: saipavan.plsql on Wed, 08 April 2015	4	3431	Thu, 09 April 2015 04:24 By: saipavan.plsql
saving query Output in a single variable By: palpali on Thu, 09 April 2015	9	4040	Thu, 09 April 2015 04:18 By: palpali
Oracle Number length to SQL Numeric length By: giszzmo on Tue, 07 April 2015	3	2579	Wed, 08 April 2015 18:58 By: WayCal
need help for oracle sql ORACLE By: hivwood on Tue, 07 April 2015	12	5931	Wed, 08 April 2015 04:54 By: Michel Cadot
%rowtype error 06512 By: Nasir.azeem on Wed, 08 April 2015	5	3770	Wed, 08 April 2015 02:27 By: Nasir.azeem
how to retreive the second word using substring By: Info_dev on Tue, 07 April 2015	3	2965	Wed, 08 April 2015 01:36 By: Lalit Kumar B
Unable to drop an Index By: msinha8 on Tue, 07 April 2015	5	3357	Tue, 07 April 2015 03:00 By: msinha8
Package Initialization block for performance tuning Oracle 11g By: dhulia_padhi@yahoo.com on Sun, 05 April 2015	3	3005	Mon, 06 April 2015 09:11 By: BlackSwan
how to user regexp to put single quotes oracle 11g By: gentleman777us on Fri, 03 April 2015	3	2716	Sat, 04 April 2015 01:17 By: Lalit Kumar B
Need help in tablespace Oracle 10g XE, Windows 7 By: dark_prince on Mon, 30 March 2015	29	10570	Fri, 03 April 2015 21:37 By: BlackSwan
explicit and implicit cursor loop By: sampathkore4444@gmail.com on Fri, 03 April 2015	2	2327	Fri, 03 April 2015 10:39 By: Michel Cadot
Child tables, grand child tables of a table Oracle 11.2.0.3 By: pointers on Wed, 01 April 2015	2	2433	Thu, 02 April 2015 02:28 By: pointers
Best way to get count of unique months with activity Oracle 11.2 By: statey603 on Wed, 01 April 2015	3	3255	Wed, 01 April 2015 15:23 By: joy_division
how to get unmatched record from emp and dept tables oracle 10g By: ursfriend77 on Sun, 29 March 2015	13	7254	Wed, 01 April 2015 01:19 By: Michel Cadot
different results of sql query on different servers (with the same data) see below By: ecivgamer on Tue, 31 March 2015	3	3087	Tue, 31 March 2015 14:42 By: EdStevens
JSON parsing? 12c By: JDOaktown on Mon, 30 March 2015	12	5017	Tue, 31 March 2015 12:44 By: JDOaktown
Select query is hitting the database multiple times By: kiran_vangeti on Tue, 31 March 2015	6	3557	Tue, 31 March 2015 05:43 By: Michel Cadot