What does select * from mean in sql?
How do I kill a query in postgresql?
how to see the create table statement of an existing table? : Sql dba
What is difference between triggers and stored procedures. And advantages of SP over triggers ?
What is procedure and function?
What is the difference between alter trigger and drop trigger statements?
how will you find out the last three records in a table with n no of records and delete them
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
How do sql triggers work?
write a query to find 4th max salary
what is self join and how it works??
how to run 'mysql' commands from a batch file? : Sql dba
Can we insert data in view?