Does truncate table reset auto increment?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

..........refers to the disk mirroring

2 Answers   iFlex,


What is a parameter query?

0 Answers  


How does postgresql compare to oracle/db2/ms sql server/informix?

0 Answers  


Cite the differences between execution of triggers and stored procedures?

0 Answers  


Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

0 Answers   MCN Solutions,






how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as NN,NN,NN,NE,NN,NN,NE,CE, Its some urgent requirement ,thanks in advance

6 Answers  


What is cte?

0 Answers  


How can we make an if statement within a select statement?

0 Answers  


What is a stored procedure ?

9 Answers  


How can I speed up sql query?

0 Answers  


Who developed sql?

0 Answers  


How many rows will return from dual table?

4 Answers   Fujitsu,


Categories