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
  Please help for regexp_replace in oracle 11g
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit
By: msol25 on Mon, 25 April 2016
3 291 Mon, 25 April 2016 07:37
By: msol25
  Nested cursor expressions
DB 12.1.0.2
By: John Watson on Fri, 22 April 2016
25 847 Sun, 24 April 2016 10:39
By: John Watson
  with clause logic
By: sivaparam on Mon, 04 April 2016
33 1142 Sun, 24 April 2016 06:55
By: Bill B
  need to get row count for database with 20 k tables
oracle 11 g
By: TorontoTrader on Thu, 21 April 2016
12 634 Fri, 22 April 2016 15:14
By: Solomon Yakobson
  Dynamic SQL - with CONCAT function
Oracle 11g
By: ORAGENASHOK on Thu, 21 April 2016
9 556 Fri, 22 April 2016 06:18
By: Solomon Yakobson
  Dbms_schedule
Oracle Database, 10g, Windows 7
By: azamkhan on Fri, 22 April 2016
2 388 Fri, 22 April 2016 03:08
By: cookiemonster
  Nested table with object type
ORACLE 11g
By: ORAGENASHOK on Sat, 09 April 2016
14 1296 Thu, 21 April 2016 13:23
By: Barbara Boehmer
icon5.gif Error when create policy after create view. What is the problem?
PLSQL
By: quytrieu on Tue, 05 April 2016
3 325 Thu, 21 April 2016 07:31
By: Solomon Yakobson
  Counting overlapping ID's in intersection tables.
Oracle, 12.1.0.1, AIX 7.1
By: posefant on Wed, 20 April 2016
25 952 Thu, 21 April 2016 06:00
By: posefant
  Date Functions
Oracle 10g
By: Danny Freeman on Tue, 05 April 2016
4 554 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 573 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 451 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 375 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 279 Tue, 19 April 2016 07:00
By: pointers
  Bulk collect data problem
Oracle 10g
By: cjcsegers on Fri, 15 April 2016
5 495 Mon, 18 April 2016 12:52
By: Bill B
  random numbers
Oracle 11.2.0.3
By: pointers on Fri, 15 April 2016
5 666 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 554 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 472 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 480 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 321 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 555 Wed, 13 April 2016 03:12
By: OraFerro
  Summation on Character Variables
Oracle 10g
By: chat2raj.s on Wed, 06 April 2016
8 628 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 749 Tue, 12 April 2016 06:13
By: gajini
  Update in EXECUTE IMMEDIATE
Oracle 11G
By: RaShi.Raj on Mon, 11 April 2016
13 399 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 362 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 324 Tue, 05 April 2016 06:57
By: EdStevens
  Member functios in Collection
Oracle 11g
By: saipradyumn on Tue, 05 April 2016
1 236 Tue, 05 April 2016 03:26
By: Michel Cadot
  GROUP BY with 3 tables
Oracle 11g
By: myoratom on Mon, 04 April 2016
2 268 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 296 Mon, 04 April 2016 15:51
By: Barbara Boehmer
  Random distribution of sum
Oracle 11g
By: NikoTrend1 on Mon, 04 April 2016
6 349 Mon, 04 April 2016 11:59
By: John Watson
  subquery with group by issue
oracle 11
By: rlicata on Mon, 04 April 2016
15 459 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 6191 Mon, 04 April 2016 01:22
By: John Watson
  plsql logic (merged 3)
By: yashi7777 on Thu, 31 March 2016
32 978 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 631 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 297 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 900 Sat, 26 March 2016 19:59
By: Barbara Boehmer
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 Aug 31 18:44:55 CDT 2016

Total time taken to generate the page: 0.12877 seconds