What is meant by user defined function?
What are the types of index in sql?
Can we rollback truncate?
what are the authentication modes in sql server? How can it be changed? : Sql dba
what is Difference between Having and Where clause?
Which one of the following pairs of aggregate functions do you use with character fields? 1. COUNT(field) and MAX(field) 2. AVG(field) and COUNT(field) 3. MIN(field) and SUM(field) 4. AVG(field) and MAX(field) 5. COUNT(field) and SUM(field)
How to display the contents of a current record fetched in a reference cursor?
What can you do with pl sql?
Can we write dml inside a function in sql server?
What are three advantages to using sql?
type type_name is table of varchar2(30) index by binary_integer for the above type you have to create a identifier... like identifier_name type_name; for the above type you can use the below methods..like first , last , prior, next , delege..etc...like this.. if you create a cursor...like cursor cursor_name is select * from scott.emp; is there any methods like above to use prior, fist , last , next , trim ,etc...
what is variable in package specification
explain advantages of innodb over myisam. : Sql dba