|
|
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 |
1261 |
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 |
1075 |
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 |
1187 |
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 |
1255 |
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 |
1532 |
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 |
1389 |
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 |
1201 |
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 |
826 |
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 |
989 |
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 |
930 |
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 |
1156 |
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 |
914 |
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 |
1108 |
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 |
1076 |
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 |
1259 |
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 |
1154 |
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 |
978 |
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 |
2279 |
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 |
1430 |
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 |
1282 |
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 |
1121 |
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 |
1226 |
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 |
913 |
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 |
1058 |
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 |
1270 |
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 |
1098 |
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 |
1371 |
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 |
1661 |
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 |
1099 |
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 |
820 |
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 |
1068 |
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 |
1051 |
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 |
965 |
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 |
957 |
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 |
1026 |
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 |
852 |
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 |
1017 |
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 |
1118 |
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 |
1123 |
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 |
1020 |
Thu, 14 February 2002 07:31 By: pratap kumar tripathy ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |