 Related Questions Answer posted by Scott on 2005-05-25 18:30:04: TRUNCATE is a DDL command and cannot be rolled back. All of the memory space is released back to the server. DELETE is a DML command and can be rolled Latest Answer : DELETE is a logged operation on a per row basis. This means that the deletion of each row gets logged and physically deleted. You can DELETE any row that will not violate a constraint, while leaving the foreign key or any other contraint in place. ... Latest Answer : Quote A ROWID is created by Oracle for each new row in every table, it is a pseudo column that has a value for every row in a table. The ROWID gives us the physical address of a row and is the fastest way to access any row. The ROWID contains 3 ... Latest Answer : Dec(p,s), desimal(p,s), double precision, foat, int, inteager, real, smallint, numeric(p,s), number(p,s), char(size), varchar2(size), long, raw, long raw, date, timestamp, urowid(size), rowid, boolean, nchar(size) , nvarchar2(size), bfile, blob, clob, ... Latest Answer : Only one column can have LONG data type. And that column cannot be used in WHERE clause or in ORDER BY clause. Also we cannot add primary key constraint to that column only not to the whole table, that means we will give primary key to any column in the ... Answered by Scott on 2005-05-12 10:18:34: Constraints are found under the USER_CONSTRAINTS table. Latest Answer : Correction to some answers aboveUser_Constraints is a view and not a table ... Latest Answer : Nextval must be used to generate a sequence number in the current user's session before currval can be referenced. ... Latest Answer : if a view based on one table or multiple table matter is it should contain all not null columns and additionaly no calculated column then ant DML statement will cause changes in base table. ... Latest Answer : select * from employee where 1=(select count(*) from employee as e where employee.sal Latest Answer : Till Oracle 7.0, only 12 triggers could be defined per table. In later versions there is no such limitation. ... Latest Answer : use the following syntex for drop the columnalter table emp drop column ename; ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
