How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

1049

What is a pl/sql block?

1227

What is having clause in sql?

963

What are variables in pl sql?

1167

How many rows can sqlite handle?

1112

What is sql resultset?

987

Can you sum a count in sql?

1011

how to use myisamchk to check or repair myisam tables? : Sql dba

971

Why do we use sqlite?

975

How do I sort a table in sql?

1045

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...

2448

Can instead of triggers be used to fire once for each statement on a view?

962

What are different types of triggers?

1110

What are the various levels of constraints?

1124

How do I install sql?

997