|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Temporary Table Problem By: uma on Wed, 13 March 2002 |
2 |
951 |
Wed, 13 March 2002 11:30 By: uma ![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) |
|
Insert and Where clause By: Rob on Wed, 13 March 2002 |
1 |
793 |
Wed, 13 March 2002 11:16 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) |
|
Replacing values in CLOB column |
3 |
1436 |
Wed, 13 March 2002 11:15 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) |
|
simple PL/SQL question 2 By: Rania on Wed, 13 March 2002 |
1 |
1018 |
Wed, 13 March 2002 10:42 By: Rajarshi ![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) |
|
Error 00900 in stored procedure By: LI810 on Wed, 13 March 2002 |
1 |
787 |
Wed, 13 March 2002 10: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) |
|
EXP-00046 |
1 |
1024 |
Wed, 13 March 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) |
|
How do I replace characters in a CLOB data type |
1 |
1234 |
Wed, 13 March 2002 08:30 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: Oracle 7.3 Installation By: Bob on Wed, 13 March 2002 |
0 |
955 |
Wed, 13 March 2002 07:34 By: Bob ![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) |
|
Display in rows |
1 |
947 |
Wed, 13 March 2002 04:00 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) |
|
pl/sql stored procedure |
2 |
1206 |
Wed, 13 March 2002 03:23 By: Cindy ![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) |
|
PLS-00103: Encountered the symbol "PROCEDURE" By: Rm69 on Wed, 13 March 2002 |
2 |
1709 |
Wed, 13 March 2002 02:21 By: THA ![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 Group by By: Rm69 on Tue, 12 March 2002 |
3 |
1358 |
Wed, 13 March 2002 02:16 By: THA ![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 Re: Procedures By: Rm69 on Wed, 13 March 2002 |
0 |
801 |
Wed, 13 March 2002 01:41 By: Rm69 ![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 blanks By: ron on Tue, 12 March 2002 |
2 |
1222 |
Wed, 13 March 2002 01:29 By: Pratibha ![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) |
|
utility which selectively updates/inserts a record for given fields By: gnana on Wed, 13 March 2002 |
1 |
829 |
Wed, 13 March 2002 01:22 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 select n-1 columns in a table with n columns ? By: sorcer on Wed, 13 March 2002 |
1 |
750 |
Wed, 13 March 2002 01:03 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) |
|
Output file and exit; |
2 |
862 |
Wed, 13 March 2002 00:57 By: Stephanie ![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) |
|
code does not get executed, why?????? By: Sid on Tue, 12 March 2002 |
1 |
806 |
Wed, 13 March 2002 00:56 By: Pratibha ![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) |
|
simple PL/SQL question By: Rania on Tue, 12 March 2002 |
2 |
728 |
Wed, 13 March 2002 00:54 By: Stephanie ![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) |
|
sqlldr By: jaba on Mon, 11 March 2002 |
4 |
1071 |
Tue, 12 March 2002 21:23 By: jaba ![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) |
|
[RAVI] ORA-00937: not a single-group group function By: Ravi on Mon, 11 March 2002 |
3 |
1848 |
Tue, 12 March 2002 19:06 By: Jim Willis ![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) |
|
eliminating rows when more than one rows has been returned By: shad on Tue, 12 March 2002 |
1 |
841 |
Tue, 12 March 2002 18:50 By: Jim Willis ![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) |
|
Using pl/sql Boolean datatype in ' where' clause of SQL select stmt By: Krish on Mon, 11 March 2002 |
2 |
2070 |
Tue, 12 March 2002 18:42 By: Krish ![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: True or False data type By: Krish on Tue, 12 March 2002 |
0 |
918 |
Tue, 12 March 2002 18:33 By: Krish ![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) |
|
Truncate and Commit By: uma on Tue, 12 March 2002 |
2 |
1871 |
Tue, 12 March 2002 17:57 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) |
|
Spool in pl/sql |
1 |
882 |
Tue, 12 March 2002 15:50 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: SQL String Manipulation ?! |
0 |
1026 |
Tue, 12 March 2002 13:20 By: Satish Kakumani ![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) |
|
parameterized procedures |
2 |
889 |
Tue, 12 March 2002 13:15 By: Soheil K ![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) |
|
Joining on Nonmatched Key By: uma on Mon, 11 March 2002 |
5 |
916 |
Tue, 12 March 2002 12:28 By: uma ![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) |
|
Default Values !!!!!!!! Urgent By: Rm69 on Tue, 12 March 2002 |
1 |
893 |
Tue, 12 March 2002 10:53 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) |
|
Date Convert By: Ed on Thu, 07 March 2002 |
2 |
873 |
Tue, 12 March 2002 10:48 By: sfhollands ![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) |
|
grouping by 2 sql stts joined by UNION By: citrav on Tue, 12 March 2002 |
1 |
805 |
Tue, 12 March 2002 09:30 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 retrieve the column names from tables using PL/SQL By: Gianni on Mon, 03 December 2001 |
3 |
1437 |
Tue, 12 March 2002 09:20 By: Sevki Piskinsoy ![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) |
|
initial extent - large table |
1 |
1657 |
Tue, 12 March 2002 07:48 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) |
|
PL/SQL |
1 |
801 |
Tue, 12 March 2002 07:39 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) |
|
Oracle 7.3 Installation By: Bob on Tue, 12 March 2002 |
1 |
1302 |
Tue, 12 March 2002 07:20 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) |
|
Problems in calling stored procedure from trigger... By: raman on Tue, 12 March 2002 |
1 |
856 |
Tue, 12 March 2002 07:07 By: Mahehs Rajendran ![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) |
|
.FOPEN() , I thought 'w' would create a new file By: theak on Tue, 12 March 2002 |
1 |
2056 |
Tue, 12 March 2002 06:06 By: Doris ![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) |
|
Cursors By: Rm69 on Sat, 09 March 2002 |
2 |
906 |
Tue, 12 March 2002 05:09 By: Rm69 ![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) |
|
assigning a filname to a variable and running the variable name from the prompt By: theak on Fri, 08 March 2002 |
2 |
994 |
Tue, 12 March 2002 05:03 By: theak ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |