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...
How are multiple column = value pairs delimited in the SET clause of an UPDATE statement? 1. With commas (SET price = 0, status = 'I') 2. With parentheses (SET (price = 0) (status = 'I')) 3. With double-pipes (SET price = 0 || status = 'I') 4. With square-brackets (SET [price = 0] [status = 'I'] 5. With single or multiple spaces (SET price = 0 status = 'I')
What type of join is sql join?
How do I view a sql database?
How many types of cursors are available in pl/sql?
I want to know the difference between A Record Type and a Table.
What is the syntax to add a record to a table?
how to include character strings in sql statements? : Sql dba
what is query cache in mysql? : Sql dba
Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?
What is auto increment feature in sql?
How to find 3rd highest salary of an employee from the employee table in sql?
How many types of keys are there in sql?