|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Add Date Function By: jneill on Fri, 15 February 2002 |
1 |
1260 |
Fri, 15 February 2002 11: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) |
|
Passing a parameter list for IN clause in cursor. By: Avery on Fri, 15 February 2002 |
1 |
1074 |
Fri, 15 February 2002 10:48 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 function By: Bill S on Fri, 15 February 2002 |
2 |
1185 |
Fri, 15 February 2002 10:14 By: Bill S ![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) |
|
PL/SQL SYSTEM FUNCTION By: Davide on Thu, 14 February 2002 |
3 |
1253 |
Fri, 15 February 2002 09:23 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) |
|
Execute Immediate n .. By: diaz on Thu, 14 February 2002 |
1 |
1530 |
Fri, 15 February 2002 08:22 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) |
|
Needs get one row. By: sopao on Thu, 14 February 2002 |
3 |
1388 |
Fri, 15 February 2002 08: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: ORA-00937: not a single-group group function |
0 |
1200 |
Fri, 15 February 2002 04:40 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) |
|
how to insert blob datatype |
1 |
825 |
Fri, 15 February 2002 03:31 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) |
|
package |
1 |
988 |
Fri, 15 February 2002 03:28 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) |
|
Arrays By: diaz on Thu, 14 February 2002 |
1 |
929 |
Fri, 15 February 2002 03:28 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) |
|
DBMS_OUTPUT info needed By: marco on Thu, 14 February 2002 |
1 |
1155 |
Fri, 15 February 2002 03: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: Difference between oracle and SQL Server |
0 |
913 |
Fri, 15 February 2002 03:20 By: liu woon heng ![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) |
|
Let Oracle truncate values on INSERT autom. ? |
1 |
1107 |
Fri, 15 February 2002 01: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) |
|
how to delete the records from master table when it has child relationships By: ksr on Fri, 15 February 2002 |
1 |
1075 |
Fri, 15 February 2002 01:55 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) |
|
Group By and (SELECT) , oracle newbie question By: Elias on Fri, 15 February 2002 |
1 |
1257 |
Fri, 15 February 2002 01:44 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) |
|
what r the steps we have to follow after sucessfully compiled the explicit cursor |
2 |
1153 |
Fri, 15 February 2002 00:06 By: Abul Fazal ![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 fetch record from cursor and store in memory- URGENT By: UmaSund on Thu, 14 February 2002 |
1 |
977 |
Fri, 15 February 2002 00:06 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) |
|
UTL_FILE |
2 |
2277 |
Fri, 15 February 2002 00:02 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 display only limited no of rows at a time By: Mike on Thu, 14 February 2002 |
0 |
1429 |
Thu, 14 February 2002 23:53 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) |
|
Re: how to display only limited no of rows at a time |
0 |
1278 |
Thu, 14 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) |
|
Opinions on using distinct / unique By: Dan on Thu, 14 February 2002 |
3 |
1120 |
Thu, 14 February 2002 23: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) |
|
improving performance of a query By: Chris on Wed, 13 February 2002 |
4 |
1225 |
Thu, 14 February 2002 23:35 By: Abul Fazal ![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) |
|
Finding Records 60 days back from sysdate By: Tom on Wed, 13 February 2002 |
2 |
911 |
Thu, 14 February 2002 23:17 By: Abul Fazal ![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) |
|
loops and cursors By: ratna on Thu, 14 February 2002 |
1 |
1056 |
Thu, 14 February 2002 23:04 By: Abul Fazal ![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 |
2 |
1269 |
Thu, 14 February 2002 20:46 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) |
|
PARTITION PROBLEM By: lily on Mon, 11 February 2002 |
1 |
1097 |
Thu, 14 February 2002 19:56 By: vaidehi ![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) |
|
Procedure to drop tables By: diaz on Thu, 14 February 2002 |
2 |
1370 |
Thu, 14 February 2002 18:42 By: diaz ![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 fetch record from Cursor and store them in memory -URGENT By: UmaSund on Thu, 14 February 2002 |
3 |
1660 |
Thu, 14 February 2002 18:33 By: Somu ![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: Dropping table in Oracle if they exist By: diaz on Thu, 14 February 2002 |
0 |
1098 |
Thu, 14 February 2002 17:03 By: diaz ![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 stament with data functions By: mary on Thu, 14 February 2002 |
1 |
817 |
Thu, 14 February 2002 12:36 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 do i create a plsql type ..like table By: ksr on Wed, 13 February 2002 |
1 |
1067 |
Thu, 14 February 2002 12: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) |
|
How to schedule a job at a certain time? |
2 |
1050 |
Thu, 14 February 2002 12:20 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) |
|
SQLPlus trimming spaces in spool file By: Theo on Thu, 14 February 2002 |
1 |
964 |
Thu, 14 February 2002 12: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) |
|
Time dependent primary key. By: Larbi on Thu, 14 February 2002 |
1 |
956 |
Thu, 14 February 2002 12:05 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) |
|
Object access info. |
1 |
1025 |
Thu, 14 February 2002 11: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) |
|
how to get records which are not matching By: ksr on Thu, 14 February 2002 |
1 |
851 |
Thu, 14 February 2002 10:22 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: ORA-00937: not a single-group group function |
0 |
1016 |
Thu, 14 February 2002 09:42 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) |
|
Re: LONG RAW By: mayur on Thu, 14 February 2002 |
0 |
1117 |
Thu, 14 February 2002 09:23 By: mayur ![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 |
1 |
1120 |
Thu, 14 February 2002 08:21 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 Thu, 14 February 2002 |
1 |
1018 |
Thu, 14 February 2002 07:31 By: pratap kumar tripathy ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |