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
Fetching data dynamically in Collections Forms 6i, Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: chat2raj.s on Tue, 27 November 2018	21	14359	Thu, 29 November 2018 04:56 By: chat2raj.s
Display Time 11g By: glmjoy on Wed, 28 November 2018	10	7222	Wed, 28 November 2018 09:19 By: cookiemonster
Check for status of a computer in the network Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: chat2raj.s on Wed, 14 November 2018	14	8368	Wed, 28 November 2018 07:58 By: joy_division
Materialised Views - FAST Refresh Oracle 11g By: chat2raj.s on Wed, 16 May 2018	9	8711	Tue, 27 November 2018 23:42 By: chat2raj.s
Writing Arabic Text using UTL_FILE Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production By: chat2raj.s on Mon, 24 September 2018	2	5621	Tue, 27 November 2018 23:32 By: chat2raj.s
DBMS_SCHEDULER Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: chat2raj.s on Tue, 16 October 2018	5	5783	Tue, 27 November 2018 23:21 By: chat2raj.s
How to get apps view DDL statement from non-apps schema Oracle R12 By: ajayhareesh on Mon, 26 November 2018	14	9243	Mon, 26 November 2018 08:39 By: Solomon Yakobson
How to run the procedure that have array output? By: Ican321 on Mon, 26 November 2018	4	5189	Mon, 26 November 2018 05:40 By: Michel Cadot
HAVING ISSUES UNDERSTANDING HOW TO SOLVE THIS ORACLE QUESTION ORACLE SQL By: pastorfloxy1@gmail.com on Sat, 24 November 2018	3	5208	Sun, 25 November 2018 01:21 By: Michel Cadot
General Question on altering table without locking it Oracle 11gR2 By: srinivas.k2005 on Fri, 23 November 2018	3	4859	Fri, 23 November 2018 11:28 By: srinivas.k2005
MV Refresh on Partitioned Materialized views Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: saipradyumn on Thu, 22 November 2018	11	8769	Fri, 23 November 2018 02:16 By: saipradyumn
SQL Query assistance 12.2 By: jkingqst on Tue, 20 November 2018	30	16305	Thu, 22 November 2018 03:44 By: jkingqst
How to display the letter starting with "B" followed by number only. Oracle 11g By: ajaykumarkona on Thu, 09 January 2014	14	9354	Tue, 20 November 2018 10:58 By: gazzag
Are following statements executed in any case if the first one throws an exception? By: katherineamt on Tue, 20 November 2018	1	4158	Tue, 20 November 2018 07:43 By: cookiemonster
calculate a function on whole table oracle 11g By: ramkumar10 on Sat, 10 November 2018	20	11190	Sat, 17 November 2018 12:10 By: ramkumar10
Calling Java function from pl/sql Oracle 11g By: dineshkumar18 on Wed, 14 November 2018	0	4561	Wed, 14 November 2018 04:32 By: dineshkumar18
resource busy and acquire with NOWAIT specified or timeout expired Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: saipradyumn on Tue, 13 November 2018	10	7815	Wed, 14 November 2018 01:09 By: Michel Cadot
Relationship between two weak entities By: rjan on Tue, 13 November 2018	1	4044	Tue, 13 November 2018 03:30 By: cookiemonster
How to execute 5 procedures, one after another? By: nagarajut80 on Mon, 12 November 2018	6	5252	Mon, 12 November 2018 05:26 By: Michel Cadot
Last and Sum in group by 11.1.2.10 By: OraFerro on Thu, 27 September 2018	3	6565	Sun, 11 November 2018 05:19 By: Barbara Boehmer
List of Months between 2 dates 12.2 By: lott42_gmail on Mon, 05 November 2018	7	6324	Wed, 07 November 2018 15:07 By: lott42_gmail
ORA-00904 on selecting by column name By: chat2raj.s on Tue, 06 November 2018	4	6102	Tue, 06 November 2018 04:35 By: chat2raj.s
PL/SQL error Ora-06502 Oracle 11g, Reports builder 6i By: kmack on Mon, 05 November 2018	3	4575	Mon, 05 November 2018 05:10 By: Michel Cadot
Ranking data by a set of data maybe using analytical function 12.2 By: lott42_gmail on Thu, 01 November 2018	7	5567	Fri, 02 November 2018 15:24 By: lott42_gmail
SQL query By: james94539 on Thu, 01 November 2018	3	6588	Fri, 02 November 2018 02:35 By: Michel Cadot
DBMS_LOB.SUBSTR 11g By: EDT on Thu, 01 November 2018	8	6216	Thu, 01 November 2018 15:31 By: Michel Cadot
How to print Boolean or True/False value in Sql Oracle 12c, Windows By: akssre on Wed, 07 March 2018	15	17267	Thu, 01 November 2018 08:29 By: joy_division
How to allow multi-users in Procedure Oracle 12c By: petar97 on Fri, 26 October 2018	21	13429	Thu, 01 November 2018 06:52 By: EdStevens
date column displays strange output Oracle 11g RAC, Linux OEL 6 By: Andrey_R on Mon, 29 October 2018	12	7179	Tue, 30 October 2018 04:16 By: Andrey_R
Who deleted the data 12c By: deepakdot on Tue, 23 October 2018	21	13083	Mon, 29 October 2018 02:10 By: deepakdot
How to make a trigger on the table for the history table Oracle 12c Release 2 By: petar97 on Sun, 28 October 2018	7	5895	Sun, 28 October 2018 14:57 By: Michel Cadot
How to tune Query on Large Oracle Table By: sacharya2017 on Thu, 25 October 2018	9	5844	Fri, 26 October 2018 12:51 By: sacharya2017
Generate Random Id's of existing Id's 12.2 By: lott42_gmail on Thu, 25 October 2018	14	7473	Fri, 26 October 2018 12:13 By: lott42_gmail
Replace strings [merged by jd] Oracle RDBMS, 12.1, Windows By: unna on Fri, 26 October 2018	9	6676	Fri, 26 October 2018 10:47 By: Michel Cadot
execute immediate (merged) By: mail_valeria on Fri, 26 October 2018	20	10557	Fri, 26 October 2018 08:53 By: cookiemonster
Cast to index by table By: purnima1 on Fri, 21 September 2018	4	5747	Thu, 25 October 2018 13:04 By: Barbara Boehmer
query performance EBS R12, db-10.1.1.2 By: annu-agi on Wed, 19 September 2018	9	7859	Wed, 24 October 2018 00:25 By: Michel Cadot
PLS-00201: identifier 'CTX_DDL' must be declared By: Sania Fatimi on Tue, 23 October 2018	4	9266	Tue, 23 October 2018 22:23 By: Barbara Boehmer
a procedure with dinamic sql By: jasminzeni on Wed, 17 October 2018	4	7069	Tue, 23 October 2018 07:33 By: Bill B
Written Assignment (+ example code) ( 1 2) By: cwilliam912 on Wed, 17 October 2018	51	25019	Mon, 22 October 2018 08:46 By: Barbara Boehmer