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
By: Sql ia on Mon, 02 November 2020
6 3400 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 5763 Tue, 03 November 2020 05:32
By: scotthillierfrontera
  Joining multiple tables with case
By: aznabeel@yahoo.com on Wed, 28 October 2020
4 2954 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 3057 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 3555 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 3137 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 3795 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 3436 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 4642 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 5470 Sun, 25 October 2020 22:29
By: flyboy
  Get Distinct Data
Oracle
By: james94539 on Sun, 25 October 2020
4 2821 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 6948 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 2346 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 2242 Tue, 20 October 2020 12:39
By: vasudevaviswa
icon4.gif How to generate a spool file without an extension name (.lst,.txt etc...)
SQL
By: senaubi_me on Sat, 02 February 2008
6 7050 Fri, 16 October 2020 08:15
By: EdStevens
  Pivot using SQL in Oracle
Oracle SQL Dev Version 17.3.1.279
By: calredd@yahoo.com on Thu, 15 October 2020
1 2007 Thu, 15 October 2020 10:23
By: Michel Cadot
  ORA-06502
Oracle 12 C windows
By: anncao on Tue, 13 October 2020
3 2106 Tue, 13 October 2020 18:51
By: Solomon Yakobson
  converting Unix Time format to readable format
By: talhaparvaiz@yahoo.com on Sun, 11 October 2020
9 4455 Mon, 12 October 2020 06:09
By: Solomon Yakobson
  Matrix Report Out put
Oracle 10 G, Windows7
By: hissam78 on Thu, 08 October 2020
5 2713 Sun, 11 October 2020 23:41
By: hissam78
  REgexp_substr function to extract sub string
By: talhaparvaiz@yahoo.com on Sun, 11 October 2020
2 2421 Sun, 11 October 2020 14:50
By: talhaparvaiz@yahoo.com
  RANK issue in SQL
By: aj123tx on Thu, 08 October 2020
3 2711 Sat, 10 October 2020 06:56
By: aj123tx
  Improve efficiency of script
19.2.1.247
By: Dan22 on Tue, 06 October 2020
7 6379 Fri, 09 October 2020 03:30
By: John Watson
  Duplicate delete condition
11.2
By: ritmo2k on Wed, 07 October 2020
6 2735 Thu, 08 October 2020 07:46
By: ritmo2k
  OBJECT TYPE Body creation ERROR
Oracle 19C, Window
By: Bilal Khan on Thu, 08 October 2020
3 1844 Thu, 08 October 2020 05:57
By: Michel Cadot
  Join Unique Tables
By: selami on Wed, 07 October 2020
2 2095 Wed, 07 October 2020 07:36
By: John Watson
  Loop with Dates
PL/SQL (Windows/Current Oracle vers)
By: Adjanti on Mon, 05 October 2020
4 2226 Tue, 06 October 2020 10:36
By: Michel Cadot
  Row Generator Using MODEL Clause, # Repeats Table-Based?
By: Art Metzer on Mon, 05 October 2020
2 2145 Tue, 06 October 2020 09:39
By: Art Metzer
  Test Oracle SQL
By: misterbean on Tue, 06 October 2020
2 1846 Tue, 06 October 2020 01:35
By: Michel Cadot
  extract string and compare
By: desmond30 on Mon, 05 October 2020
3 1761 Mon, 05 October 2020 15:24
By: desmond30
  Pass cursor to Procedure
12.1
By: ora9a on Sun, 04 October 2020
5 2346 Mon, 05 October 2020 05:06
By: Michel Cadot
  Group pivot column
11.2.0.1.0
By: OraFerro on Sun, 04 October 2020
13 2957 Mon, 05 October 2020 01:46
By: Michel Cadot
  update column for the set of records
By: mist598 on Tue, 29 September 2020
5 3077 Tue, 29 September 2020 07:12
By: Michel Cadot
  find the next occurrence of an event based on another event
SQL Developer 19.2.1
By: ac24 on Sat, 26 September 2020
2 3097 Sat, 26 September 2020 08:52
By: Solomon Yakobson
  How to get a substring from a character on
By: Mark70 on Fri, 25 September 2020
4 3319 Fri, 25 September 2020 10:44
By: Solomon Yakobson
  Can't connect with new user created
By: Mark70 on Tue, 30 June 2020
6 8908 Fri, 25 September 2020 03:45
By: John Watson
  Date format with UTC
By: Mark70 on Thu, 18 June 2020
4 9361 Fri, 25 September 2020 03:44
By: Mark70
  How to use table functions
By: Mark70 on Wed, 03 June 2020
4 8691 Fri, 25 September 2020 03:43
By: Mark70
  How to add SOAP elements to XML
Oracle 10g
By: Mark70 on Mon, 01 June 2020
4 7757 Fri, 25 September 2020 03:43
By: Mark70
  Finding entries missing a value and listing all used values for specific data
By: magriii on Wed, 23 September 2020
6 3794 Thu, 24 September 2020 07:52
By: EdStevens
  Query help on 5 tables.
Oracle, 11g
By: krajasekhar.n@gmail.com on Tue, 22 September 2020
4 4154 Tue, 22 September 2020 22:33
By: Iffat
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 12:03:12 CDT 2022