|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Handling ASCII values in ORACLE like ^M |
2 |
1972 |
Thu, 14 February 2002 07:20 By: andrew again ![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) |
|
buffer By: fung on Wed, 13 February 2002 |
1 |
983 |
Thu, 14 February 2002 07:04 By: pratap kumar tripathy ![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-00904: invalid column name By: ksr on Wed, 13 February 2002 |
2 |
1941 |
Thu, 14 February 2002 06:58 By: ksr ![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) |
|
Re: B*-tree indexes By: Mike on Thu, 14 February 2002 |
0 |
1093 |
Thu, 14 February 2002 06:33 By: Mike ![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 execute this function with boolean variable as input By: ksr on Wed, 13 February 2002 |
5 |
1526 |
Thu, 14 February 2002 06:30 By: Bala ![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) |
|
dbms_stats By: krishna on Thu, 14 February 2002 |
1 |
831 |
Thu, 14 February 2002 05:57 By: Grant ![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) |
|
B*-tree indexes By: krishna on Thu, 14 February 2002 |
1 |
790 |
Thu, 14 February 2002 04:56 By: Raj ![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) |
|
unable to delete record |
1 |
1092 |
Thu, 14 February 2002 04:15 By: pratap kumar tripathy ![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 By: David on Thu, 14 February 2002 |
1 |
949 |
Thu, 14 February 2002 04:07 By: pratap kumar tripathy ![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) |
|
unable to delete record |
1 |
827 |
Thu, 14 February 2002 03:36 By: pratap kumar tripathy ![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) |
|
Re: Explain plan By: Mike on Thu, 14 February 2002 |
0 |
1073 |
Thu, 14 February 2002 03:34 By: Mike ![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) |
|
indexes By: krishna on Thu, 14 February 2002 |
1 |
1377 |
Thu, 14 February 2002 03:33 By: Mike ![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) |
|
Select Function By: Anita on Thu, 14 February 2002 |
1 |
923 |
Thu, 14 February 2002 02:24 By: pratap kumar tripathy ![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) |
|
Re: ORA-00937: not a single-group group function |
0 |
1039 |
Thu, 14 February 2002 02:12 By: philarmo ![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) |
|
Orackle Package |
1 |
2390 |
Thu, 14 February 2002 01:07 By: pratap kumar tripathy ![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) |
|
database trigger to restrict deleting |
1 |
1016 |
Thu, 14 February 2002 00:56 By: pratap kumar tripathy ![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) |
|
nested loops By: krishna on Thu, 14 February 2002 |
1 |
1048 |
Thu, 14 February 2002 00:37 By: pratap kumar tripathy ![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) |
|
Re: Explain plan |
0 |
1129 |
Thu, 14 February 2002 00:37 By: pratap kumar tripathy ![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 do i delete the records By: ksr on Wed, 13 February 2002 |
3 |
965 |
Thu, 14 February 2002 00:16 By: pratap kumar tripathy ![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 read the data from type created as table By: ksr on Wed, 13 February 2002 |
3 |
947 |
Wed, 13 February 2002 23:46 By: pratap kumar tripathy ![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) |
|
Re: SQL TUTORIAL. |
0 |
966 |
Wed, 13 February 2002 21:18 By: Je-Marie ![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) |
|
Improve Performance of SQL |
2 |
1141 |
Wed, 13 February 2002 21:18 By: Satish Shrikhande ![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) |
|
IMP-00017: following statement failed with ORACLE error 54: By: aks on Wed, 13 February 2002 |
1 |
2439 |
Wed, 13 February 2002 21:04 By: Satish Shrikhande ![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) |
|
Scrollable Resultset By: Vijay on Wed, 13 February 2002 |
1 |
1039 |
Wed, 13 February 2002 20:59 By: Satish Shrikhande ![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) |
|
Trigger Compiles But does not capture all Details By: Rm69 on Wed, 13 February 2002 |
1 |
1030 |
Wed, 13 February 2002 17:18 By: Raj ![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 statement By: tofeks on Mon, 04 February 2002 |
6 |
1711 |
Wed, 13 February 2002 16:26 By: tofeks ![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 with PLS-00357 error: |
2 |
3648 |
Wed, 13 February 2002 15:25 By: Todd Barry ![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 calculate the difference between dates on different rows By: UmaSund on Tue, 12 February 2002 |
2 |
1114 |
Wed, 13 February 2002 13:20 By: Mike ![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 you keep your SQL Session active? |
1 |
1040 |
Wed, 13 February 2002 10:02 By: Grant ![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) |
|
View Text By: Arpit on Wed, 13 February 2002 |
1 |
1070 |
Wed, 13 February 2002 09:47 By: Grant ![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) |
|
HOST() command in PL/SQL ? By: GK on Wed, 13 February 2002 |
1 |
961 |
Wed, 13 February 2002 09:29 By: Grant ![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) |
|
displaying updated rows on screen By: Vinod on Thu, 07 February 2002 |
3 |
1071 |
Wed, 13 February 2002 09:07 By: Vinod ![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) |
|
batch processing |
1 |
1040 |
Wed, 13 February 2002 07:51 By: andrew again ![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 read from the collection .. By: ksr on Sun, 10 February 2002 |
4 |
1710 |
Wed, 13 February 2002 07:47 By: andrew again ![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) |
|
SYSDATE of remote database By: Sumesh on Tue, 12 February 2002 |
3 |
1385 |
Wed, 13 February 2002 07:40 By: Todd Barry ![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) |
|
explain plan By: krishna on Tue, 12 February 2002 |
1 |
940 |
Wed, 13 February 2002 07:37 By: Todd Barry ![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) |
|
coping one schema to another schema By: sufiyan on Tue, 12 February 2002 |
2 |
1293 |
Wed, 13 February 2002 07:34 By: Grant ![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) |
|
Temporary table alternative By: LI810 on Tue, 12 February 2002 |
3 |
1725 |
Wed, 13 February 2002 07:24 By: ksr ![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 Loader stops before end of file By: Jason on Tue, 12 February 2002 |
1 |
2405 |
Wed, 13 February 2002 07:08 By: INTROV ![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) |
|
Re: alternate SQL without Exists clause |
0 |
1194 |
Wed, 13 February 2002 07:05 By: inonusin ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |