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
  Display Numeric Value from Text Field
Oracle 10 G, Windows7
By: hissam78 on Fri, 11 December 2020
4 6351 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 4801 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 6026 Wed, 09 December 2020 06:10
By: mape
  REGEXP_REPLACE
Oracle 12c
By: sss111ind on Tue, 08 December 2020
2 1924 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 8289 Tue, 08 December 2020 18:28
By: flyboy
  Help for a noobie!
By: nail3r on Thu, 03 December 2020
1 4318 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 3517 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 5025 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 3307 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 4358 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 3909 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 4373 Thu, 26 November 2020 00:07
By: Michel Cadot
  Day book format
oracle 10g, windows 7
By: hissam78 on Tue, 24 November 2020
9 5296 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 8082 Sat, 21 November 2020 07:30
By: Solomon Yakobson
icon6.gif Query with LIKE too SLOW...
By: aimy on Fri, 20 November 2020
9 7698 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 4116 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 5686 Tue, 17 November 2020 02:46
By: enniwesw
  Date to Jewish/Hebrew Date (2 merged)
By: LiorI on Sun, 15 November 2020
2 4762 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 3719 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 6140 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 3293 Wed, 11 November 2020 08:14
By: mape
icon1.gif OLAP sql-cube operator
By: jusasi on Fri, 06 November 2020
1 3313 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 4818 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 1974 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 2795 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 2237 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 3120 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 2243 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 2018 Tue, 03 November 2020 12:49
By: Michel Cadot
  SQL query
By: Sql ia on Mon, 02 November 2020
6 2408 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 3706 Tue, 03 November 2020 05:32
By: scotthillierfrontera
  Joining multiple tables with case
By: aznabeel@yahoo.com on Wed, 28 October 2020
4 2057 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 2187 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 2494 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 2217 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 2717 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 2282 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 2523 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 4261 Sun, 25 October 2020 22:29
By: flyboy
  Get Distinct Data
Oracle
By: james94539 on Sun, 25 October 2020
4 1715 Sun, 25 October 2020 12:51
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: Thu May 06 11:58:22 CDT 2021