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
  SQL query.
Oracle 11g.
By: akarra21 on Mon, 28 December 2020
10 10838 Wed, 06 January 2021 00:02
By: Michel Cadot
  oracle pl/sql
11g
By: thirunakar ramesh on Mon, 04 January 2021
1 3796 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 7377 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 4116 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 7610 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 4900 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 3455 Fri, 18 December 2020 10:56
By: Michel Cadot
  Insufficient privileges?
By: Nicola Farina on Thu, 15 November 2001
5 6739 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 5748 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 9233 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 5501 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 7371 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 6111 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 7602 Wed, 09 December 2020 06:10
By: mape
  REGEXP_REPLACE
Oracle 12c
By: sss111ind on Tue, 08 December 2020
2 2653 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 10737 Tue, 08 December 2020 18:28
By: flyboy
  Help for a noobie!
By: nail3r on Thu, 03 December 2020
1 5015 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 4363 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 6198 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 4381 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 4939 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 4577 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 5072 Thu, 26 November 2020 00:07
By: Michel Cadot
  Day book format
oracle 10g, windows 7
By: hissam78 on Tue, 24 November 2020
9 6584 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 9258 Sat, 21 November 2020 07:30
By: Solomon Yakobson
icon6.gif Query with LIKE too SLOW...
By: aimy on Fri, 20 November 2020
9 9269 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 4968 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 6411 Tue, 17 November 2020 02:46
By: enniwesw
  Date to Jewish/Hebrew Date (2 merged)
By: LiorI on Sun, 15 November 2020
2 5724 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 4493 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 7152 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 4283 Wed, 11 November 2020 08:14
By: mape
icon1.gif OLAP sql-cube operator
By: jusasi on Fri, 06 November 2020
1 3983 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 5582 Fri, 06 November 2020 03:07
By: Haykel_bh
  How can I execute multiple SQL statements in one batch?
Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production 0 Windows
By: Darth Waiter on Thu, 05 November 2020
6 2724 Thu, 05 November 2020 10:15
By: Michel Cadot
  How can I model a column in a new table after a column in an existing table?
By: Darth Waiter on Wed, 04 November 2020
4 3477 Thu, 05 November 2020 10:02
By: EdStevens
  A regular user cannot create Varchar2(32767)
Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production 0 Windows
By: Darth Waiter on Wed, 04 November 2020
1 2959 Wed, 04 November 2020 15:01
By: Michel Cadot
icon3.gif Nested JSON_ARRAYAGG --> ORA-00937 - how to create json structure
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
By: autenrip on Wed, 04 November 2020
2 4918 Wed, 04 November 2020 10:17
By: autenrip
  How to subtract dates between different rows
Oracle 12
By: talhaparvaiz@yahoo.com on Tue, 03 November 2020
4 3287 Tue, 03 November 2020 23:43
By: talhaparvaiz@yahoo.com
  ORA-02315: incorrect number of arguments for default constructor
Oracle 12.2
By: TroyHoopes on Tue, 03 November 2020
3 2823 Tue, 03 November 2020 12:49
By: Michel Cadot
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: Sun May 22 11:25:06 CDT 2022