|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
View details By: Andre on Fri, 22 February 2002 |
1 |
1080 |
Fri, 22 February 2002 10:02 By: Suresh Vemulapalli ![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) |
|
date datatype By: Kristin on Fri, 22 February 2002 |
1 |
998 |
Fri, 22 February 2002 09:59 By: Suresh Vemulapalli ![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: Week to date |
0 |
906 |
Fri, 22 February 2002 09:53 By: Suresh Vemulapalli ![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) |
|
modify constraint for on cascade delete By: Shubha on Fri, 22 February 2002 |
1 |
1287 |
Fri, 22 February 2002 09:31 By: Suresh Vemulapalli ![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) |
|
Selecting rows with NULLand BLANK values By: ron on Fri, 22 February 2002 |
1 |
951 |
Fri, 22 February 2002 08:30 By: Jon ![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) |
|
Rollback & ROWID By: shadgar on Fri, 22 February 2002 |
1 |
848 |
Fri, 22 February 2002 05:57 By: shadgar ![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) |
|
sequel server By: krishna on Thu, 21 February 2002 |
1 |
979 |
Fri, 22 February 2002 04:09 By: Suresh Vemulapalli ![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 By: benu on Thu, 21 February 2002 |
1 |
979 |
Fri, 22 February 2002 03:56 By: Suresh Vemulapalli ![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-01843: not a valid month By: Rm69 on Fri, 22 February 2002 |
1 |
2948 |
Fri, 22 February 2002 03:46 By: Suresh Vemulapalli ![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 records within a range from a BIG table By: Kampo on Thu, 21 February 2002 |
2 |
1325 |
Fri, 22 February 2002 03:42 By: Christopher Beattie ![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) |
|
Quick way to change schema owner in PL/SQL code |
1 |
1380 |
Fri, 22 February 2002 03:42 By: Suresh Vemulapalli ![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) |
|
text file and pl/sql relation |
1 |
1000 |
Fri, 22 February 2002 03:40 By: Suresh Vemulapalli ![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) |
|
stored procedures By: krishna on Thu, 21 February 2002 |
1 |
1006 |
Thu, 21 February 2002 23:09 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-20000 ORU-10027 By: HansL on Thu, 21 February 2002 |
0 |
1282 |
Thu, 21 February 2002 22:54 By: HansL ![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) |
|
Order of index columns |
2 |
887 |
Thu, 21 February 2002 22:19 By: Jens Vogelgesang ![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 By: krishna on Thu, 21 February 2002 |
2 |
1101 |
Thu, 21 February 2002 19:33 By: maithili arjunwadkar ![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: not equal- != or <> |
0 |
879 |
Thu, 21 February 2002 18:21 By: Jeff Lassen ![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) |
|
substring By: Sam on Thu, 21 February 2002 |
1 |
1002 |
Thu, 21 February 2002 17:35 By: Suresh Vemulapalli ![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) |
|
Open Cursors |
2 |
1036 |
Thu, 21 February 2002 17:28 By: Prabath Kuga gamage ![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) |
|
Creating a union of 3 views |
1 |
861 |
Thu, 21 February 2002 15:27 By: Suresh Vemulapalli ![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 some DBMS_SQL Code By: Micky on Thu, 21 February 2002 |
3 |
1331 |
Thu, 21 February 2002 11:44 By: Suresh Vemulapalli ![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) |
|
not equal- != or <> |
1 |
1117 |
Thu, 21 February 2002 11:09 By: Jon ![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) |
|
create sql to add indexes to all foreign keys |
1 |
959 |
Thu, 21 February 2002 08:27 By: Suresh Vemulapalli ![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) |
|
getting error ora-01403 data not found when i execute a simple select statement By: ksr on Thu, 21 February 2002 |
3 |
1539 |
Thu, 21 February 2002 08:10 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) |
|
Adding a sequence number to a table. what should be the datatype of that column? By: Sabrina on Thu, 21 February 2002 |
1 |
1097 |
Thu, 21 February 2002 07:46 By: Suresh Vemulapalli ![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) |
|
Difference Between OERR-1422 and OERR-2112 |
1 |
3476 |
Thu, 21 February 2002 06:22 By: Suresh Vemulapalli ![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) |
|
Spooling to a file without select stmt By: Susan on Wed, 20 February 2002 |
2 |
1041 |
Thu, 21 February 2002 06:08 By: Suresh Vemulapalli ![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 list of all child tables for a particular parent table By: ksr on Thu, 21 February 2002 |
1 |
1141 |
Thu, 21 February 2002 06:01 By: Suresh Vemulapalli ![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) |
|
example of returning clause with insert needed By: ksr on Thu, 21 February 2002 |
1 |
937 |
Thu, 21 February 2002 05:50 By: Suresh Vemulapalli ![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) |
|
very urgent...how to do looping inside a table By: ksr on Thu, 21 February 2002 |
1 |
735 |
Thu, 21 February 2002 05:29 By: Suresh Vemulapalli ![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: How to insert pictures in a table By: ALN on Thu, 21 February 2002 |
0 |
1157 |
Thu, 21 February 2002 01:00 By: ALN ![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) |
|
Kill the Session By: Dinesh on Wed, 20 February 2002 |
1 |
1070 |
Wed, 20 February 2002 23:46 By: Pramod ![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) |
|
Querry about the name of table and no of records |
5 |
1319 |
Wed, 20 February 2002 23:45 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: how to use audit command |
0 |
1232 |
Wed, 20 February 2002 23:38 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-03123 - operation would block' By: Nils on Wed, 20 February 2002 |
0 |
1616 |
Wed, 20 February 2002 23:00 By: Nils ![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) |
|
shared pool By: krishna on Wed, 20 February 2002 |
1 |
1004 |
Wed, 20 February 2002 23:00 By: seng ![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: how to use audit command |
0 |
1197 |
Wed, 20 February 2002 18:47 By: NAVODAYA ![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) |
|
Apostrophe in Sql By: Shirish on Tue, 19 February 2002 |
3 |
1023 |
Wed, 20 February 2002 18:26 By: Sudhakar Atmakuru ![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) |
|
append leading zero's to data already in columns By: Toyn on Wed, 20 February 2002 |
1 |
1659 |
Wed, 20 February 2002 12:16 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) |
|
Re: sql query By: vivek on Wed, 20 February 2002 |
0 |
1032 |
Wed, 20 February 2002 11:34 By: vivek ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |