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
  Regex Help
By: ssmith001 on Thu, 07 January 2021
3 15254 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 8045 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 9194 Wed, 13 January 2021 17:21
By: jrgOra
  Substring Query in Oracle SQL
Oracle 11g
By: abhayman on Fri, 08 January 2021
8 15899 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 15161 Fri, 08 January 2021 00:35
By: Michel Cadot
  opening and closing balance
oracle 19c
By: learner123 on Thu, 07 January 2021
3 10841 Thu, 07 January 2021 06:36
By: learner123
  SQL query.
Oracle 11g.
By: akarra21 on Mon, 28 December 2020
10 13842 Wed, 06 January 2021 00:02
By: Michel Cadot
  oracle pl/sql
11g
By: thirunakar ramesh on Mon, 04 January 2021
1 5596 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 9264 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 5739 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 10064 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 6494 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 5411 Fri, 18 December 2020 10:56
By: Michel Cadot
  Insufficient privileges?
By: Nicola Farina on Thu, 15 November 2001
5 8858 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 7592 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 12073 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 8101 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 9329 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 8650 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 10642 Wed, 09 December 2020 06:10
By: mape
  REGEXP_REPLACE
Oracle 12c
By: sss111ind on Tue, 08 December 2020
2 4384 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 15029 Tue, 08 December 2020 18:28
By: flyboy
  Help for a noobie!
By: nail3r on Thu, 03 December 2020
1 6572 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 6282 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 8817 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 6951 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 6436 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 6238 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 6792 Thu, 26 November 2020 00:07
By: Michel Cadot
  Day book format
oracle 10g, windows 7
By: hissam78 on Tue, 24 November 2020
9 9445 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 11668 Sat, 21 November 2020 07:30
By: Solomon Yakobson
icon6.gif Query with LIKE too SLOW...
By: aimy on Fri, 20 November 2020
9 12313 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 7152 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 8448 Tue, 17 November 2020 02:46
By: enniwesw
  Date to Jewish/Hebrew Date (2 merged)
By: LiorI on Sun, 15 November 2020
2 7766 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 6448 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 9423 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 6425 Wed, 11 November 2020 08:14
By: mape
icon1.gif OLAP sql-cube operator
By: jusasi on Fri, 06 November 2020
1 5664 Fri, 06 November 2020 05:21
By: Michel Cadot
  ORA-00979: not a GROUP BY expression
oracle 18c
By: Haykel_bh on Wed, 04 November 2020
4 7670 Fri, 06 November 2020 03:07
By: Haykel_bh
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: Fri Jul 26 22:53:12 CDT 2024