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
  Text based search
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: manubatham20 on Fri, 02 January 2015
14 5504 Sat, 03 January 2015 13:18
By: manubatham20
  Check Time In Query
Oralce 10g
By: mamalik on Fri, 02 January 2015
13 8006 Sat, 03 January 2015 09:45
By: Kevin Meade
  Dynamic monthly sales report
By: ocpsujon on Sun, 28 December 2014
4 5674 Thu, 01 January 2015 13:53
By: Kevin Meade
  filling summary table from detail and updating the detail with summary reference
11.2.0.1.0
By: OraFerro on Mon, 29 December 2014
3 4784 Thu, 01 January 2015 13:18
By: Kevin Meade
  SQL*Net message from db link Doubt
Oracle 11gR2
By: tigsav on Wed, 31 December 2014
3 3880 Wed, 31 December 2014 08:08
By: Michel Cadot
  How to define Package Name in Reports Builder / REP-0069
Reports Builder
By: isteri143 on Mon, 29 December 2014
11 8897 Wed, 31 December 2014 00:42
By: Littlefoot
  deadlock detected while waiting for resource
11g
By: cplusplus1 on Mon, 29 December 2014
4 4405 Tue, 30 December 2014 11:00
By: Michel Cadot
  Update multiple rows based on duplication
11.2.0.1.0
By: OraFerro on Mon, 29 December 2014
6 4714 Tue, 30 December 2014 08:20
By: Lalit Kumar B
  How to select distinct sql_id together with clob column
11.2.0.3
By: kytemanaic on Mon, 29 December 2014
3 5882 Tue, 30 December 2014 01:18
By: Michel Cadot
  Syntax for creating oracle type
Oracle 11g
By: Oracle_Walker on Mon, 29 December 2014
1 2270 Mon, 29 December 2014 17:03
By: BlackSwan
  Problem with nested FOR Loop
Oracle 11.2.0.3.0 - Sun Solaris unix
By: welchaz on Mon, 29 December 2014
3 3039 Mon, 29 December 2014 15:25
By: welchaz
  How to get list of top 15 sql order by by buffer gets
11.2.0.3
By: kytemanaic on Mon, 29 December 2014
3 3338 Mon, 29 December 2014 08:49
By: BlackSwan
  LONG to VARCHAR2 conversion using dblink
Oracle Enterprise Edition : 10.2.0.5.0 - 64bit,HPUX: Version 10.2.0.5.0
By: jois on Tue, 23 December 2014
12 20529 Mon, 29 December 2014 06:04
By: jois
  SQL query to calculate distance and update
Oracle 11.2.0.3
By: pointers on Tue, 23 December 2014
6 6305 Mon, 29 December 2014 04:10
By: pointers
  How to display a record from an array(nested table)
O/S:Windows 7 PRO; Product: Oracle; version: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: buggleboy007 on Sun, 28 December 2014
6 3954 Sun, 28 December 2014 17:16
By: buggleboy007
  When NOLOGGING will not be in effect
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: manubatham20 on Fri, 26 December 2014
12 7588 Sat, 27 December 2014 10:20
By: Solomon Yakobson
  ORA-01722: invalid number
Oracle 11g
By: Oracle_Walker on Wed, 24 December 2014
5 6586 Fri, 26 December 2014 13:37
By: Oracle_Walker
  Error in pl/sql Bubble sort code
By: jahanzaibniazi001 on Thu, 25 December 2014
3 5600 Fri, 26 December 2014 00:30
By: Michel Cadot
  Divide in Groups
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: manubatham20 on Wed, 24 December 2014
16 6379 Thu, 25 December 2014 12:51
By: manubatham20
  Comparing two TimeStamp columns giving unexpected result
Oracle 11G
By: Asfakul on Wed, 24 December 2014
5 6483 Thu, 25 December 2014 11:15
By: Michel Cadot
  PLS-00103: Encountered the symbol "END" when expecting one of
Oracle Database 11g XE 11.2.0.2.0 PL/SQL Release 11.2.0.2.0 OS WIN 7
By: weather3 on Wed, 24 December 2014
12 22111 Thu, 25 December 2014 05:27
By: Michel Cadot
  ASCII in oracle 11g
By: swati.pale on Mon, 22 December 2014
5 7390 Wed, 24 December 2014 10:42
By: andrew again
  Complicate Query
Oracle SQL
By: raajes_n on Tue, 23 December 2014
13 6915 Wed, 24 December 2014 07:18
By: Michel Cadot
  How to write stored function to return column name?
By: mist598 on Wed, 24 December 2014
6 5315 Wed, 24 December 2014 05:14
By: Michel Cadot
  source does not have runnable target
sql developer, oracle 11g
By: zenthil86 on Tue, 23 December 2014
4 5404 Wed, 24 December 2014 01:38
By: Michel Cadot
  sql query for employees based on Org hierarchy
R12.1.3, 11g
By: afzaa2yahoocom on Tue, 23 December 2014
1 4949 Wed, 24 December 2014 01:36
By: Michel Cadot
  Dynamic PL/SQL which reads table and transposes rows to columns
oracle 11g R2, windows
By: zulu69 on Tue, 23 December 2014
3 5949 Wed, 24 December 2014 01:35
By: Michel Cadot
  Re:- how to check column value in particular format
windows7
By: ajamitjain129@gmail.com on Mon, 22 December 2014
4 4693 Tue, 23 December 2014 02:50
By: ajamitjain129@gmail.com
  Procedure to traverse the table based on fk constraints
oracle 11g sql developer
By: zenthil86 on Sat, 20 December 2014
12 7567 Mon, 22 December 2014 13:22
By: BlackSwan
  A question about using nested decode
Oracle 11.2.0.4 on Linux
By: orausern on Mon, 22 December 2014
5 3454 Mon, 22 December 2014 12:39
By: orausern
  How to Delete Parent table record
Oracle 10g,11g
By: amitsukte on Tue, 10 July 2012
9 11477 Mon, 22 December 2014 02:51
By: Michel Cadot
  Use of set in Oracle
Oracle 10g
By: sss111ind on Sat, 20 December 2014
8 6534 Mon, 22 December 2014 00:30
By: sss111ind
  SQL Query
Oracle 10g,Win 7
By: Xandot on Wed, 10 December 2014
3 4993 Sun, 21 December 2014 02:24
By: tamzidulamin
  Connect by Prior parent-child into string of values
10.2
By: lott42_gmail on Fri, 07 February 2014
16 8298 Sun, 21 December 2014 01:32
By: Michel Cadot
  generic queries
11.2.0.3
By: Amine on Fri, 19 December 2014
7 5721 Sat, 20 December 2014 14:27
By: Michel Cadot
icon5.gif DatatypeConverter
Database 11.2
By: ziad-al on Sat, 20 December 2014
9 7610 Sat, 20 December 2014 11:46
By: ziad-al
  Open cursor for select, based on another cursor
11.2.0.1.0
By: OraFerro on Thu, 18 December 2014
12 8411 Sat, 20 December 2014 07:39
By: Michel Cadot
  I tried , adn tried, and tried, and for that reason, I'm notgoint to give up...
windows 7, oracle 11g toad
By: xebec on Fri, 19 December 2014
11 9660 Sat, 20 December 2014 00:52
By: Michel Cadot
  How to fetch a single record in an array/nested table
O/S:Windows 7 PRO; Product: Oracle; version: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: buggleboy007 on Thu, 18 December 2014
37 13783 Thu, 18 December 2014 15:34
By: buggleboy007
  utl_request ORA-29049 error when request salesforce.com
By: junkai.niu on Thu, 18 December 2014
1 6622 Thu, 18 December 2014 09:55
By: BlackSwan
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: Sat Aug 08 23:25:48 CDT 2026