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
Hierarchy again and again and again ! 11.2.0.3 By: Amine on Wed, 14 April 2021	3	6236	Thu, 15 April 2021 05:02 By: Michel Cadot
how to remove html tags from the text By: Sekhar6617 on Thu, 08 April 2021	8	10407	Wed, 14 April 2021 23:16 By: Sekhar6617
ORA-00904: "SUPPID": invalid identifier oracle By: whotheunknown on Sat, 10 April 2021	5	7239	Mon, 12 April 2021 18:30 By: EdStevens
Query to Display date 11g By: glmjoy on Fri, 09 April 2021	2	9210	Fri, 09 April 2021 07:14 By: glmjoy
Mark Only Selected Portion of a Column Data 12.1 By: azeem87 on Thu, 08 April 2021	4	8345	Fri, 09 April 2021 00:20 By: Michel Cadot
Display zero if negative value. Oracle 8i, Windows Server 2003 By: kumarvk on Mon, 09 January 2012	3	14066	Wed, 07 April 2021 04:49 By: Udays
Oracle Sql statements R12 By: Andrescr5 on Mon, 05 April 2021	1	1440	Mon, 05 April 2021 11:41 By: EdStevens
Query PL/SQL Urgent By: Vins82 on Fri, 02 April 2021	1	4793	Fri, 02 April 2021 03:56 By: Michel Cadot
filtering for records based on select criteria oracle plsql By: padler on Wed, 31 March 2021	2	5341	Thu, 01 April 2021 09:23 By: John Watson
Disperse credit notes between groups of invoices Oracle12c Release 12.1.0.2.0 By: Heavyd on Wed, 31 March 2021	1	3611	Wed, 31 March 2021 07:19 By: Heavyd
query display like aging 11g By: glmjoy on Tue, 30 March 2021	6	6796	Wed, 31 March 2021 01:15 By: glmjoy
group by common string oracle 11g By: yashi7777 on Wed, 17 March 2021	8	11042	Mon, 29 March 2021 20:49 By: yashi7777
Analytical functions By: jay_yan on Mon, 29 March 2021	4	4017	Mon, 29 March 2021 10:30 By: Michel Cadot
sort with duplicate records 12 By: mape on Sat, 27 March 2021	5	4970	Sun, 28 March 2021 12:01 By: mape
12.1.0.1 Filter dates between a list of start and end dates By: OraFerro on Thu, 25 March 2021	2	7154	Sat, 27 March 2021 23:25 By: OraFerro
how to use select field value in where clause (merged) By: Sekhar6617 on Wed, 24 March 2021	2	5994	Wed, 24 March 2021 11:49 By: Michel Cadot
Generate SQL via SQL By: mikewazowski on Tue, 23 February 2021	32	13747	Thu, 18 March 2021 03:25 By: Michel Cadot
Generating Installment rows 12.1.0.1 By: OraFerro on Tue, 16 March 2021	1	8871	Tue, 16 March 2021 23:28 By: OraFerro
Beginner question. Update query with another SQL 11g By: RM33 on Sat, 13 March 2021	2	5113	Sun, 14 March 2021 06:10 By: Littlefoot
Parsing XML multiple CDATA with & and withoutn & Oracle 12c 2 By: sss111ind on Sun, 07 March 2021	3	7966	Mon, 08 March 2021 04:17 By: Solomon Yakobson
Need help on Tabibitosan (start of group) 11.2.0.3 By: Amine on Fri, 05 March 2021	16	10741	Sat, 06 March 2021 16:49 By: Amine
Setting up Email service on Oracle 9i Oracle Database 9i By: rfcl on Thu, 04 March 2021	9	6429	Fri, 05 March 2021 00:54 By: Michel Cadot
How to call/execute a visual basic script using PL / SQL oracle db v9i By: rfcl on Thu, 04 March 2021	2	6443	Fri, 05 March 2021 00:13 By: rfcl
schema level dml trigger oracle 10g By: pradeep08 on Wed, 03 March 2021	2	4441	Thu, 04 March 2021 12:32 By: EdStevens
Oracle: sql update on field containing sql itself Oracle Database 11g By: apisto on Wed, 03 March 2021	2	2990	Wed, 03 March 2021 06:38 By: apisto
Reading text from binary data in a blob By: appender on Sat, 27 February 2021	2	6657	Tue, 02 March 2021 11:29 By: Michel Cadot
Group result set in a count of 5 records. By: Heavyd on Mon, 22 February 2021	8	2648	Tue, 02 March 2021 08:12 By: Heavyd
Comparing input values with table data Oracle 19c Enterprise Edition Release 19.0.0.0 By: kumarravik on Tue, 02 March 2021	1	2795	Tue, 02 March 2021 06:01 By: Michel Cadot
remove comments from all_source output 10g r2 By: Kevin Meade on Thu, 27 March 2008	15	15787	Sat, 27 February 2021 18:19 By: Youssef_Tadros
Auto Sequence number for specific subinventory transactions By: smk08 on Sat, 27 February 2021	1	6246	Sat, 27 February 2021 02:16 By: Michel Cadot
call sql server procedure from oracle Oracle 12c 2 By: sss111ind on Fri, 26 February 2021	0	4745	Fri, 26 February 2021 06:21 By: sss111ind
Generate month wise data using SQL (Sort data based on month) Oracle DB 11g Release 11.2.0.2.0 By: chauhanrahul780@yahoo.com on Mon, 22 February 2021	1	1514	Tue, 23 February 2021 00:17 By: Michel Cadot
A full outer join query 11.2.0.3 By: Amine on Sun, 21 February 2021	2	1503	Mon, 22 February 2021 14:16 By: Amine
Duplicate Records in output file Oracle, SQL Plus By: srai.bi on Tue, 16 February 2021	4	3002	Mon, 22 February 2021 05:15 By: srai.bi
convert char to number Oracle 12.1.0.2.0 By: mape on Mon, 22 February 2021	4	1343	Mon, 22 February 2021 05:13 By: Michel Cadot
Space is replaced by xA0 in SQL Query Oracle 12g, SQL Plus By: srai.bi on Thu, 18 February 2021	5	3130	Sun, 21 February 2021 16:29 By: srai.bi
Assigning one nested table to other in same position Oracle 12c 2 By: sss111ind on Sat, 20 February 2021	4	1743	Sun, 21 February 2021 16:07 By: Solomon Yakobson
Trigger on Table (4 merged) Oracle 19C database By: ettentrala on Fri, 19 February 2021	5	3170	Sat, 20 February 2021 01:28 By: John Watson
postgres Range Type equivalent in oracle. Oracle19c By: Shrin on Thu, 18 February 2021	4	3046	Thu, 18 February 2021 11:20 By: Michel Cadot
How to show records on zero on hand (Job pick list) EBiz, 11.5.10.2 By: jasmine.hue on Mon, 22 September 2008	11	6864	Wed, 17 February 2021 12:16 By: pablolee