What can be a size of a pl/sql block? Is there any limit?
Answer Posted / pavan_1981
not more 32KB
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the difference between view and stored procedure?
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
Is id a reserved word in sql?
Can you sum a count in sql?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
explain the difference between delete , truncate and drop commands? : Sql dba
What can sql server reporting services do?
What is difference between hql and native sql?
Is sql difficult?
What is cursor in pl sql?
List different type of expressions with the example.
how to return query output in html format? : Sql dba
What problem one might face while writing log information to a data-base table in pl/sql?
Is sql developer case sensitive?
Can two tables have same primary key?