Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: a simple question about FKs
('binary' encoding is not supported, stored as-is)
Gene,
Your assumption is correct. Since TRUNCATE doesn't go through all rows (as DELETE) and cannot therefore check rows one by one, this is how it is implemented. BTW, do not be fooled by TRUNCATE even if its result is for the superficial mind the same as a DML command (DELETE): it is a DDL command. Therefore, Oracle checks exactly the same as with DROP.
Regards,
Stephane Faroult
Oriole
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul INET: sfaroult_at_oriolecorp.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Tue Jun 18 2002 - 09:18:18 CDT
![]() |
![]() |