Home » SQL & PL/SQL » SQL & PL/SQL
Please read the OraFAQ Forum Guide before posting.
Please contribute good answers to the wiki.

    Replies Views Last message
  Comparing input values with table data
Oracle 19c Enterprise Edition Release 19.0.0.0
By: kumarravik on Tue, 02 March 2021
1 4490 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 19968 Sat, 27 February 2021 18:19
By: Youssef_Tadros
  Auto Sequence number for specific subinventory transactions
By: smk08 on Sat, 27 February 2021
1 7805 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 5982 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 3917 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 3178 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 5571 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 3489 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 7669 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 3735 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 5332 Sat, 20 February 2021 01:28
By: John Watson
  postgres Range Type equivalent in oracle.
Oracle19c
By: Shrin on Thu, 18 February 2021
4 5544 Thu, 18 February 2021 11:20
By: Michel Cadot
icon9.gif 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 10124 Wed, 17 February 2021 12:16
By: pablolee
  date validation
OS
By: suji6281 on Fri, 01 March 2019
15 12148 Sun, 14 February 2021 08:53
By: EdStevens
  Max value row and lookup value
By: suji6281 on Wed, 10 February 2021
4 5632 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 7201 Mon, 08 February 2021 03:22
By: Shre
  Regexp_like
Oracle 12c, Win 10
By: rajivn786 on Fri, 05 February 2021
8 7271 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 5406 Fri, 05 February 2021 04:30
By: juniordbanewbie
  Alternative approach for a query run programmatically.
12
By: ritmo2k on Mon, 01 February 2021
14 9962 Thu, 04 February 2021 11:38
By: Michel Cadot
  ROW_NUMBER() not working properly?
By: chachamenci on Thu, 28 January 2021
4 10094 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 5549 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 7049 Mon, 01 February 2021 00:50
By: ags.island
  logic sql or plsql (merged)
By: yashi7777 on Sat, 23 January 2021
28 13062 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 4609 Mon, 25 January 2021 05:19
By: Bill B
  Regex Help
By: ssmith001 on Thu, 07 January 2021
3 14702 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 7462 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 8403 Wed, 13 January 2021 17:21
By: jrgOra
  Substring Query in Oracle SQL
Oracle 11g
By: abhayman on Fri, 08 January 2021
8 15213 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 14370 Fri, 08 January 2021 00:35
By: Michel Cadot
  opening and closing balance
oracle 19c
By: learner123 on Thu, 07 January 2021
3 10250 Thu, 07 January 2021 06:36
By: learner123
  SQL query.
Oracle 11g.
By: akarra21 on Mon, 28 December 2020
10 13163 Wed, 06 January 2021 00:02
By: Michel Cadot
  oracle pl/sql
11g
By: thirunakar ramesh on Mon, 04 January 2021
1 4985 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 8688 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 5190 Wed, 30 December 2020 00:21
By: Dhabhu
  Partitoning taking long time
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
By: sss111ind on Tue, 15 December 2020
5 9383 Thu, 24 December 2020 13:04
By: Solomon Yakobson
  DBMS_HS_PASSTHROUGH - Column Value Truncated
SQL*Plus: Release 11.2.0.1.0 [Server version: 5.7.29-5-log MySQL Community Server - (GPL)]
By: aimy on Mon, 21 December 2020
0 5915 Mon, 21 December 2020 10:38
By: aimy
  ORA 08103 - object no longer exists referring a temporary table
By: NZZ on Fri, 18 December 2020
1 4780 Fri, 18 December 2020 10:56
By: Michel Cadot
  Insufficient privileges?
By: Nicola Farina on Thu, 15 November 2001
5 8257 Fri, 18 December 2020 01:25
By: Michel Cadot
  Mix of Cross and Full Outer Join
https://livesql.oracle.com/apex
By: manubatham20 on Tue, 15 December 2020
5 7035 Wed, 16 December 2020 02:02
By: Michel Cadot
  tab_to_string for longer texts ORA-06502-numeric or value error string
By: rafalbballer on Tue, 01 December 2020
9 11454 Wed, 16 December 2020 01:37
By: rafalbballer
Goto Forum:
  
Legend New Messages New Messages   No New messages No New messages   Locked (w/ unread messages) Locked (w/ unread messages)   Locked Locked   Moved to another forum Moved to another forum

Current Time: Thu Mar 28 16:43:21 CDT 2024