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 40630 Mon, 05 September 2011 02:20
By: Littlefoot
  How to upload images into Oracle Table
Window7
By: Nasir.azeem on Tue, 30 September 2014
1 62 Tue, 30 September 2014 06:07
By: Michel Cadot
  How to Find Duplicate Groups (group of records) in Oracle
Oracle 11g
By: dhakanes@gmail.com on Fri, 26 September 2014
17 635 Tue, 30 September 2014 04:25
By: dhakanes@gmail.com
  group by to_char resulting in Exception: ORA-00979: not a GROUP BY expression
OEM 12C
By: vjeedigunta on Mon, 29 September 2014
4 148 Tue, 30 September 2014 02:22
By: Lalit Kumar B
  ORA-12704: character set mismatch
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit, MS WINDOWS Server 2008
By: shahrir83 on Tue, 30 September 2014
1 81 Tue, 30 September 2014 02:20
By: Michel Cadot
Timestamp Problem has been moved to Client Tools by the moderator.
  distribute grp_cd equally among the data
By: rkhatiwala on Fri, 26 September 2014
3 219 Mon, 29 September 2014 22:49
By: Lalit Kumar B
  Help WIth Fixing Errors In SQL Script
SQL Plus
By: Mckenzo101 on Sat, 27 September 2014
6 324 Mon, 29 September 2014 13:18
By: Bill B
  Regexp Replace - Replacement Problem
By: wintech on Sun, 28 September 2014
2 138 Sun, 28 September 2014 13:51
By: wintech
  Error with multi-dimenssional array.
By: amit.sonar on Thu, 25 September 2014
3 184 Sun, 28 September 2014 13:31
By: amit.sonar
  PLS-00306: wrong number or types of arguments in call to 'PR_4552'
Oralce 11g
By: na.dharma@gmail.com on Wed, 30 April 2014
11 521 Sat, 27 September 2014 13:39
By: pablolee
  Package of Analyze Partitions
Oracle 11R2
By: loupstr on Thu, 25 September 2014
6 256 Fri, 26 September 2014 16:12
By: CraigB
  Question about v$version
Oracle 10,11
By: lott42 on Fri, 26 September 2014
6 211 Fri, 26 September 2014 15:30
By: lott42
  stored procedure
oracle 10g
By: simplesanju on Fri, 26 September 2014
2 170 Fri, 26 September 2014 06:08
By: simplesanju
  Please tell me use of DBMS_SCHEDULER
By: aaditya321 on Tue, 23 September 2014
39 683 Fri, 26 September 2014 02:16
By: aaditya321
  Add # of days and then pass it as a variable
Oracle 11g release 2
By: azeem87 on Thu, 25 September 2014
5 188 Thu, 25 September 2014 14:56
By: azeem87
  order by query in sql
11g
By: haadiya on Thu, 25 September 2014
16 369 Thu, 25 September 2014 14:55
By: Bill B
  Unique constraint error
Oracle 11.2.0.2 G
By: aishvarya.singh on Thu, 25 September 2014
7 189 Thu, 25 September 2014 10:41
By: flyboy
  FOR UPDATE clause
ERP
By: chat2raj.s on Thu, 25 September 2014
4 189 Thu, 25 September 2014 10:41
By: sandeep_orafaq
  Need Sql query
By: mvrkr44 on Thu, 25 September 2014
9 249 Thu, 25 September 2014 05:58
By: pablolee
  Help on a query
By: lovelysethii@gmail.com on Wed, 24 September 2014
8 340 Thu, 25 September 2014 04:39
By: lovelysethii@gmail.com
  ORDER BY 'constant' oracle partition
By: kiwinz on Thu, 25 September 2014
7 225 Thu, 25 September 2014 02:31
By: pablolee
  Row generator
Oracle 10.2
By: m.abdulhaq on Wed, 24 September 2014
10 303 Thu, 25 September 2014 01:17
By: m.abdulhaq
  Questing regarding level and connect by
Oracle 10g
By: akull on Tue, 23 September 2014
9 694 Thu, 25 September 2014 00:31
By: jgjeetu
  Outer Join on Values
By: mayur.shinde511@gmail.com on Tue, 23 September 2014
7 268 Thu, 25 September 2014 00:23
By: Michel Cadot
  CASE STATEMENT IN DDL
Oracle 11g
By: kiwinz on Tue, 23 September 2014
7 305 Thu, 25 September 2014 00:21
By: Michel Cadot
  User Login Query for Specific Month
Oracle Database 11.2.0.3.0 IBM AIX 6.1
By: wtolentino on Wed, 24 September 2014
20 331 Wed, 24 September 2014 14:02
By: Michel Cadot
  DECODE not working the way expected
Oracle 10g
By: chof on Tue, 23 September 2014
9 300 Wed, 24 September 2014 10:13
By: chof
  Need Materialised view
By: mvrkr44 on Wed, 24 September 2014
2 195 Wed, 24 September 2014 06:54
By: Lalit Kumar B
  how can i secure some row from my table
oracle database 10g, windows 7
By: x-oracle on Wed, 24 September 2014
9 222 Wed, 24 September 2014 05:05
By: Michel Cadot
  minus operator question
By: ora1980 on Tue, 23 September 2014
8 549 Tue, 23 September 2014 14:54
By: Michel Cadot
  BACKUP PACKAGES
By: hahaie on Tue, 23 September 2014
3 327 Tue, 23 September 2014 14:29
By: BlackSwan
  Alternate of UNION ALL
Oracle 10G , Windows 7
By: adilsami on Tue, 23 September 2014
18 381 Tue, 23 September 2014 12:47
By: Michel Cadot
  which column to have index
Linux, Oracle 11.2.0.2.0
By: rahul1982 on Mon, 22 September 2014
7 307 Tue, 23 September 2014 08:57
By: Lalit Kumar B
  Query to find duplicate rows from table
By: gaganmadhu on Tue, 23 September 2014
6 247 Tue, 23 September 2014 08:42
By: Michel Cadot
  what is the issue in my query
Toad 10.6.1
By: lvrvln on Sun, 21 September 2014
6 276 Tue, 23 September 2014 06:44
By: Lalit Kumar B
  Data in AM/PM
By: kr1347 on Mon, 22 September 2014
4 215 Mon, 22 September 2014 14:42
By: Michel Cadot
  Merge data to a table based on criteria
Oracle 11
By: Member2014 on Thu, 18 September 2014
12 451 Mon, 22 September 2014 13:49
By: Lalit Kumar B
  Please solve my issue
By: aaditya321 on Sat, 20 September 2014
19 2386 Mon, 22 September 2014 13:06
By: Solomon Yakobson
  mutating trigger
oracle 11g r2
By: guddu_12 on Mon, 22 September 2014
6 472 Mon, 22 September 2014 11:53
By: John Watson
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: Tue Sep 30 07:57:41 CDT 2014

Total time taken to generate the page: 0.21599 seconds