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
  single query by which data can fetched from table which name generated from a query
oracle 10 g
By: evivekj on Thu, 29 May 2014
13 1146 Fri, 06 June 2014 09:47
By: Michel Cadot
  Cannot access table in PL/SQL even with direct grant
11.2.0.2 Enterprise, RHL
By: d_seng on Fri, 06 June 2014
4 321 Fri, 06 June 2014 06:42
By: EdStevens
  how to use substr while assigning the column & using length function
By: mist598 on Fri, 06 June 2014
4 315 Fri, 06 June 2014 04:04
By: mist598
  column header needs to add for each record
Oracle 11g, Linux
By: rahul1982 on Thu, 05 June 2014
5 429 Fri, 06 June 2014 03:46
By: rahul1982
  SQL QUERY
ORACLE 11G
By: IRFANMBAIG on Sat, 31 May 2014
2 756 Thu, 05 June 2014 15:02
By: vemulapalli.satish83
  Left outer Join nt working as desired
Oracle 11g
By: raj_te on Thu, 05 June 2014
6 431 Thu, 05 June 2014 13:45
By: cookiemonster
  Insert with different key values to avoid contraint violation
Oracle 9i
By: lukeskw on Thu, 05 June 2014
8 447 Thu, 05 June 2014 13:36
By: BlackSwan
  Table count with rows and no rows
Oracle 10.2.0.2.0 , windows
By: Jack14 on Wed, 04 June 2014
14 619 Thu, 05 June 2014 05:53
By: Jack14
  Create Sql Query
Oracle 11g,Win7 23 bit
By: Xandot on Thu, 05 June 2014
8 444 Thu, 05 June 2014 04:19
By: Xandot
  How to insert value in a partition table if the partition is not defined.
By: jgjeetu on Thu, 05 June 2014
3 323 Thu, 05 June 2014 00:51
By: jgjeetu
  MySQL to oracle
MySQL 5.1 on centos and oracle 10g on rhel 5.4
By: tejeshrao on Tue, 27 May 2014
26 907 Wed, 04 June 2014 15:43
By: Bill B
  Filter by Count of particular field
By: rlsublime on Mon, 02 June 2014
18 673 Wed, 04 June 2014 12:17
By: Lalit Kumar B
  how to user REGEXP for inserting data from one table to another table
oracle 10g
By: jgjeetu on Wed, 04 June 2014
5 470 Wed, 04 June 2014 01:45
By: Littlefoot
  Invalid Synonym in SQL Plus Vs Toad
Oracle 11g Release 2
By: azeem87 on Tue, 03 June 2014
6 477 Tue, 03 June 2014 13:20
By: Lalit Kumar B
  how to display only char data only or numeric data only not both
By: mist598 on Mon, 02 June 2014
10 770 Tue, 03 June 2014 01:28
By: mist598
  How to partition Table Data Alphabetically
By: jgjeetu on Sat, 31 May 2014
12 712 Sun, 01 June 2014 15:01
By: EdStevens
  about excute procedure
By: man silence on Fri, 30 May 2014
3 365 Fri, 30 May 2014 15:09
By: man silence
  Replace all substrings by another strings
Ora 11g
By: slaguila on Thu, 29 May 2014
9 687 Fri, 30 May 2014 08:49
By: Solomon Yakobson
  how to write an excel in PLSQL
By: evivekj on Thu, 29 May 2014
17 902 Fri, 30 May 2014 08:24
By: cookiemonster
  How to add partition by list clause on existing empty table
oracle 10g
By: jgjeetu on Fri, 30 May 2014
4 1414 Fri, 30 May 2014 06:54
By: jgjeetu
  Spliting string more than 32767 characters
Oracle 10g
By: sss111ind on Thu, 29 May 2014
3 362 Fri, 30 May 2014 02:35
By: Michel Cadot
  Using SQL in pass through query in Access to Oracle
Windows 7, Oracle 11.0.0.116
By: ipisors on Wed, 28 May 2014
5 415 Thu, 29 May 2014 15:18
By: ipisors
  Need Design input to execute store proc
ORACLE 11g
By: gorants on Wed, 28 May 2014
6 437 Thu, 29 May 2014 13:50
By: Michel Cadot
  Delete getting stuck
11g Release 2
By: azeem87 on Mon, 05 May 2014
37 1449 Thu, 29 May 2014 12:44
By: BlackSwan
  Need help in this SQL logic
Oracle 11g
By: vishalshinde.2004 on Thu, 29 May 2014
6 432 Thu, 29 May 2014 06:51
By: Solomon Yakobson
  Adding column to existing index
Oracle 11
By: brown_zzz on Thu, 29 May 2014
1 225 Thu, 29 May 2014 06:44
By: Lalit Kumar B
  View on synonym
oracle 10.2.0.4 - Windows server 2003
By: muktha_22 on Thu, 29 May 2014
7 423 Thu, 29 May 2014 06:08
By: Lalit Kumar B
  multiple values in a single column should be populated as multiple rows
oracle 11g
By: vkanuri on Wed, 28 May 2014
1 321 Wed, 28 May 2014 14:14
By: Michel Cadot
icon5.gif re-raising the exception.
oracle 11g , Hp UNIX
By: live4learn on Tue, 27 May 2014
9 492 Wed, 28 May 2014 09:57
By: Lalit Kumar B
  ORA-03113: end-of-file on communication channel
By: sibashishnayak on Wed, 28 May 2014
1 312 Wed, 28 May 2014 03:18
By: Michel Cadot
  How to find Table ,column name based on value in schema.
ORACLE 11g
By: gorants on Tue, 27 May 2014
5 403 Wed, 28 May 2014 00:50
By: deepakmannazhi
  use of SQL Hints "RESULT CACHE"
Oracle 11g R2, Windows 7
By: mokarem on Tue, 27 May 2014
1 277 Wed, 28 May 2014 00:27
By: Lalit Kumar B
  How to find Sequences associated to a table
ORACLE 11g
By: gorants on Tue, 27 May 2014
10 479 Tue, 27 May 2014 14:55
By: EdStevens
  Insert into Partition Tables After Column Addition
Oracle 11g Release 2
By: azeem87 on Tue, 27 May 2014
7 409 Tue, 27 May 2014 13:22
By: Solomon Yakobson
  Generate Sequence and then find missing Sequence no
Oracle 10.2.0.1
By: bluetooth420 on Tue, 27 May 2014
9 409 Tue, 27 May 2014 08:14
By: Michel Cadot
  Read Binary Format File
11g
By: tabj on Tue, 27 May 2014
2 217 Tue, 27 May 2014 07:53
By: Michel Cadot
  no output shown
By: mist598 on Tue, 27 May 2014
4 294 Tue, 27 May 2014 02:52
By: Lalit Kumar B
  ORA-8177 when execute procedure from forms10g
Linux 6.4, oracle 11.2.0.3 , patch 14666138 , forms 10g
By: RAY_HT on Sun, 25 May 2014
6 436 Tue, 27 May 2014 00:09
By: Littlefoot
  SQL or PL/SQL query to sum and avg time stamps
ORACLE 11g
By: gorants on Mon, 26 May 2014
9 494 Mon, 26 May 2014 14:30
By: Michel Cadot
  how to send email when the status of the object gets invalid?
11g
By: kiranrathodkr916 on Mon, 26 May 2014
3 313 Mon, 26 May 2014 13:30
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 Dec 20 20:14:55 CST 2014

Total time taken to generate the page: 0.09519 seconds