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
  Announcement: How to use [code] tags and make your code easier to read?
Other people will appreciate it
By: Littlefoot on Mon, 05 September 2011
0 46470 Mon, 05 September 2011 02:20
By: Littlefoot
  SQL Query
10g/11g
By: ashish_sun123 on Tue, 14 April 2015
10 318 Mon, 27 April 2015 00:16
By: Michel Cadot
  Reading the Highvalue of partition and performing dynamic operation
Oracle 11g
By: srinivas.k2005 on Sat, 25 April 2015
1 136 Sat, 25 April 2015 17:12
By: srinivas.k2005
  How do I pass a table name dynamically using execute immediate
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, 23 April 2015
17 671 Fri, 24 April 2015 12:34
By: EdStevens
  inner query use outer query
oracle 11g
By: miroconnect@yahoo.com on Wed, 22 April 2015
4 552 Fri, 24 April 2015 01:34
By: Lalit Kumar B
  complex view query with multiple lookups
By: natrajdreams on Wed, 22 April 2015
14 512 Wed, 22 April 2015 09:17
By: cookiemonster
  SQL query for count
By: asbh123 on Thu, 20 November 2014
20 1184 Wed, 22 April 2015 03:12
By: cookiemonster
  UTL File reader
Oracle,10G,Windows 7
By: gsaravanan on Mon, 20 April 2015
14 490 Tue, 21 April 2015 14:39
By: Barbara Boehmer
  Hierarchical queries with aggregation
11.2.0.3
By: grpatwari on Tue, 21 April 2015
3 303 Tue, 21 April 2015 08:02
By: grpatwari
  Convert date to weeks in the month and days
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.8.0 - Production Oracle ORACLE PL/SQL V10.1.0.4.2 - Pr
By: anumoses58 on Mon, 20 April 2015
36 443 Mon, 20 April 2015 14:16
By: EdStevens
  External Tables
Linux 5.5, Oracle 10g, Windows xp
By: ORA2015 on Wed, 25 March 2015
25 956 Mon, 20 April 2015 13:07
By: ORA2015
  Date functions
By: thiruvari on Mon, 20 April 2015
10 281 Mon, 20 April 2015 12:40
By: thiruvari
  Max on Sum
By: zoe2003 on Mon, 20 April 2015
2 217 Mon, 20 April 2015 08:20
By: Lalit Kumar B
  DBMS_CRYPTO
11g database
By: vippysharma on Mon, 20 April 2015
5 330 Mon, 20 April 2015 06:32
By: vippysharma
  Same Query taking significantly different time on different days
Oracle 11g
By: saurabh.sha on Wed, 15 April 2015
3 351 Sun, 19 April 2015 13:09
By: Kevin Meade
  how to decide when to go for local vs global partitioned index on a table
Oracle 11g
By: rishuk on Tue, 14 April 2015
7 537 Sun, 19 April 2015 13:01
By: Kevin Meade
  multilagual charactor
10g,11g
By: dsatya10 on Sun, 19 April 2015
14 448 Sun, 19 April 2015 12:56
By: Michel Cadot
  SQL query help
oracle 11g
By: gorants on Sat, 18 April 2015
2 226 Sat, 18 April 2015 12:20
By: Barbara Boehmer
  MAT view - Start with & Next
Oracle 12g
By: Oracle_Walker on Wed, 15 April 2015
9 558 Fri, 17 April 2015 01:12
By: Michel Cadot
  get data from two tables
By: ketangarg86 on Thu, 16 April 2015
2 189 Thu, 16 April 2015 14:54
By: Michel Cadot
  Need to know about some basic for explain plan
Oracle, Oracle Database 11g Express Edition Release 11.2.0.2.0 ,Win 7 Pro
By: shumail on Wed, 15 April 2015
6 368 Thu, 16 April 2015 07:01
By: mnitu
  Procedure altered with compilation errors
11.2.0.4
By: krish96 on Tue, 14 April 2015
6 393 Wed, 15 April 2015 13:30
By: Bill B
  SQL/PLSQL
HOW TO USE MIN FUNCTION USED IN WHERE CONDITION
By: ifti6650 on Sun, 12 April 2015
6 551 Wed, 15 April 2015 05:21
By: Lalit Kumar B
  Connect by Level Clarification Required
Oracle 11gr2
By: ind9 on Tue, 14 April 2015
2 217 Tue, 14 April 2015 08:31
By: Solomon Yakobson
  how to find out AM PM from date column
oracle 10g
By: jgjeetu on Tue, 14 April 2015
9 358 Tue, 14 April 2015 06:43
By: EdStevens
  Grouping Query
Oracle 11g
By: sasisan09 on Thu, 09 April 2015
2 413 Mon, 13 April 2015 09:10
By: LKBrwn_DBA
icon12.gif Update Time Zone
Oracle Database 12c, 12.1.0.2, Oracle Linux 6.5 64-bit
By: askuncoro on Thu, 09 April 2015
3 287 Mon, 13 April 2015 08:25
By: Bill B
  Query Help
Oracle 11g
By: sadasivam.samyappan on Sun, 12 April 2015
1 297 Sun, 12 April 2015 07:28
By: Michel Cadot
  plsql function/package
By: lexonsteel on Sat, 11 April 2015
2 415 Sat, 11 April 2015 08:10
By: John Watson
  MultiByte Chars in a Column
11.2.0.4.0
By: Yuvraaj on Thu, 09 April 2015
5 579 Sat, 11 April 2015 00:31
By: Michel Cadot
  Conditional Insert statement in pl/sql
By: suji6281 on Thu, 09 April 2015
12 637 Fri, 10 April 2015 08:22
By: cookiemonster
  SQL
Oracle 11g
By: jen804 on Thu, 09 April 2015
2 360 Fri, 10 April 2015 02:50
By: cookiemonster
  help in writing query
oracle 11 g
By: simplesanju on Thu, 09 April 2015
2 283 Thu, 09 April 2015 07:43
By: Michel Cadot
  Materialized is getting invalid after refresh
Oracle Database 11g Release 11.2.0.3.0
By: saipavan.plsql on Wed, 08 April 2015
4 450 Thu, 09 April 2015 04:24
By: saipavan.plsql
  saving query Output in a single variable
By: palpali on Thu, 09 April 2015
9 460 Thu, 09 April 2015 04:18
By: palpali
  Oracle Number length to SQL Numeric length
By: giszzmo on Tue, 07 April 2015
3 397 Wed, 08 April 2015 18:58
By: WayCal
icon5.gif Asp.Net Application hangs until oracle package is recompiled
Oracle Database 11g Release 11.2.0.1.0 64bit CentOS 6.5
By: praveenpraj on Tue, 27 January 2015
7 670 Wed, 08 April 2015 09:50
By: Lalit Kumar B
icon2.gif need help for oracle sql
ORACLE
By: hivwood on Tue, 07 April 2015
12 576 Wed, 08 April 2015 04:54
By: Michel Cadot
  %rowtype error 06512
By: Nasir.azeem on Wed, 08 April 2015
5 279 Wed, 08 April 2015 02:27
By: Nasir.azeem
  how to retreive the second word using substring
By: Info_dev on Tue, 07 April 2015
3 353 Wed, 08 April 2015 01:36
By: Lalit Kumar B
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: Mon Apr 27 00:42:52 CDT 2015

Total time taken to generate the page: 0.09872 seconds