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
  Counting overlapping ID's in intersection tables.
Oracle, 12.1.0.1, AIX 7.1
By: posefant on Wed, 20 April 2016
25 936 Thu, 21 April 2016 06:00
By: posefant
  Date Functions
Oracle 10g
By: Danny Freeman on Tue, 05 April 2016
4 552 Wed, 20 April 2016 15:58
By: Bill B
  Group By clause in inline view
Oracle Database 10g, Toad 9.7, Windows 7
By: lancer26 on Mon, 18 April 2016
6 572 Wed, 20 April 2016 13:44
By: live4learn
  Ids of unique error type
Oracle 11.2.0.3
By: pointers on Tue, 19 April 2016
7 448 Wed, 20 April 2016 07:11
By: pointers
  need to modify the column datatype from varchar to number
By: saipavan.plsql on Wed, 06 April 2016
3 451 Tue, 19 April 2016 13:23
By: Bill B
  TO_DATE formating
Oracle 11.2.0.3
By: pointers on Tue, 19 April 2016
5 372 Tue, 19 April 2016 08:34
By: cookiemonster
  query to right outer join and sum up
Oracle 11.2.0.3
By: pointers on Tue, 19 April 2016
5 277 Tue, 19 April 2016 07:00
By: pointers
  Bulk collect data problem
Oracle 10g
By: cjcsegers on Fri, 15 April 2016
5 492 Mon, 18 April 2016 12:52
By: Bill B
  random numbers
Oracle 11.2.0.3
By: pointers on Fri, 15 April 2016
5 662 Sat, 16 April 2016 13:41
By: Michel Cadot
  sort problem with decimal
10g, win 8.1
By: rzkhan on Wed, 13 April 2016
6 551 Fri, 15 April 2016 00:25
By: rzkhan
  Create a trigger to call a procedure
Oracle Database 11.2.0.3
By: Nagesh1985 on Wed, 13 April 2016
4 469 Thu, 14 April 2016 08:29
By: Bill B
  Data count for Likert Scale
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0
By: Duane on Tue, 12 April 2016
9 477 Wed, 13 April 2016 10:47
By: Michel Cadot
  Need help to build dynamic query
Oracle 11G
By: irish on Wed, 13 April 2016
1 318 Wed, 13 April 2016 03:37
By: cookiemonster
  Stored Procedure: XML versus Array for multi-table insert
11.0.2.10
By: OraFerro on Thu, 07 April 2016
7 550 Wed, 13 April 2016 03:12
By: OraFerro
  Summation on Character Variables
Oracle 10g
By: chat2raj.s on Wed, 06 April 2016
8 627 Wed, 13 April 2016 00:21
By: chat2raj.s
  How to create Dependency in MV
Oracle 11G
By: irish on Mon, 04 April 2016
12 747 Tue, 12 April 2016 06:13
By: gajini
  Update in EXECUTE IMMEDIATE
Oracle 11G
By: RaShi.Raj on Mon, 11 April 2016
13 395 Mon, 11 April 2016 09:30
By: cookiemonster
  difference between "child rows" and "siblings rows "
11g
By: sivaparam on Sat, 09 April 2016
2 404 Sat, 09 April 2016 14:58
By: Barbara Boehmer
  XMLAGG issue
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: Xandot on Wed, 06 April 2016
3 356 Wed, 06 April 2016 19:25
By: Solomon Yakobson
  Query Rewriting - Assistance Needed
Oracle 11.2.0.4, Solaris 10 1/13
By: suddhasatwa_oracle on Tue, 05 April 2016
7 402 Wed, 06 April 2016 01:23
By: John Watson
  Dynamically add alias to column name for a view.
12c
By: lallaj on Mon, 04 April 2016
4 323 Tue, 05 April 2016 06:57
By: EdStevens
  Member functios in Collection
Oracle 11g
By: saipradyumn on Tue, 05 April 2016
1 234 Tue, 05 April 2016 03:26
By: Michel Cadot
  GROUP BY with 3 tables
Oracle 11g
By: myoratom on Mon, 04 April 2016
2 266 Tue, 05 April 2016 00:30
By: Michel Cadot
  find Characters which are not present in keyboard
Oracle 10g
By: sss111ind on Mon, 04 April 2016
2 292 Mon, 04 April 2016 15:51
By: Barbara Boehmer
  Random distribution of sum
Oracle 11g
By: NikoTrend1 on Mon, 04 April 2016
6 348 Mon, 04 April 2016 11:59
By: John Watson
  subquery with group by issue
oracle 11
By: rlicata on Mon, 04 April 2016
15 455 Mon, 04 April 2016 09:09
By: Solomon Yakobson
  need help to find CityJail_8.sql script
oraqle sql
By: gregorydouglas89 on Sat, 02 April 2016
11 6186 Mon, 04 April 2016 01:22
By: John Watson
  plsql logic (merged 3)
By: yashi7777 on Thu, 31 March 2016
32 975 Fri, 01 April 2016 16:31
By: yashi7777
  Subtracting dates
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
By: javon13 on Thu, 31 March 2016
9 628 Fri, 01 April 2016 14:26
By: Barbara Boehmer
  Oracle SQL - Parameter in where condition to search two values from one
By: azocomposto on Fri, 01 April 2016
2 294 Fri, 01 April 2016 05:53
By: JNagtzaam
  Can RESULT_CACHE be used in a Package Function?
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: mokarem on Wed, 30 March 2016
4 344 Wed, 30 March 2016 05:39
By: John Watson
  Grouping text
11.2.0.3
By: Amine on Sat, 26 March 2016
2 893 Sat, 26 March 2016 19:59
By: Barbara Boehmer
  Column to Row
ORACLE PL SQL
By: reach2nm on Thu, 24 March 2016
17 1143 Sat, 26 March 2016 11:44
By: pablolee
  Simplify SQL Interface to Oracle R Enterprise
Oracle 12c
By: vinhnh on Sat, 26 March 2016
2 476 Sat, 26 March 2016 04:11
By: vinhnh
  Multi Set operator (MULTISET UNION DISTINCT) in PL/SQL
11g
By: vikram_2050 on Fri, 25 March 2016
8 602 Fri, 25 March 2016 16:06
By: vikram_2050
  Multi Level Table Type Output
10G
By: vikram_2050 on Thu, 03 March 2016
2 518 Fri, 25 March 2016 13:56
By: vikram_2050
  Table LOCK
Oracle 12C
By: deepakdot on Fri, 25 March 2016
11 811 Fri, 25 March 2016 09:12
By: Bill B
  Using utl_file
11.0.2.10
By: OraFerro on Wed, 23 March 2016
6 679 Fri, 25 March 2016 07:02
By: Solomon Yakobson
  connection issue-how to reset ?
4.1.3 sql developer
By: M123 on Tue, 22 March 2016
11 577 Thu, 24 March 2016 06:37
By: EdStevens
  Update without cursor
Oracle 11G
By: Sam D. on Wed, 23 March 2016
7 377 Wed, 23 March 2016 16:46
By: Sam D.
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 Aug 27 19:32:22 CDT 2016

Total time taken to generate the page: 0.10370 seconds