|
|
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 |
1966 |
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 |
976 |
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 |
1932 |
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 |
1087 |
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 |
1515 |
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 |
819 |
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 |
779 |
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 |
1086 |
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 |
940 |
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 |
820 |
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 |
1064 |
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 |
1367 |
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 |
916 |
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 |
1032 |
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 |
2384 |
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 |
1005 |
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 |
1038 |
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 |
1120 |
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 |
956 |
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 |
937 |
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 |
956 |
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 |
1130 |
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 |
2423 |
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 |
1029 |
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 |
1020 |
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 |
1701 |
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 |
3639 |
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 |
1104 |
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 |
1033 |
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 |
1063 |
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 |
955 |
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 |
1063 |
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 |
1034 |
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 |
1699 |
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 |
1377 |
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 |
930 |
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 |
1279 |
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 |
1717 |
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 |
2398 |
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 |
1187 |
Wed, 13 February 2002 07:05 By: inonusin ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |