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 16384 Tue, 30 June 2020 11:23
By: Michel Cadot
  sticky: Row generator ( 1 2)
By: Michel Cadot on Thu, 03 January 2008
43 243414 Tue, 06 November 2018 14:17
By: Solomon Yakobson
  ten-digit hexadecimal number
12.1.0.2.0
By: mape on Tue, 01 December 2020
0 16 Tue, 01 December 2020 01:31
By: mape
  Need help to rewrite the query
11G
By: nikhiljuneja@gmail.com on Mon, 30 November 2020
4 198 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 2155 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 336 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 1508 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 2604 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 3200 Thu, 26 November 2020 00:07
By: Michel Cadot
  Day book format
oracle 10g, windows 7
By: hissam78 on Tue, 24 November 2020
9 3677 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 6762 Sat, 21 November 2020 07:30
By: Solomon Yakobson
icon6.gif Query with LIKE too SLOW...
By: aimy on Fri, 20 November 2020
9 6159 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 2888 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 4479 Tue, 17 November 2020 02:46
By: enniwesw
  Date to Jewish/Hebrew Date (2 merged)
By: LiorI on Sun, 15 November 2020
2 3560 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 2552 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 4877 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 2078 Wed, 11 November 2020 08:14
By: mape
icon1.gif OLAP sql-cube operator
By: jusasi on Fri, 06 November 2020
1 2451 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 3945 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 1252 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 2044 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 1489 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 2218 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 1563 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 1429 Tue, 03 November 2020 12:49
By: Michel Cadot
  SQL query
By: Sql ia on Mon, 02 November 2020
6 1738 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 2787 Tue, 03 November 2020 05:32
By: scotthillierfrontera
  Joining multiple tables with case
By: aznabeel@yahoo.com on Wed, 28 October 2020
4 1394 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 1580 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 1890 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 1564 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 1955 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 1676 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 1816 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 3466 Sun, 25 October 2020 22:29
By: flyboy
  Get Distinct Data
Oracle
By: james94539 on Sun, 25 October 2020
4 1127 Sun, 25 October 2020 12:51
By: Michel Cadot
  Split Partition with Online / Update global indexes clause
11.2.0.4
By: azeem87 on Fri, 09 October 2020
19 3371 Thu, 22 October 2020 13:40
By: azeem87
  To_char date with and without format
11.2.0.1.0
By: OraFerro on Thu, 22 October 2020
2 1040 Thu, 22 October 2020 06:35
By: Solomon Yakobson
  Tree order, Sum of valid values
Oracle 12.2.0.
By: vasudevaviswa on Tue, 20 October 2020
2 826 Tue, 20 October 2020 12:39
By: vasudevaviswa
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: Tue Dec 01 02:23:11 CST 2020