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
DBMS LDAP package Oracle DB 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production, Sun Solaris By: vinayrajn on Mon, 26 June 2023	2	14587	Mon, 26 June 2023 16:13 By: vinayrajn
How create such attached table by travelling view and its dependent objects Oracle 18c By: mm_kanish05 on Thu, 22 June 2023	6	14750	Sat, 24 June 2023 13:19 By: Barbara Boehmer
Oracle function to get account balance 19c By: Unclefool on Fri, 23 June 2023	2	12346	Fri, 23 June 2023 11:30 By: Michel Cadot
Letter and TIMESTAMP CONCAT (INSERT error) 19c By: Unclefool on Sat, 17 June 2023	4	8231	Sat, 17 June 2023 10:31 By: Unclefool
Query to split date count into multiple rows and level that over weeks . By: itzkashi on Wed, 14 June 2023	2	14036	Thu, 15 June 2023 09:45 By: itzkashi
What is the difference between MINUS and LEFT outer join Oracle 10g, Windows By: nathb on Fri, 27 July 2012	10	19955	Wed, 24 May 2023 08:06 By: Solomon Yakobson
check all the distinct value match oracle 10g windows By: guddu_12 on Wed, 17 May 2023	9	11493	Thu, 18 May 2023 08:06 By: Michel Cadot
Wrap Triggers Oracle 19c By: sinpeak on Tue, 16 May 2023	2	9192	Tue, 16 May 2023 16:51 By: mbobak
How to get count of records that do not have more than 1 specific value in 1 column PL-SQL By: Linhardt on Mon, 01 May 2023	8	8673	Mon, 15 May 2023 07:02 By: ashnamalik
reading all values of json table Oracle 19c By: sss111ind on Wed, 10 May 2023	2	13135	Wed, 10 May 2023 09:52 By: Barbara Boehmer
elapsed time for a id Oracle 12.1 By: pointers on Wed, 03 May 2023	5	19990	Tue, 09 May 2023 02:58 By: pointers
Join purchases to customers 19c By: Unclefool on Mon, 01 May 2023	4	5688	Mon, 01 May 2023 13:41 By: Barbara Boehmer
Group By (merged) 19C By: deepakdot on Thu, 27 April 2023	4	11286	Thu, 27 April 2023 23:54 By: deepakdot
How can I speed this query up? By: DevMuch on Thu, 27 April 2023	2	8488	Thu, 27 April 2023 15:11 By: DevMuch
LOB Locator Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.18.0.0.0, CentOS release 6.7 By: fixxxer on Wed, 19 April 2023	5	18180	Tue, 25 April 2023 03:11 By: fixxxer
Custom password verify function Oracle DB 12c,19c, Exadata RHEL 7.9 By: Nagesh1985 on Thu, 20 April 2023	7	10859	Sat, 22 April 2023 06:18 By: Solomon Yakobson
SQL Query help Oracle 12c, Linux By: rajivn786 on Sun, 16 April 2023	2	16695	Mon, 17 April 2023 15:56 By: Solomon Yakobson
Format Dollar and Date Fields By: _rachel_ on Wed, 12 April 2023	4	9795	Thu, 13 April 2023 04:42 By: Littlefoot
sql query 19c By: ora9a on Wed, 29 March 2023	10	16962	Wed, 12 April 2023 13:18 By: mathguy
Subtrair valores Oracle SQL Developer By: FlaSouza on Mon, 10 April 2023	2	7573	Mon, 10 April 2023 11:23 By: Barbara Boehmer
Oracle Style with Table Alias Oracle, 12.2.0.1.0, Linux By: Duane on Fri, 07 April 2023	5	11612	Sat, 08 April 2023 23:19 By: Barbara Boehmer
Design issue 11.2.0.3.0 By: Amine on Fri, 07 April 2023	3	11479	Sat, 08 April 2023 17:50 By: mathguy
difficult task 10g By: urmas19 on Wed, 05 April 2023	7	5447	Wed, 05 April 2023 16:52 By: Barbara Boehmer
Sequence alternate 19C By: deepakdot on Tue, 28 March 2023	9	14198	Wed, 29 March 2023 07:49 By: Michel Cadot
sql oracle 10g By: arun888 on Fri, 24 March 2023	2	15567	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	21579	Fri, 24 March 2023 01:46 By: arun888
xml converting task 11g By: urmas19 on Wed, 22 March 2023	7	15307	Thu, 23 March 2023 14:11 By: mathguy
convert xml column value into columns Oracle 19c By: avtaritet on Mon, 20 March 2023	3	9371	Tue, 21 March 2023 09:20 By: avtaritet
Refreshing Materialized View oracle 10g By: chat2raj.s on Sun, 13 November 2022	11	21145	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	19879	Thu, 16 March 2023 01:33 By: OraFerro
Suggestion on count via sql statement Oracle 12c By: akssre on Fri, 10 March 2023	14	12688	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	48755	Mon, 13 March 2023 19:29 By: mathguy
XML parsing performance 19c By: mape on Sun, 12 March 2023	0	15196	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	9455	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	18221	Tue, 07 March 2023 15:17 By: Michel Cadot
Grouping with the previous one if identical By: questvba on Tue, 21 February 2023	12	24215	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	19804	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	4278	Mon, 06 March 2023 01:05 By: Michel Cadot
Optional parameter in Where clause 11g, Windows By: RM33 on Fri, 24 February 2023	3	17544	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	22791	Fri, 17 February 2023 20:00 By: Duane