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
  how to use substr while assigning the column & using length function
By: mist598 on Fri, 06 June 2014
4 227 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 341 Fri, 06 June 2014 03:46
By: rahul1982
  SQL QUERY
ORACLE 11G
By: IRFANMBAIG on Sat, 31 May 2014
2 650 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 335 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 344 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 488 Thu, 05 June 2014 05:53
By: Jack14
  Create Sql Query
Oracle 11g,Win7 23 bit
By: Xandot on Thu, 05 June 2014
8 369 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 269 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 760 Wed, 04 June 2014 15:43
By: Bill B
  Filter by Count of particular field
By: rlsublime on Mon, 02 June 2014
18 547 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 337 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 340 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 640 Tue, 03 June 2014 01:28
By: mist598
  How to partition Table Data Alphabetically
By: jgjeetu on Sat, 31 May 2014
12 577 Sun, 01 June 2014 15:01
By: EdStevens
  about excute procedure
By: man silence on Fri, 30 May 2014
3 251 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 577 Fri, 30 May 2014 08:49
By: Solomon Yakobson
  how to write an excel in PLSQL
By: evivekj on Thu, 29 May 2014
17 729 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 1340 Fri, 30 May 2014 06:54
By: jgjeetu
  Spliting string more than 32767 characters
Oracle 10g
By: sss111ind on Thu, 29 May 2014
3 255 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 315 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 359 Thu, 29 May 2014 13:50
By: Michel Cadot
  Delete getting stuck
11g Release 2
By: azeem87 on Mon, 05 May 2014
37 1229 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 341 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 149 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 273 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 255 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 400 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 205 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 314 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 215 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 353 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 266 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 352 Tue, 27 May 2014 08:14
By: Michel Cadot
  Read Binary Format File
11g
By: tabj on Tue, 27 May 2014
2 159 Tue, 27 May 2014 07:53
By: Michel Cadot
  no output shown
By: mist598 on Tue, 27 May 2014
4 224 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 330 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 334 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 244 Mon, 26 May 2014 13:30
By: BlackSwan
  Delimited by '\' in oracle external table
By: arvindvegad on Fri, 23 May 2014
19 815 Sun, 25 May 2014 12:02
By: Michel Cadot
  Help me to write query
Oacle 11g Version 11.2.0.3.0
By: ukumarjsr2 on Fri, 23 May 2014
4 338 Sun, 25 May 2014 10:03
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: Fri Aug 22 05:29:16 CDT 2014

Total time taken to generate the page: 0.07249 seconds