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
  Ora-06502 error for json_value (merged)
Oracle 12
By: talhaparvaiz@yahoo.com on Sun, 13 December 2020
8 4154 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 6370 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 4807 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 6032 Wed, 09 December 2020 06:10
By: mape
  REGEXP_REPLACE
Oracle 12c
By: sss111ind on Tue, 08 December 2020
2 1932 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 8298 Tue, 08 December 2020 18:28
By: flyboy
  Help for a noobie!
By: nail3r on Thu, 03 December 2020
1 4320 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 3528 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 5027 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 3313 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 4360 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 3910 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 4378 Thu, 26 November 2020 00:07
By: Michel Cadot
  Day book format
oracle 10g, windows 7
By: hissam78 on Tue, 24 November 2020
9 5306 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 8090 Sat, 21 November 2020 07:30
By: Solomon Yakobson
icon6.gif Query with LIKE too SLOW...
By: aimy on Fri, 20 November 2020
9 7705 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 4123 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 5689 Tue, 17 November 2020 02:46
By: enniwesw
  Date to Jewish/Hebrew Date (2 merged)
By: LiorI on Sun, 15 November 2020
2 4773 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 3722 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 6143 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 3302 Wed, 11 November 2020 08:14
By: mape
icon1.gif OLAP sql-cube operator
By: jusasi on Fri, 06 November 2020
1 3317 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 4823 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 1977 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 2799 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 2242 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 3125 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 2250 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 2022 Tue, 03 November 2020 12:49
By: Michel Cadot
  SQL query
By: Sql ia on Mon, 02 November 2020
6 2411 Tue, 03 November 2020 05:34
By: John Watson
  ORA-29268, 400 - Bad Request trying to send Tweet using REST Api from PL/SQL using UTL_HTTP.
By: scotthillierfrontera on Fri, 30 October 2020
6 3715 Tue, 03 November 2020 05:32
By: scotthillierfrontera
  Joining multiple tables with case
By: aznabeel@yahoo.com on Wed, 28 October 2020
4 2058 Mon, 02 November 2020 12:40
By: EdStevens
  How to display only one row with max no. of count?
Oracle 11g database
By: SumuHadi on Sun, 01 November 2020
4 2193 Mon, 02 November 2020 09:32
By: Michel Cadot
  Improve Performance of Insert and Update on same table
12.1.0.2.0
By: Shre on Mon, 19 October 2020
4 2501 Fri, 30 October 2020 10:51
By: Shre
  What is the proper termination for a stored procedure created from C# code?
Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production 0 Windows
By: Darth Waiter on Wed, 28 October 2020
3 2225 Wed, 28 October 2020 14:22
By: Michel Cadot
  A query that works in SquirrelSLQL fails in C#
Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production 0 Windows
By: Darth Waiter on Tue, 27 October 2020
4 2725 Wed, 28 October 2020 08:13
By: Darth Waiter
  ORA-1403 when trying to select after Insert
Oracle 10g
By: pjizquierdo on Tue, 27 October 2020
4 2285 Wed, 28 October 2020 07:54
By: pjizquierdo
  SQL to retrieve lines based on a static value
By: 891ashok@gmail.com on Mon, 26 October 2020
12 2530 Tue, 27 October 2020 18:43
By: Solomon Yakobson
  temp table not returning data in WITH
18.10
By: radrodeo9 on Thu, 22 October 2020
11 4265 Sun, 25 October 2020 22:29
By: flyboy
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: Sat May 08 19:58:06 CDT 2021