 Related Questions Latest Answer : Data Definition Language: Create, AlterData Modification Language: Update,insert, Delete, TruncateData Control Language: Commit, Rollback ... 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 : There are 5 types of joins available in sql server1) inner join2) outer join( left outer join,Right outer join)3) Full Join4) Cross Join5) Self Join1) inner Join : Two tables having the common column values go with inner join.Example:select * from emp ... 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 : VARCHAR2: Max Size=4000 bytesCHAR: Max Size=2000 bytesNUMBER(p,s): The precision p can range from 1 to 38. The scale s can ... 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 : 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. ... Display the records between two range I know the nvl function only allows the same data type(ie. number or char or date Nvl(comm, 0)), if commission is null then the text “Not Applicable” want to display, instead of blank space. How do I write the query
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
