SQL ERROR--Nebulous definition

2001-07-05 Thread Lisa Clary
not sure what this is telling me--any ideas? I am exporting as one user then importing as another--but all activity does occur within its own schema. thanks, lc -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lisa Clary INET: [EMAIL PROTECTED] Fat City Network

Sorry---I figured it out.....FW: SQL ERROR--Nebulous definition

2001-07-05 Thread Lisa Clary
. thanks, lc -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lisa Clary INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: PL/SQL

2001-06-29 Thread Lisa Clary
subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lisa Clary INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

An approach to isolating external users--opinions wanted

2001-06-27 Thread Lisa Clary
://www.orafaq.com -- Author: Lisa Clary INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from

RE: QUERY HELP

2001-06-26 Thread Lisa Clary
Title: QUERY HELP One way to do this is in the procedure, use variables that hold the previous values (e.g. last_rnum := rnum). Then, do your comparison of your current value to your last stored value (e.g. if rnum - last_rnum 1 then flag='*'). I am sure there are more than one way to skin

RE: TRUNCATE IN PL/SQL

2001-06-21 Thread Lisa Clary
the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lisa Clary INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RE: TRUNCATE IN PL/SQL

2001-06-21 Thread Lisa Clary
(or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lisa Clary INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: TRUNCATE IN PL/SQL

2001-06-21 Thread Lisa Clary
ORACLE-L FAQ: http://www.orafaq.com -- Author: Lisa Clary INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

RE: TRUNCATE IN PL/SQL

2001-06-21 Thread Lisa Clary
://www.orafaq.com -- Author: Lisa Clary INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from