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
WITH clause working in 10g but not in 11g (XE) Oracle 10g and 11g By: Rishab_le_noob on Mon, 23 November 2015	3	2646	Mon, 23 November 2015 02:04 By: Michel Cadot
Sysdate to_char DAY conversion not comparable Oracle 10g and 11g By: Rishab_le_noob on Mon, 23 November 2015	3	3385	Mon, 23 November 2015 01:40 By: Michel Cadot
Convert Rows to Columns Oracle, 11g, Solaris By: uman2631 on Wed, 18 November 2015	7	3326	Mon, 23 November 2015 01:33 By: Rishab_le_noob
Need Explanation on this query Oracle SQL By: hharishh86 on Fri, 20 November 2015	2	2685	Mon, 23 November 2015 01:02 By: hharishh86
SYS_GUID FUNCTION RETURNING SAME VALUE Oracle 11g Enterprise Edition Release 11.2.0.3.0 By: jarockiadoss on Thu, 19 November 2015	18	7944	Fri, 20 November 2015 12:34 By: jarockiadoss
Difference the rows Oracle 11g windows By: knari007 on Thu, 19 November 2015	6	3251	Fri, 20 November 2015 09:08 By: Solomon Yakobson
Basic sorting concept 10g By: nciteamo on Thu, 19 November 2015	9	4294	Thu, 19 November 2015 11:20 By: EdStevens
extract string using regex 10g By: m.abdulhaq on Thu, 19 November 2015	4	2431	Thu, 19 November 2015 06:09 By: Solomon Yakobson
How to display multiple records in a single row Oracle 11g By: subash141 on Wed, 18 November 2015	7	4170	Wed, 18 November 2015 14:04 By: Michel Cadot
How to analyze complex sql queries 11G By: gorants on Tue, 17 November 2015	4	2940	Wed, 18 November 2015 12:42 By: gorants
Results Set based on Dynamic Date stored in variable Oracle SQL Developer By: Anil98765 on Mon, 16 November 2015	6	4012	Tue, 17 November 2015 13:32 By: BlackSwan
Stored Proc not inserting all records By: kr1347 on Sun, 15 November 2015	10	4037	Mon, 16 November 2015 15:08 By: flyboy
arraysize and PL/SQL Oracle 11g Solaris By: uman2631 on Fri, 13 November 2015	3	4325	Sun, 15 November 2015 12:57 By: Lalit Kumar B
ORA-12015: cannot create a fast refresh materialized view from a complex query Oracle 11g (11.2.0.3) By: tony_soprano786 on Wed, 11 November 2015	2	2547	Fri, 13 November 2015 15:35 By: Bill B
Determine Incomplete Orders Oracle 11g By: stun66 on Wed, 11 November 2015	4	2842	Thu, 12 November 2015 03:49 By: mnitu
PLSQL Collection index by varchar By: wantsunny007 on Mon, 09 November 2015	21	6270	Mon, 09 November 2015 15:06 By: wantsunny007
Need Help in SQL Query Oracle 11g By: arifs3738 on Wed, 04 November 2015	22	7079	Mon, 09 November 2015 10:40 By: Michel Cadot
sql query help Oracle 11g By: arifs3738 on Sun, 08 November 2015	6	2896	Mon, 09 November 2015 07:28 By: Michel Cadot
Oracle Regular Expression - Remove space between alphabetic tokens of length 1 within a string Oracle 11.2 By: orauser001 on Thu, 05 November 2015	10	4409	Sat, 07 November 2015 23:00 By: orauser001
find updated table name oracle 11gr2 By: guddu_12 on Thu, 05 November 2015	12	3893	Thu, 05 November 2015 09:38 By: BlackSwan
i want to use temporary data source for next time and it is going in that way 11g By: graphe on Wed, 04 November 2015	2	1769	Thu, 05 November 2015 06:17 By: graphe
Out of SQL Query Oracle 11g By: arifs3738 on Wed, 04 November 2015	3	2726	Wed, 04 November 2015 06:33 By: arifs3738
Materialized View Refresh Issue Oracle 11g 64 bit By: fatimacognos on Mon, 02 November 2015	3	6768	Wed, 04 November 2015 04:46 By: JNagtzaam
Update blob Column Oracle 11g By: P1Oracle on Tue, 03 November 2015	13	11121	Wed, 04 November 2015 04:40 By: Michel Cadot
Nested table as a out parameter in procedure 11g db, windows 7 By: aspire on Tue, 03 November 2015	3	4842	Tue, 03 November 2015 12:30 By: aspire
Complex query (merged) 10g By: m.abdulhaq on Sun, 01 November 2015	8	4227	Tue, 03 November 2015 11:39 By: m.abdulhaq
stored procedure to Inserting new rows and updating existing rows 11.2.0.3 By: amy.wilson on Mon, 02 November 2015	7	3409	Tue, 03 November 2015 07:39 By: sandeep_orafaq
Test query for SORT (merged) 12c By: gkrishn on Mon, 02 November 2015	5	2802	Mon, 02 November 2015 13:29 By: Michel Cadot
i want to upload a file in database using plsql 10g By: sudheerips on Mon, 02 November 2015	6	2813	Mon, 02 November 2015 09:17 By: John Watson
a column may not be outer-joined to a subquery By: javon13 on Fri, 30 October 2015	10	9024	Mon, 02 November 2015 07:03 By: javon13
case statement pl/sql By: amazeme on Fri, 30 October 2015	2	1974	Fri, 30 October 2015 12:25 By: amazeme
query By: chatwidravi on Tue, 27 October 2015	7	2988	Fri, 30 October 2015 11:23 By: Michel Cadot
Stored Procedure in migrating data oracle 11.2.0.3 By: amy.wilson on Tue, 27 October 2015	10	4639	Fri, 30 October 2015 03:39 By: javon13
Sending SMS through Oracle Database By: sarfraz_attari on Sat, 16 September 2006	25	30810	Thu, 29 October 2015 23:56 By: jagadekar
ERROR CODE IS 1 User-Defined Exception Instead of ORA-00001: unique constraint (SCOTT.PK_EMP_UP) vi Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production By: rajesh_oracle on Wed, 28 October 2015	3	3098	Thu, 29 October 2015 01:00 By: Michel Cadot
Insert, delete and update At a time Oracle 11g, windows By: Vijay55 on Wed, 28 October 2015	4	2490	Wed, 28 October 2015 09:10 By: BlackSwan
Oracle Stored procedure takes long time to initiate / execute - (from package) Oracle 11.2.0.3, Linux x86 64 By: hitesh.bhatt on Wed, 28 October 2015	3	1988	Wed, 28 October 2015 07:51 By: BlackSwan
Coping one cursor results into another cursor oracle 11g By: aravind.peddola@gmail.com on Wed, 28 October 2015	1	1539	Wed, 28 October 2015 01:35 By: Michel Cadot
Inclusion of duplicate records By: rohit_shinez on Tue, 27 October 2015	2	2011	Tue, 27 October 2015 13:43 By: rohit_shinez
explicit and implicit functions in oracle By: letolagal on Tue, 27 October 2015	3	3595	Tue, 27 October 2015 09:59 By: John Watson