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
  MAT view - Start with & Next
Oracle 12g
By: Oracle_Walker on Wed, 15 April 2015
9 693 Fri, 17 April 2015 01:12
By: Michel Cadot
  get data from two tables
By: ketangarg86 on Thu, 16 April 2015
2 297 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 500 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 531 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 668 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 356 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 519 Tue, 14 April 2015 06:43
By: EdStevens
  Grouping Query
Oracle 11g
By: sasisan09 on Thu, 09 April 2015
2 534 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 430 Mon, 13 April 2015 08:25
By: Bill B
  Query Help
Oracle 11g
By: sadasivam.samyappan on Sun, 12 April 2015
1 393 Sun, 12 April 2015 07:28
By: Michel Cadot
  plsql function/package
By: lexonsteel on Sat, 11 April 2015
2 532 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 687 Sat, 11 April 2015 00:31
By: Michel Cadot
  Conditional Insert statement in pl/sql
By: suji6281 on Thu, 09 April 2015
12 852 Fri, 10 April 2015 08:22
By: cookiemonster
  SQL
Oracle 11g
By: jen804 on Thu, 09 April 2015
2 452 Fri, 10 April 2015 02:50
By: cookiemonster
  help in writing query
oracle 11 g
By: simplesanju on Thu, 09 April 2015
2 378 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 563 Thu, 09 April 2015 04:24
By: saipavan.plsql
  saving query Output in a single variable
By: palpali on Thu, 09 April 2015
9 555 Thu, 09 April 2015 04:18
By: palpali
  Oracle Number length to SQL Numeric length
By: giszzmo on Tue, 07 April 2015
3 528 Wed, 08 April 2015 18:58
By: WayCal
icon2.gif need help for oracle sql
ORACLE
By: hivwood on Tue, 07 April 2015
12 711 Wed, 08 April 2015 04:54
By: Michel Cadot
  %rowtype error 06512
By: Nasir.azeem on Wed, 08 April 2015
5 382 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 448 Wed, 08 April 2015 01:36
By: Lalit Kumar B
  Unable to drop an Index
By: msinha8 on Tue, 07 April 2015
5 466 Tue, 07 April 2015 03:00
By: msinha8
  Package Initialization block for performance tuning
Oracle 11g
By: dhulia_padhi@yahoo.com on Sun, 05 April 2015
3 439 Mon, 06 April 2015 09:11
By: BlackSwan
  how to user regexp to put single quotes
oracle 11g
By: gentleman777us on Fri, 03 April 2015
3 470 Sat, 04 April 2015 01:17
By: Lalit Kumar B
  Need help in tablespace
Oracle 10g XE, Windows 7
By: dark_prince on Mon, 30 March 2015
29 1228 Fri, 03 April 2015 21:37
By: BlackSwan
  explicit and implicit cursor loop
By: sampathkore4444@gmail.com on Fri, 03 April 2015
2 351 Fri, 03 April 2015 10:39
By: Michel Cadot
  Child tables, grand child tables of a table
Oracle 11.2.0.3
By: pointers on Wed, 01 April 2015
2 437 Thu, 02 April 2015 02:28
By: pointers
  Best way to get count of unique months with activity
Oracle 11.2
By: statey603 on Wed, 01 April 2015
3 331 Wed, 01 April 2015 15:23
By: joy_division
  how to get unmatched record from emp and dept tables
oracle 10g
By: ursfriend77 on Sun, 29 March 2015
13 622 Wed, 01 April 2015 01:19
By: Michel Cadot
icon5.gif different results of sql query on different servers (with the same data)
see below
By: ecivgamer on Tue, 31 March 2015
3 349 Tue, 31 March 2015 14:42
By: EdStevens
  JSON parsing?
12c
By: JDOaktown on Mon, 30 March 2015
12 555 Tue, 31 March 2015 12:44
By: JDOaktown
  Select query is hitting the database multiple times
By: kiran_vangeti on Tue, 31 March 2015
6 380 Tue, 31 March 2015 05:43
By: Michel Cadot
  case
By: palpali on Mon, 30 March 2015
7 416 Tue, 31 March 2015 01:07
By: palpali
icon5.gif Split CLOB column to multiple columns within a row
Oracle 11g
By: as1986 on Thu, 19 February 2015
23 1491 Mon, 30 March 2015 23:43
By: as1986
  sql 9I ,10G ,11GDIFFERENCE SQL LEVEL
9I,10G,11G
By: duttatarun on Mon, 30 March 2015
7 468 Mon, 30 March 2015 05:25
By: Michel Cadot
  Query regarding Outer Join
Oracle 11g , Windows 7
By: rakeshramm on Wed, 25 March 2015
9 687 Sat, 28 March 2015 10:29
By: Kevin Meade
  SQL query (merged 3)
By: sunny1234 on Thu, 26 March 2015
13 720 Fri, 27 March 2015 06:21
By: Solomon Yakobson
  Converting Prompt syntax into regular sql
Oracle IDE 4.0
By: haryshenoy on Thu, 26 March 2015
1 293 Thu, 26 March 2015 12:18
By: Michel Cadot
  insert statement w/o having unique constraint error
By: suji6281 on Thu, 26 March 2015
3 407 Thu, 26 March 2015 12:16
By: Michel Cadot
  pl sql error
oracle 11g,windows 7
By: hcdba on Thu, 26 March 2015
10 563 Thu, 26 March 2015 10:48
By: Solomon Yakobson
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: Wed Sep 02 22:26:35 CDT 2015

Total time taken to generate the page: 0.18764 seconds