Give the structure of the function ?2 4699
Explain how procedures and functions are called in a PL/SQL block ?3 7572
What is Overloading of procedures ?2 4877
What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?
How packaged procedures and functions are called from the following?2 4479
Name the tables where characteristics of Package, procedure and functions are stored ?3 8650
write a procedure to print a statement or number not using "dbms_output.put_line" package.write a procedure instead of it using procdure name as "print" ex:- declare a number:=2; begin print(a); end; /* when U type above procedure 2 have to should be printed*/2 4684
what is sql and plsql6 7943
what is organisational index?1 3313
what are the advantages of cursors than procedures?2 9903
how many sql dml commands are supported by 'mysql'? : Sql dba
Why do we use partitions in sql?
What are the constraints available in sql?
Where the sql database files are stored?
what is check constraint? : Sql dba
how do you know if your mysql server is alive? : Sql dba
List out the acid properties and explain?
What are three advantages to using sql?
Why indexing is needed?
what is auto increment? : Sql dba
How do I count records in sql?
Explain constraints in sql?
What is an exception in pl/sql?
what is a composite primary key ? : Sql dba
Could you please provide oca (oracle 10g) dumps for my certification ?