Maximum how many triggers can we use in trigger and How to find out how many records it fetched.

TCS,

How did you export data from database to excel file.

TCS,

Difference between global and parameter variables?

TCS,

What is extent clause in table space?

TCS,

What is the use of time stamp in select statement?

TCS,

Which data type doesn't allow null data type?

TCS,

What is window clause?

TCS,

Can you alter start with clause?

TCS,

how view used for security purposes?

Glam India,

if i have a procedure with 1000 line.when i run this in 61 line i got the error but i want to continue the programe without error.can anyone tell me how to handle that error.

MasterCard,

i have a table with 1 lac of data.i want to insert this data into another table. i want every 5000 of data insert use a commit.using counter and if error is comming in the 5000 of data it rollback.

MasterCard,

t1 col1 col2 nishi 5000 lucky 6700 akash 7000 i want that a query that when i insert 7000 it will show me data already present and data will not insert. if data is not present it will insert.

MasterCard,

how to we delete a row using varray

CTC,

if i am using dml statement in function. then i am writing select statement what was the output

MasterCard,

difference between bind variable and variable

Attra,