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	18468	Tue, 30 June 2020 11:23 By: Michel Cadot
sticky: Row generator ( 1 2) By: Michel Cadot on Thu, 03 January 2008	43	250359	Tue, 06 November 2018 14:17 By: Solomon Yakobson
Oracle: sql update on field containing sql itself Oracle Database 11g By: apisto on Wed, 03 March 2021	2	132	Wed, 03 March 2021 06:38 By: apisto
Generate SQL via SQL By: mikewazowski on Tue, 23 February 2021	28	3469	Wed, 03 March 2021 02:29 By: Michel Cadot
Reading text from binary data in a blob By: appender on Sat, 27 February 2021	2	5046	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	913	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	787	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	14026	Sat, 27 February 2021 18:19 By: Youssef_Tadros
Auto Sequence number for specific subinventory transactions By: smk08 on Sat, 27 February 2021	1	5440	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	3284	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	798	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	820	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	2146	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	629	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	2168	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	1035	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	2474	Sat, 20 February 2021 01:28 By: John Watson
postgres Range Type equivalent in oracle. Oracle19c By: Shrin on Thu, 18 February 2021	4	2317	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	5836	Wed, 17 February 2021 12:16 By: pablolee
date validation OS By: suji6281 on Fri, 01 March 2019	15	6283	Sun, 14 February 2021 08:53 By: EdStevens
Max value row and lookup value By: suji6281 on Wed, 10 February 2021	4	1775	Wed, 10 February 2021 17:24 By: suji6281
Parse Json using Oracle SQL Oracle DB version 12.1.02 By: Shre on Fri, 05 February 2021	5	3674	Mon, 08 February 2021 03:22 By: Shre
Regexp_like Oracle 12c, Win 10 By: rajivn786 on Fri, 05 February 2021	8	3224	Sat, 06 February 2021 01:43 By: Michel Cadot
old hash value is used to identify same sql and Plan hash value is to identify sql plans? 19.0.0 windows 2016 By: juniordbanewbie on Fri, 05 February 2021	0	2536	Fri, 05 February 2021 04:30 By: juniordbanewbie
Alternative approach for a query run programmatically. 12 By: ritmo2k on Mon, 01 February 2021	14	5509	Thu, 04 February 2021 11:38 By: Michel Cadot
ROW_NUMBER() not working properly? By: chachamenci on Thu, 28 January 2021	4	6224	Mon, 01 February 2021 10:44 By: chachamenci
Transfer the temporary file to the client machine after all files have been processed. forms 10g By: cristine_katia on Mon, 01 February 2021	0	3743	Mon, 01 February 2021 09:17 By: cristine_katia
How to Repeat Row by Specific Value in Data Field Oracle EBS R12 By: ags.island on Sun, 31 January 2021	4	4184	Mon, 01 February 2021 00:50 By: ags.island
logic sql or plsql (merged) By: yashi7777 on Sat, 23 January 2021	28	5964	Mon, 25 January 2021 23:59 By: Michel Cadot
print "+" when using to_char oracle 12c r1 By: robh0502 on Sun, 24 January 2021	3	2408	Mon, 25 January 2021 05:19 By: Bill B
Regex Help By: ssmith001 on Thu, 07 January 2021	3	12322	Mon, 25 January 2021 05:16 By: Bill B
Weird PL/SQL behavior with SQL statement containing a function in WITH clause 12.1 to 19.8 By: Michel Cadot on Fri, 15 January 2021	0	5070	Fri, 15 January 2021 13:39 By: Michel Cadot
After "Drop Materialized View" it's data continuing be shown Oracle Database 12c EE 12.2.0.1.0 on Windows 64bit By: jrgOra on Tue, 12 January 2021	4	4568	Wed, 13 January 2021 17:21 By: jrgOra
Substring Query in Oracle SQL Oracle 11g By: abhayman on Fri, 08 January 2021	8	10824	Fri, 08 January 2021 06:35 By: Solomon Yakobson
DBMS_HS_PASSTHROUGH - Database Link as Input Parameter By: aimy on Wed, 06 January 2021	8	9058	Fri, 08 January 2021 00:35 By: Michel Cadot
opening and closing balance oracle 19c By: learner123 on Thu, 07 January 2021	3	7523	Thu, 07 January 2021 06:36 By: learner123
SQL query. Oracle 11g. By: akarra21 on Mon, 28 December 2020	10	8647	Wed, 06 January 2021 00:02 By: Michel Cadot
oracle pl/sql 11g By: thirunakar ramesh on Mon, 04 January 2021	1	2747	Mon, 04 January 2021 11:27 By: Michel Cadot
Fuzzy Matching S-Q-L Sever Taking Fime for 2.4 millions records By: mohsin_zee on Thu, 31 December 2020	1	6253	Thu, 31 December 2020 14:26 By: Michel Cadot
sending bulk email in Report 12c? Report 12c By: Dhabhu on Wed, 30 December 2020	0	3231	Wed, 30 December 2020 00:21 By: Dhabhu