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
  Please help for Resolving issue with utl_file
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit
By: msol25 on Sun, 20 December 2015
25 549 Sun, 20 December 2015 15:46
By: BlackSwan
  dbms_ldap.simple_bind_s doesn't work with PW containing "!"
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0
By: Duane on Fri, 18 December 2015
7 715 Sun, 20 December 2015 13:42
By: Duane
  How to fetch data from multiple table based on a input date
Oracle 11g
By: suvijyo on Sat, 19 December 2015
3 552 Sun, 20 December 2015 05:10
By: Littlefoot
  Kind help with a pl sql for the below link I had posted
oracle 12c
By: vs140580 on Sun, 20 December 2015
0 510 Sun, 20 December 2015 00:55
By: vs140580
  find missing record
ORACLE 10G
By: nmd_group on Sat, 19 December 2015
10 634 Sat, 19 December 2015 10:01
By: Michel Cadot
  Same SQL work differently in different SQL Plus
Oracle 11g
By: jayakumar.u05 on Fri, 18 December 2015
10 515 Fri, 18 December 2015 16:03
By: BlackSwan
  dynamic Column header using Pivot operator
Oracle12c
By: ajamitjain129@gmail.com on Thu, 17 December 2015
3 456 Fri, 18 December 2015 05:20
By: ajamitjain129@gmail.com
  Converting Excel to csv using PL/SQL
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: venkat_bollu on Thu, 17 December 2015
4 528 Fri, 18 December 2015 02:03
By: venkat_bollu
  Staff Lft Company and display his pervisos recoreds
By: skorpion on Thu, 17 December 2015
1 296 Thu, 17 December 2015 08:01
By: BlackSwan
  A trigger to give a 10 per cent discount to a regular customer
By: ora1992 on Thu, 17 December 2015
4 344 Thu, 17 December 2015 06:37
By: JNagtzaam
  Date Conersion From UTC to EST
Oracle10g
By: ssyr22 on Thu, 17 December 2015
8 433 Thu, 17 December 2015 06:26
By: EdStevens
  Date conversion
By: blyzz on Wed, 16 December 2015
2 410 Wed, 16 December 2015 10:00
By: Solomon Yakobson
  PL SQL Code with variable
Oracle 10 G
By: mashrima on Wed, 16 December 2015
13 1189 Wed, 16 December 2015 09:26
By: flyboy
  Define/declare dates and use in CTE
SQL Developer 4.1.2
By: To-Dai on Mon, 14 December 2015
30 967 Wed, 16 December 2015 06:22
By: EdStevens
  Help any one with a code please
oracle 12c ( 1 2)
By: vs140580 on Mon, 14 December 2015
47 1347 Wed, 16 December 2015 02:28
By: vs140580
  how to remove more than one value
Oracle10g
By: ssyr22 on Mon, 14 December 2015
12 661 Tue, 15 December 2015 03:36
By: JNagtzaam
  Materialised view won't refresh
Oracle 10.2.0.4.0
By: brown_zzz on Mon, 14 December 2015
7 536 Tue, 15 December 2015 03:32
By: cookiemonster
  How to Resolve error: ORA-00932
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: msol25 on Sun, 13 December 2015
10 728 Mon, 14 December 2015 05:40
By: msol25
  + 0 in the where clause
PL/SQL Release 12.1.0.2.0 - Production
By: msinha8 on Thu, 10 December 2015
8 885 Fri, 11 December 2015 01:25
By: Michel Cadot
  Join on TABLE OF NUMBER passed as a parameter to a function
Oracle 11G
By: Sam D. on Wed, 09 December 2015
11 742 Thu, 10 December 2015 13:15
By: Michel Cadot
  merging the column in SQL
PL/SQL Release 12.1.0.2.0 - Production
By: msinha8 on Thu, 05 November 2015
4 693 Thu, 10 December 2015 08:22
By: Michel Cadot
  Fiscal Year data counts
11.2
By: lott42 on Wed, 09 December 2015
2 464 Wed, 09 December 2015 12:11
By: lott42
  Getting Error inListagg
Oracle10g
By: ssyr22 on Mon, 07 December 2015
8 613 Wed, 09 December 2015 11:01
By: Michel Cadot
  Load data
11.2.0.3, 64-bit, Windows 2003
By: sant_new1 on Tue, 08 December 2015
6 516 Wed, 09 December 2015 08:54
By: sant_new1
  Comma separated values
Oracle10g
By: ssyr22 on Wed, 09 December 2015
4 466 Wed, 09 December 2015 06:38
By: EdStevens
  Find Out Odd Range
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: Xandot on Mon, 07 December 2015
9 608 Wed, 09 December 2015 06:26
By: Michel Cadot
  Help with insert
11.2.0.3, 64-bit, Windows 2003
By: sant_new1 on Tue, 08 December 2015
11 519 Tue, 08 December 2015 15:06
By: sant_new1
  Urgent : SQL Queries
SQL
By: akriti on Mon, 07 December 2015
1 454 Mon, 07 December 2015 23:39
By: Michel Cadot
  Cannot group third column (Querying)
By: fabi88 on Mon, 07 December 2015
3 380 Mon, 07 December 2015 13:45
By: John Watson
  Subqyery with group by / case when / having
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
By: Kruemel on Mon, 07 December 2015
8 540 Mon, 07 December 2015 09:43
By: Solomon Yakobson
  Compilation error in Function
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production, WINDOWS-7
By: mokarem on Mon, 07 December 2015
11 554 Mon, 07 December 2015 05:45
By: mokarem
  Oracle pair combination with two column values in a table
Oracle 11g
By: sunshine on Sat, 29 August 2015
15 1456 Sun, 06 December 2015 15:56
By: sunshine
  Regular Expression
Oracle 11G
By: samyms on Fri, 20 November 2015
8 887 Sun, 06 December 2015 10:22
By: samyms
  Distribute payments over due dates and amounts
11.2.1.0
By: OraFerro on Tue, 01 December 2015
5 610 Sat, 05 December 2015 21:56
By: OraFerro
  Data export to flat file (merged 3)
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0, Linix
By: raghx on Tue, 01 December 2015
6 631 Sat, 05 December 2015 07:23
By: Solomon Yakobson
  Query not processing by JDBC (Hanging on the executeQuery line)
Java, Mysql, SQL
By: deepak416 on Sat, 05 December 2015
3 402 Sat, 05 December 2015 06:22
By: Solomon Yakobson
  execute immediate results in an ORA-00936 error
Oracle Enterprise Edition, 11.2.0.3.4, Solaris 10
By: markhooper99 on Thu, 03 December 2015
13 897 Sat, 05 December 2015 06:12
By: pablolee
  Update multiple rows with multi join
oracle 12c
By: gorants on Fri, 04 December 2015
12 615 Fri, 04 December 2015 21:14
By: gorants
icon5.gif How to fill a column with given values?
By: quirks on Fri, 04 December 2015
3 457 Fri, 04 December 2015 07:04
By: Solomon Yakobson
  Grouping with sum and retain first row
oracle 11g
By: bamboo123 on Thu, 03 December 2015
2 353 Thu, 03 December 2015 14:06
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 26 10:23:23 CDT 2016

Total time taken to generate the page: 0.09851 seconds