what is the difference between truncate and delete statement? : Transact sql
No Answer is Posted For this Question
Be the First to Post Answer
What is embedded sql what are its advantages?
What are the different ways to optimize a sql query?
What are the different types of triggers?
ename empno deptno amar 1 10 akbar 2 20 anthonny 3 30 jonathan 4 40 write a procedure to dispaly the column values ina row separated by a deleimiter eg - input - select ename from emp '|' output - amar|akbar|anthony|jonathan input - select empno from emp '@' o/p - 1@2@3@4 input - select deptno from emp '/' o/p - 10/20/30/40 Pls answer this questn.
What is the use of nvl function?
What is sql partition?
How many commands are in sql?
Does truncate remove indexes?
what is the stuff function and how does it differ from the replace function? : Sql dba
What is a system versioned table?
Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.
What are actual parameters and formal parameters?