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 :: Show Polls :: Message Navigator

	Topic	Replies	Views	Last message
	Announcement: How to use [code] tags and make your code easier to read By: Michel Cadot on Thu, 01 November 2018	0	671	Thu, 01 November 2018 14:05 By: Michel Cadot
	sticky: Row generator ( 1 2) By: Michel Cadot on Thu, 03 January 2008	43	186228	Tue, 06 November 2018 14:17 By: Solomon Yakobson
	SQL Help 12.2.0.1 By: kapilavastu on Thu, 15 November 2018	3	317	Fri, 16 November 2018 03:33 By: cookiemonster
	How to use Optimistic locking in my Package Oracle 12c Release 2 ( 1 2) By: petar97 on Thu, 08 November 2018	66	2565	Thu, 15 November 2018 06:37 By: cookiemonster
	calculate a function on whole table oracle 11g By: ramkumar10 on Sat, 10 November 2018	12	1492	Wed, 14 November 2018 11:54 By: Bill B
	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	10	234	Wed, 14 November 2018 08:28 By: Michel Cadot
	Calling Java function from pl/sql Oracle 11g By: dineshkumar18 on Wed, 14 November 2018	0	197	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	452	Wed, 14 November 2018 01:09 By: Michel Cadot
OPatch failed with error code = 255 has been moved to Server Administration by the moderator.
	Relationship between two weak entities By: rjan on Tue, 13 November 2018	1	192	Tue, 13 November 2018 03:30 By: cookiemonster
	How to execute 5 procedures, one after another? By: nagarajut80 on Mon, 12 November 2018	6	198	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	1543	Sun, 11 November 2018 05:19 By: Barbara Boehmer
	XML Through PL/SQL Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: vharish006 on Thu, 01 November 2018	19	1702	Fri, 09 November 2018 10:44 By: Michel Cadot
	List of Months between 2 dates 12.2 By: lott42_gmail on Mon, 05 November 2018	7	745	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	728	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	378	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	684	Fri, 02 November 2018 15:24 By: lott42_gmail
	SQL query By: james94539 on Thu, 01 November 2018	3	512	Fri, 02 November 2018 02:35 By: Michel Cadot
	DBMS_LOB.SUBSTR 11g By: EDT on Thu, 01 November 2018	8	413	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	2377	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	1482	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	930	Tue, 30 October 2018 04:16 By: Andrey_R
	Who deleted the data 12c By: deepakdot on Tue, 23 October 2018	21	2705	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	502	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	855	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	822	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	530	Fri, 26 October 2018 10:47 By: Michel Cadot
	execute immediate (merged) By: mail_valeria on Fri, 26 October 2018	20	778	Fri, 26 October 2018 08:53 By: cookiemonster
	Cast to index by table By: purnima1 on Fri, 21 September 2018	4	1218	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	1580	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	1427	Tue, 23 October 2018 22:23 By: Barbara Boehmer
	a procedure with dinamic sql By: jasminzeni on Wed, 17 October 2018	4	2153	Tue, 23 October 2018 07:33 By: Bill B
	Written Assignment (+ example code) ( 1 2) By: cwilliam912 on Wed, 17 October 2018	51	3848	Mon, 22 October 2018 08:46 By: Barbara Boehmer
	STORE SQL PROCEDURES PL/sql By: glprobot on Fri, 19 October 2018	8	1124	Fri, 19 October 2018 08:46 By: cookiemonster
	Run dbms_scheduler.create_job with arguments Oracle 11.2.0.1.0 By: dansrnt on Fri, 13 May 2016	26	2600	Thu, 18 October 2018 13:43 By: Bill B
	Written Assignment-Printing a Record Using an If Statement By: cwilliam912 on Sun, 14 October 2018	25	2477	Thu, 18 October 2018 04:02 By: cookiemonster
	SQL Query to be grouped based on Column values By: sober_sandy on Wed, 17 October 2018	1	719	Wed, 17 October 2018 04:39 By: Michel Cadot
	Count of Pending, Failed, Running, Completed records Oracle 12c By: user_5678 on Mon, 15 October 2018	8	1561	Wed, 17 October 2018 00:39 By: user_5678
	Pulling hair out trying to use table function Oracle 11 By: jbarker36 on Fri, 12 October 2018	16	1672	Tue, 16 October 2018 13:44 By: JPBoileau
	DR Failure By: msyogi on Tue, 16 October 2018	6	984	Tue, 16 October 2018 08:58 By: joy_division