|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Oracle reports Oracle 11g |
7 |
2903 |
Tue, 05 July 2016 05:02 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
query doubt hp unix, oracle 10g |
4 |
2125 |
Tue, 05 July 2016 00:43 By: arun888 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
SQL problem - variation on top-n-of-group. DDL and DML supplied. Oracle - any version this millenium, also MySQL and PostgreSQL. By: dragam on Sat, 02 July 2016 |
5 |
3233 |
Mon, 04 July 2016 17:20 By: Barbara Boehmer ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
String Manipulations Oracle 11g R2 |
1 |
1471 |
Mon, 04 July 2016 13:36 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Pick One : A Query for Multiple Submission of form but to take only first one. Oracle 11g R2 |
11 |
3332 |
Mon, 04 July 2016 13:13 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Constraints in External Table. Oracle 11g |
4 |
1681 |
Mon, 04 July 2016 10:13 By: jeeva7311 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Procidure includ not duplicate By: rkled on Mon, 04 July 2016 |
3 |
1795 |
Mon, 04 July 2016 09:29 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Updating Status W to A SQL |
28 |
10657 |
Mon, 04 July 2016 02:59 By: cookiemonster ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
PLSQL grant script not working correctly 12c By: ICB555 on Fri, 01 July 2016 |
5 |
2484 |
Mon, 04 July 2016 02:56 By: cookiemonster ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
First business day of a given month Oracle 10g By: sidh_z on Mon, 06 December 2010 |
24 |
23090 |
Fri, 01 July 2016 12:10 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
How can I modify length of a column in type definition. 11.2.0.1.0 |
2 |
1827 |
Thu, 30 June 2016 16:24 By: Barbara Boehmer ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Issue in Exxternal Table Oracle 11g |
9 |
2655 |
Thu, 30 June 2016 08:51 By: Solomon Yakobson ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
Conversion Approach Oracle 12c, Windows Server 2012 |
4 |
1617 |
Wed, 29 June 2016 07:38 By: abacusdotcom ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
low performance of CONNECT BY Oracle 11g |
2 |
1690 |
Tue, 28 June 2016 08:56 By: Bill B ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
SQL for Tables Oracle 11g R2 |
15 |
2607 |
Mon, 27 June 2016 21:11 By: BlackSwan ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Help Creating a Trigger for Reoccuring Events Oracle 12c |
12 |
3977 |
Mon, 27 June 2016 09:22 By: Bill B ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
column with data_type CLOB does not appear in user_ind_columns, why? |
7 |
2749 |
Sat, 25 June 2016 10:57 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
How to prevent trigger from firing on failed insert Oracle 8,2 By: laddg on Fri, 24 June 2016 |
13 |
3494 |
Sat, 25 June 2016 07:02 By: EdStevens ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
![icon4.gif](/forum/images/message_icons/icon4.gif) |
Table update through nested loop issue in function |
15 |
3411 |
Thu, 23 June 2016 09:28 By: nitesh.erp@gmail.com ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Analytic Report query Oracle 11g |
2 |
1905 |
Thu, 23 June 2016 08:18 By: srinivas.k2005 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
ORA-29278: SMTP transient error: 421 Service not available By: musman on Tue, 06 May 2008 |
29 |
72052 |
Thu, 23 June 2016 08:12 By: BlackSwan ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Need Help to convert rows into column Oracle 11g |
12 |
5560 |
Thu, 23 June 2016 03:50 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Better query Oracle 11 |
2 |
1503 |
Thu, 23 June 2016 02:56 By: Roachcoach ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
how to get one week historical query for v$SQL |
4 |
1911 |
Wed, 22 June 2016 06:34 By: EdStevens ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
A Query for Seating Arrangement |
5 |
5113 |
Wed, 22 June 2016 00:43 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
![icon7.gif](/forum/images/message_icons/icon7.gif) |
Update 7% basic Salary SQL Plus 8.0 ( 1 2) |
44 |
12366 |
Mon, 20 June 2016 22:05 By: Salehin ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
SQL to filter redundant key field Oracle 9.2 on Solaris By: raghx on Mon, 20 June 2016 |
2 |
1959 |
Mon, 20 June 2016 19:34 By: Barbara Boehmer ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
how to export the data from table to the file oracle 11g |
4 |
1986 |
Mon, 20 June 2016 15:31 By: tolupuluri ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Aggregate based on serial number after checking for thresholds |
3 |
1522 |
Mon, 20 June 2016 13:06 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Exception Handling oracle 11g |
4 |
1920 |
Mon, 20 June 2016 03:01 By: cookiemonster ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
LAG function 10g, win8.1 By: rzkhan on Sat, 18 June 2016 |
3 |
1723 |
Sat, 18 June 2016 02:30 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
connect and level sql developer |
1 |
1480 |
Fri, 17 June 2016 15:10 By: Solomon Yakobson ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
What is the use of %ROWTYPE and %TYPE in PL/SQL? |
2 |
1826 |
Fri, 17 June 2016 02:13 By: Frank Naude ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Query table with multi part column names 11g By: bobghw on Thu, 16 June 2016 |
6 |
1703 |
Thu, 16 June 2016 15:21 By: Bill B ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Calculating values from two different tables by using SQL command. Oracle 11g ver 11.2.0.1.0 |
5 |
1663 |
Thu, 16 June 2016 08:39 By: Bill B ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Removing specific line from file using UTL_FILE 11g |
6 |
2409 |
Thu, 16 June 2016 02:33 By: harshadsp ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
TO_NUMBER function not working |
2 |
2677 |
Wed, 15 June 2016 17:56 By: richard_oak ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
"ORA-22813: operand value exceeds system limits" on executing sql returning XMLTYPE data Oracle 11g |
12 |
11024 |
Wed, 15 June 2016 13:01 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
What is wrong with this sql code? |
3 |
1851 |
Wed, 15 June 2016 07:34 By: EdStevens ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
regexp replace Oracle 11g, Win 7 |
9 |
2159 |
Tue, 14 June 2016 15:55 By: Bill B ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |