 Related Questions Insert, update, delete, select, references, index, execute, alter, all Latest Answer : alter, delete, index, insert, references, select, update. are the table(object)priviliges that can be granted by a user to others. ... USER_CONSTRAINTS Latest Answer : desc user_constraints;to see constraints on a particular table like emp select constraint_name,constraint_type,table_name from user_constraints; ... Both will result in deleting all the rows in the table EMP.Answered by Scott on 2005-05-12 10:31:58: The difference is that the TRUNCATE call cannot be rolled back and all memory space for that table is Latest Answer : CREATE TABLE ABC
(
Col1 INT
)INSERT INTO ABC VALUES (1)
BEGIN TRAN
TRUNCATE TABLE ABC
ROLLBACK TRAN
SELECT * FROM ABCIn this way, I am able to roll back truncate command. So in
SQL server we can Roll Back TRUNCATE Command. ... Answer :CREATE TABLE .. AS SELECT commandExplanation : To copy only the structure, the WHERE clause of the SELECT command should contain a FALSE statement as in the following.CREATE TABLE NEWTABLE AS SELECT Latest Answer : SELECT * INTO NewTable FROM ExistingTable WHERE 1 = 2 will copy the structure of the existing table without any data. If we need the NewTable with data we can filler the records in WHERE clause. ... DROP TABLE &TABLE_NAME;Variable names should start with an alphabet. Here the table name starts with an '&' symbol. Latest Answer : This does not give an error in Oracle 9iFollowing is the outputSQL> DROP TABLE &TABLE_NAME;Enter value for table_name: temp_special_payslip(this has been eneterd by me)old 1: DROP TABLE &TABLE_NAMEnew 1: DROP TABLE temp_special_payslipTable ... It is used to drop constraints specified on the table. Latest Answer : The rtrim function requires 1 arguments. ... Answer :DESC has two purposes. It is used to describe a schema as well as to retrieve rows from table in descending order.Explanation : The query SELECT * FROM EMP ORDER BY ENAME DESC will display the Latest Answer : DESC[RIBE] is a SQL*Plus command It is used to describe an Oracle Table, View, Synonym, package or Function.Note that because this is a SQL*Plus command you don't need to terminate it with a semicolon.Syntax: DESC table DESC view DESC synonym ... When this clause is used with the DROP command, a parent table can be dropped even when a child table exists. Latest Answer : Hi,Deletes all Foreign keys that reference the table to be dropped, then drops the table. RedsTahngam. ... I have a table with duplicate names in it. Write me a query which returns only duplicate rows with number of times they are repeated? Latest Answer : to copy a table along with records create table as select *from ;if we want to copy only structure create table < new tablename> select *from ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
