 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 : Hi Rampratap, U r telling abt the efficiency of view @ mutating table concept. can u pls explain it with an example?Thanks Pratima ... Latest Answer : If a view is based upon a single table then DML operations can be performed on it, while if a view is based upon more than two tables then it is a complex view and DML operations can be performed using instead of triggers. ... 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 Answer posted by Scott on 2005-05-25 18:41:26: From the SQL> prompt, type the following: select * from v$version; Latest Answer : Just type define on your sql prompt ..you will get required info.. ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1 
0