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
  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 9504 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 6002 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 4888 Fri, 18 December 2020 10:56
By: Michel Cadot
  Insufficient privileges?
By: Nicola Farina on Thu, 15 November 2001
5 8368 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 7112 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 11531 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 7544 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 8847 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 8084 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 10001 Wed, 09 December 2020 06:10
By: mape
  REGEXP_REPLACE
Oracle 12c
By: sss111ind on Tue, 08 December 2020
2 3896 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 14295 Tue, 08 December 2020 18:28
By: flyboy
  Help for a noobie!
By: nail3r on Thu, 03 December 2020
1 6114 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 5769 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 8234 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 6365 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 5968 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 5754 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 6298 Thu, 26 November 2020 00:07
By: Michel Cadot
  Day book format
oracle 10g, windows 7
By: hissam78 on Tue, 24 November 2020
9 8871 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 11090 Sat, 21 November 2020 07:30
By: Solomon Yakobson
icon6.gif Query with LIKE too SLOW...
By: aimy on Fri, 20 November 2020
9 11725 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 6587 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 7933 Tue, 17 November 2020 02:46
By: enniwesw
  Date to Jewish/Hebrew Date (2 merged)
By: LiorI on Sun, 15 November 2020
2 7245 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 5920 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 8849 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 5861 Wed, 11 November 2020 08:14
By: mape
icon1.gif OLAP sql-cube operator
By: jusasi on Fri, 06 November 2020
1 5167 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 7129 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 5357 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 4932 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 5072 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 8454 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 4962 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 4486 Tue, 03 November 2020 12:49
By: Michel Cadot
  SQL query
By: Sql ia on Mon, 02 November 2020
6 5185 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 10002 Tue, 03 November 2020 05:32
By: scotthillierfrontera
  Joining multiple tables with case
By: aznabeel@yahoo.com on Wed, 28 October 2020
4 4453 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 4726 Mon, 02 November 2020 09:32
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 Apr 25 09:38:02 CDT 2024