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
  Announcement: How to use [code] tags and make your code easier to read
By: Michel Cadot on Thu, 01 November 2018
2 17357 Tue, 30 June 2020 11:23
By: Michel Cadot
  sticky: Row generator ( 1 2)
By: Michel Cadot on Thu, 03 January 2008
43 246603 Tue, 06 November 2018 14:17
By: Solomon Yakobson
  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 2037 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 3145 Wed, 13 January 2021 17:21
By: jrgOra
  Substring Query in Oracle SQL
Oracle 11g
By: abhayman on Fri, 08 January 2021
8 9209 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 8114 Fri, 08 January 2021 00:35
By: Michel Cadot
  Regex Help
By: ssmith001 on Thu, 07 January 2021
2 9901 Thu, 07 January 2021 12:56
By: ssmith001
  opening and closing balance
oracle 19c
By: learner123 on Thu, 07 January 2021
4 6900 Thu, 07 January 2021 06:36
By: learner123
  SQL query.
Oracle 11g.
By: akarra21 on Mon, 28 December 2020
10 7708 Wed, 06 January 2021 00:02
By: Michel Cadot
  oracle pl/sql
11g
By: thirunakar ramesh on Mon, 04 January 2021
1 2157 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 5609 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 2649 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 5323 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 3361 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 1756 Fri, 18 December 2020 10:56
By: Michel Cadot
  Insufficient privileges?
By: Nicola Farina on Thu, 15 November 2001
5 4325 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 3767 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 6344 Wed, 16 December 2020 01:37
By: rafalbballer
  Ora-06502 error for json_value (merged)
Oracle 12
By: talhaparvaiz@yahoo.com on Sun, 13 December 2020
8 2891 Mon, 14 December 2020 15:07
By: Michel Cadot
  Display Numeric Value from Text Field
Oracle 10 G, Windows7
By: hissam78 on Fri, 11 December 2020
4 5349 Sun, 13 December 2020 00:31
By: Michel Cadot
  XML into one row
12.1.0.2
By: mape on Wed, 09 December 2020
7 3564 Wed, 09 December 2020 07:06
By: mape
  ten-digit hexadecimal number
12.1.0.2.0
By: mape on Tue, 01 December 2020
8 4793 Wed, 09 December 2020 06:10
By: mape
  REGEXP_REPLACE
Oracle 12c
By: sss111ind on Tue, 08 December 2020
2 1058 Tue, 08 December 2020 23:47
By: sss111ind
  string_api package that... has no body?
Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production 0 Windows
By: Darth Waiter on Wed, 02 December 2020
22 6332 Tue, 08 December 2020 18:28
By: flyboy
  Help for a noobie!
By: nail3r on Thu, 03 December 2020
1 3530 Thu, 03 December 2020 04:17
By: Michel Cadot
  Need help to rewrite the query
11G
By: nikhiljuneja@gmail.com on Mon, 30 November 2020
4 2533 Tue, 01 December 2020 00:27
By: nikhiljuneja@gmail.com
  week start from saturday
oracle 10g, windows 7
By: hissam78 on Sat, 28 November 2020
7 3948 Tue, 01 December 2020 00:17
By: Michel Cadot
  How to convert JSON into XML in Oracle 10g
By: Mark70 on Mon, 30 November 2020
1 2408 Mon, 30 November 2020 05:45
By: Michel Cadot
  Creating Procedure (2 merged)
Windows 10, Oracle Express Edition 10g, Developer 10g
By: shahzaib_4vip@hotmail.com on Sun, 29 November 2020
1 3655 Sun, 29 November 2020 04:21
By: Michel Cadot
  Table joining with two columns sharing a foreign key
By: richard_blaq on Thu, 26 November 2020
2 3162 Fri, 27 November 2020 05:43
By: Solomon Yakobson
  One row for multiple rows based on a condition
By: annacol on Wed, 25 November 2020
2 3637 Thu, 26 November 2020 00:07
By: Michel Cadot
  Day book format
oracle 10g, windows 7
By: hissam78 on Tue, 24 November 2020
9 4306 Tue, 24 November 2020 10:43
By: Michel Cadot
  Need SQL Logic For Comparing Data Between Two Tabless
Oracle
By: nrk1979 on Fri, 20 November 2020
3 7289 Sat, 21 November 2020 07:30
By: Solomon Yakobson
icon6.gif Query with LIKE too SLOW...
By: aimy on Fri, 20 November 2020
9 6783 Fri, 20 November 2020 10:16
By: Michel Cadot
  UPDATE query with three table join (3 merged)
oracle sql
By: harshitawk on Tue, 10 November 2020
4 3364 Wed, 18 November 2020 16:07
By: flyboy
  Count of records with the max(date) and Max(lastrecordid)
SQL
By: enniwesw on Thu, 12 November 2020
2 4890 Tue, 17 November 2020 02:46
By: enniwesw
  Date to Jewish/Hebrew Date (2 merged)
By: LiorI on Sun, 15 November 2020
2 3981 Sun, 15 November 2020 03:47
By: Michel Cadot
  Extract words from a string and use them as variables
oracle
By: Haykel_bh on Fri, 13 November 2020
5 2988 Sat, 14 November 2020 00:24
By: Michel Cadot
  table refresh process - discuss optoins
12.2
By: talhaparvaiz@yahoo.com on Thu, 12 November 2020
8 5445 Fri, 13 November 2020 01:22
By: John Watson
  table record into XML user defined (2 merged)
By: mape on Wed, 11 November 2020
8 2616 Wed, 11 November 2020 08:14
By: mape
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: Mon Jan 18 14:59:02 CST 2021