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
Announcement: How to use [code] tags and make your code easier to read By: Michel Cadot on Thu, 01 November 2018	1	32529	Tue, 30 June 2020 11:23 By: Michel Cadot
sticky: Row generator ( 1 2) By: Michel Cadot on Thu, 03 January 2008	47	320475	Sun, 29 January 2023 19:35 By: mathguy
sql query 19c By: ora9a on Wed, 29 March 2023	8	3745	Fri, 31 March 2023 10:11 By: mathguy
Sequence alternate 19C By: deepakdot on Tue, 28 March 2023	9	6812	Wed, 29 March 2023 07:49 By: Michel Cadot
sql oracle 10g By: arun888 on Fri, 24 March 2023	2	12438	Fri, 24 March 2023 09:29 By: arun888
Min and Max values of contiguous rows (3 merged) oracle 10g By: arun888 on Wed, 29 June 2022	11	20202	Fri, 24 March 2023 01:46 By: arun888
xml converting task 11g By: urmas19 on Wed, 22 March 2023	7	14105	Thu, 23 March 2023 14:11 By: mathguy
convert xml column value into columns Oracle 19c By: avtaritet on Mon, 20 March 2023	3	8201	Tue, 21 March 2023 09:20 By: avtaritet
Refreshing Materialized View oracle 10g By: chat2raj.s on Sun, 13 November 2022	11	19493	Tue, 21 March 2023 07:58 By: chat2raj.s
Rescheduling installments by distributing amounts 12.1.0.1.0 By: OraFerro on Mon, 13 March 2023	8	18780	Thu, 16 March 2023 01:33 By: OraFerro
Suggestion on count via sql statement Oracle 12c By: akssre on Fri, 10 March 2023	14	11517	Mon, 13 March 2023 23:07 By: akssre
Ternary Operator in PL/SQL Oracle 10g on UNIX By: soham.desai@gmail.com on Tue, 26 August 2008	3	46617	Mon, 13 March 2023 19:29 By: mathguy
XML parsing performance 19c By: mape on Sun, 12 March 2023	0	14314	Sun, 12 March 2023 01:30 By: mape
Different UTC time from SYSDATE on different databases Oracle 21c/19c By: Andrey_R on Wed, 08 March 2023	15	7461	Thu, 09 March 2023 10:02 By: Andrey_R
Identify Groups where 2 or more Clients have bought the same Products - SQL Oracle SQL - ORACLE By: Nicha on Fri, 03 March 2023	33	11863	Tue, 07 March 2023 15:17 By: Michel Cadot
Grouping with the previous one if identical By: questvba on Tue, 21 February 2023	12	23011	Mon, 06 March 2023 09:53 By: mathguy
how to incrementally get all numbers incremented by n between 2 columns values oracle 19c By: avtaritet on Mon, 27 February 2023	27	18750	Mon, 06 March 2023 08:38 By: Michel Cadot
Need Help with Table Type Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 By: vinodkumarn on Sun, 05 March 2023	2	3381	Mon, 06 March 2023 01:05 By: Michel Cadot
Optional parameter in Where clause 11g, Windows By: RM33 on Fri, 24 February 2023	3	16503	Sat, 25 February 2023 11:19 By: Michel Cadot
Cast(Multiset()) Oracle, 12.2.0.1.0, Linux By: Duane on Wed, 15 February 2023	17	21723	Fri, 17 February 2023 20:00 By: Duane
Difference between two dates By: Joy83 on Thu, 09 February 2023	4	9081	Thu, 09 February 2023 08:30 By: Joy83
Convert Date formats By: deahayes on Wed, 08 February 2023	4	3926	Wed, 08 February 2023 20:47 By: Barbara Boehmer
XML parse 19c By: mape on Fri, 03 February 2023	20	17806	Wed, 08 February 2023 13:04 By: Barbara Boehmer
Loop and save the index in an incremental number array By: Joy83 on Mon, 06 February 2023	8	4976	Mon, 06 February 2023 21:15 By: Joy83
Dad, Grand Pa and Great Grand Pa ! 11.2.0.3 By: Amine on Fri, 09 December 2022	6	39476	Mon, 06 February 2023 04:34 By: Amine
Help need in writing query to get JSON format output Oracle 19c By: pr76666 on Mon, 30 January 2023	9	20531	Fri, 03 February 2023 09:00 By: Michel Cadot
Duplicate rows by generating date based on column value 12.1.0.1.0 By: OraFerro on Mon, 30 January 2023	18	18726	Tue, 31 January 2023 23:02 By: OraFerro
xml auto generate atribute 19c By: mape on Wed, 18 January 2023	5	18600	Tue, 31 January 2023 00:27 By: mathguy
Get customer with GREATEST amount of purchases By: Unclefool on Sun, 29 January 2023	12	10808	Mon, 30 January 2023 09:55 By: mathguy
REST API with DDOS protection ORACLE 12c By: mmation on Fri, 17 November 2017	3	11500	Mon, 30 January 2023 07:26 By: rxelgin
Two Column Join Oracle PL SQL By: ibrahimzuberi on Fri, 27 January 2023	9	11929	Mon, 30 January 2023 00:30 By: ibrahimzuberi
greatest total amount of purchases per day for each customer_id By: Unclefool on Sat, 14 January 2023	3	14675	Tue, 17 January 2023 02:11 By: Michel Cadot
SQL very slow EBS R12.2.8 By: ccpCCP88 on Tue, 10 January 2023	16	19062	Mon, 16 January 2023 10:59 By: Duane
Base64 to Blob Oracle, 12.2.0.1.0, Linux By: Duane on Thu, 12 January 2023	2	14308	Thu, 12 January 2023 15:20 By: Duane
Row Level trigger By: indupriyav_2023 on Wed, 11 January 2023	1	12049	Wed, 11 January 2023 04:09 By: Michel Cadot
COALESCE and CASE By: questvba on Tue, 03 January 2023	5	15265	Wed, 04 January 2023 07:57 By: Michel Cadot
xml error eurofxref-daily.xml 19c By: mape on Sun, 01 January 2023	7	15989	Sun, 01 January 2023 07:57 By: Solomon Yakobson
Parent/Child Table Design Help Oracle, 12.2.0.1.0, Linux By: Duane on Tue, 20 December 2022	1	22602	Wed, 21 December 2022 01:17 By: John Watson
Months Calculation and update Statement Oracle 11G, Windows By: hissam78 on Sat, 10 December 2022	5	40763	Sun, 11 December 2022 13:02 By: Michel Cadot
String Extract using REGEXP_SUBSTR Oracle, 12.2.0.1.0, Linux By: Duane on Fri, 09 December 2022	6	36462	Sat, 10 December 2022 15:05 By: Solomon Yakobson