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
  Unable to get the PL/SQL block to work
Oracle 12c, O/S: Windows 10 pro
By: buggleboy007 on Fri, 16 July 2021
3 7717 Sat, 17 July 2021 12:29
By: buggleboy007
  Issues with my Associative Array inside a Package spec
Oracle 12c, O/S: Windows 10 pro
By: buggleboy007 on Thu, 15 July 2021
3 8223 Sat, 17 July 2021 12:26
By: buggleboy007
  CASE in where Clause (4 merged)
SQL
By: Sekhar6617 on Fri, 16 July 2021
5 9713 Sat, 17 July 2021 10:50
By: Sekhar6617
  How to convert multi_byte to single_byte character
Oracle 11g
By: Andrey_R on Thu, 10 June 2021
7 7556 Thu, 15 July 2021 05:22
By: Andrey_R
  Issues with my Associative Array
Oracle 12c, O/S: Windows 10 pro
By: buggleboy007 on Fri, 09 July 2021
4 11812 Sat, 10 July 2021 14:58
By: buggleboy007
  Getting PLS: 00306 wrong number or types of arguments in call to
11.2.0.4
By: kamaluv234 on Wed, 30 June 2021
3 4746 Thu, 01 July 2021 00:25
By: kamaluv234
  two different counts in select
By: Sekhar6617 on Mon, 28 June 2021
11 6219 Tue, 29 June 2021 06:33
By: Sekhar6617
  Listing table names,noofrows,noofcolumns primarkeyscol in a schema
oracle 12c
By: sekharsomu on Mon, 21 June 2021
5 10541 Mon, 21 June 2021 21:55
By: sekharsomu
  Automate repartitions
11.2.0.3
By: Amine on Fri, 11 June 2021
1 9173 Mon, 21 June 2021 17:42
By: Amine
  Help improve SQL Query
12c Linux
By: deepa_balu on Tue, 15 June 2021
1 8831 Tue, 15 June 2021 14:05
By: Michel Cadot
  ANSI vs Oracle Join Syntax
By: dancko on Sat, 12 June 2021
7 9517 Tue, 15 June 2021 12:04
By: Littlefoot
  dbms_scheduler.create_job() throws error ORA-27362
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
By: wtolentino on Fri, 11 June 2021
2 9373 Mon, 14 June 2021 08:29
By: wtolentino
  Data masking in oracle
Oracle
By: bkbora on Fri, 11 June 2021
4 5983 Fri, 11 June 2021 21:59
By: bkbora
  Data Extraction
Oracle 12C
By: ssharmila on Fri, 11 June 2021
1 4282 Fri, 11 June 2021 10:43
By: Michel Cadot
  CHR(n) equivalent function for double-byte characters
Oracle 12.1.0.2.0
By: Andrey_R on Thu, 10 June 2021
5 2836 Thu, 10 June 2021 12:17
By: Solomon Yakobson
  Compare rows
11.2.0.3
By: Amine on Tue, 06 October 2015
5 4756 Tue, 08 June 2021 09:39
By: Michel Cadot
  View creation
12c and 11g
By: BunnyWorld123 on Tue, 08 June 2021
1 4597 Tue, 08 June 2021 07:39
By: John Watson
  How to spead up query that calls the save view multiple times
12
By: helixpoint on Tue, 01 June 2021
3 6006 Wed, 02 June 2021 05:55
By: Solomon Yakobson
  Nested Queries with Select Statement
Oracle 12 c, 12.1.0.1
By: a_naq on Mon, 10 May 2021
13 22734 Wed, 26 May 2021 10:02
By: BlackSwan
  Present value calculations in Oracle
12.1.0.1
By: OraFerro on Mon, 24 May 2021
2 13161 Mon, 24 May 2021 04:34
By: John Watson
  SUM of parent and child records
11.2
By: mist598 on Sun, 23 May 2021
1 12168 Mon, 24 May 2021 00:36
By: Michel Cadot
  Cents corrupted on large number
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
By: Buchas on Tue, 18 May 2021
2 6555 Tue, 18 May 2021 04:13
By: Buchas
  Timezone Europe/Paris
10GR1 HPUX
By: davy7887 on Fri, 07 May 2021
5 11871 Sun, 16 May 2021 14:30
By: EdStevens
  Optimization of SQL
12.2
By: swasora on Sun, 09 May 2021
2 10295 Sun, 09 May 2021 06:55
By: Solomon Yakobson
icon5.gif multiple queries and 1 output window/result
Oracle SQL Developer 19.1.0.094 / Oracle Database 12.2.0.1.0
By: abenitez77 on Mon, 03 May 2021
6 7165 Mon, 03 May 2021 12:08
By: Michel Cadot
  how to get the rows of different values of single column
By: Sekhar6617 on Wed, 21 April 2021
9 9528 Mon, 03 May 2021 07:23
By: Sekhar6617
  sql regex_instr
oracle 11g
By: CindyC on Thu, 29 April 2021
11 11386 Fri, 30 April 2021 16:38
By: CindyC
  substring compare and update
oracle 11g
By: CindyC on Wed, 28 April 2021
0 4204 Wed, 28 April 2021 15:33
By: CindyC
  how to change a column to a virtual
Linux RDBMS 12c
By: evoradba on Wed, 28 April 2021
2 3059 Wed, 28 April 2021 15:03
By: evoradba
  ORA-00979
By: a_naq on Wed, 28 April 2021
5 3431 Wed, 28 April 2021 12:23
By: Solomon Yakobson
  pipeline function call in a stored proc and loop
By: desmond30 on Mon, 26 April 2021
8 6032 Tue, 27 April 2021 10:14
By: desmond30
  grouping logic
oracle 11g
By: yashi7777 on Sat, 24 April 2021
6 7293 Mon, 26 April 2021 20:01
By: yashi7777
  Listagg over Listagg
Oracle 12g
By: abhayman on Sat, 24 April 2021
2 3651 Sat, 24 April 2021 03:03
By: abhayman
  upper case in create table
By: jchiu183 on Thu, 19 January 2006
6 10116 Sun, 18 April 2021 05:00
By: Michel Cadot
  Hierarchy again and again and again !
11.2.0.3
By: Amine on Wed, 14 April 2021
3 6453 Thu, 15 April 2021 05:02
By: Michel Cadot
  how to remove html tags from the text
By: Sekhar6617 on Thu, 08 April 2021
8 10610 Wed, 14 April 2021 23:16
By: Sekhar6617
  ORA-00904: "SUPPID": invalid identifier
oracle
By: whotheunknown on Sat, 10 April 2021
5 7450 Mon, 12 April 2021 18:30
By: EdStevens
  Query to Display date
11g
By: glmjoy on Fri, 09 April 2021
2 9385 Fri, 09 April 2021 07:14
By: glmjoy
  Mark Only Selected Portion of a Column Data
12.1
By: azeem87 on Thu, 08 April 2021
4 8559 Fri, 09 April 2021 00:20
By: Michel Cadot
  Display zero if negative value.
Oracle 8i, Windows Server 2003
By: kumarvk on Mon, 09 January 2012
3 14699 Wed, 07 April 2021 04:49
By: Udays
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 Oct 19 01:15:10 CDT 2021