Lots of Questions on PL/SQL
From: W. Ho <who_at_mailhost.vih.com>
Date: 1996/02/01
Message-ID: <who.16.000032B9_at_mailhost.vih.com>#1/1
Date: 1996/02/01
Message-ID: <who.16.000032B9_at_mailhost.vih.com>#1/1
Hi, I have some questions on PL/SQL. If anybody could help me out, I would
really really appreciate it.
(FYI. I am using PL/SQL editor in Developer 2000)
- I could not seem to find a built-in exception to handle the following situations:
- insert/update/delete a non-existant table
- update a row with a index key value that is not in the table
- Is there a way to write an entire record type to a file (without breaking down to rec_type.field1, rec_type.field2...etc) ? The list of functions in built-in package TEXT_IO only allows writing varchar2, number and date.
- How does one check if a file already exist given a directory?
- How does one check for end fo file?
- How does one select the first or last record in a table?
Thank you very much.
Cheers,
Wei-Lin
Received on Thu Feb 01 1996 - 00:00:00 CET