|
|
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 |
1970 |
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 |
980 |
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 |
1939 |
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 |
1091 |
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 |
1523 |
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 |
826 |
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 |
785 |
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 |
1090 |
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 |
944 |
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 |
825 |
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 |
1070 |
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 |
1373 |
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 |
920 |
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 |
1036 |
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 |
2388 |
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 |
1013 |
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 |
1045 |
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 |
1126 |
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 |
962 |
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 |
944 |
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 |
963 |
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 |
1138 |
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 |
2429 |
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 |
1037 |
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 |
1025 |
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 |
1708 |
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 |
3646 |
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 |
1110 |
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 |
1037 |
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 |
1067 |
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 |
959 |
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 |
1068 |
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 |
1038 |
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 |
1705 |
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 |
1383 |
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 |
937 |
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 |
1290 |
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 |
1721 |
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 |
2403 |
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 |
1191 |
Wed, 13 February 2002 07:05 By: inonusin ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |