How can we print the error code in exception handling section?
You can print the 'sqlcode' as followsException When others thendbms_output.put_line('error code is'||sqlcode)end;
EXCEPTIONWHEN No_privilages THENhtp.p( ' Access denied');WHEN Rec_expired THENhtp.p('Other user has changed this record,Query the record and Update');WHEN OTHERS THENHtp.p(SQLERRM);
How do you declare a variable with blob as datatype? How can you use blob data type? What size can be given to its variable?
BLOB is Binary Large ObjectWhen you declare any variable as image, text, ntext ... they would be BLOB data typesText = 2^31-1text = 2^30-1ntext = 2^31-1-Each text, ntext, image colum can in a table ca...
Explain how DDL commands used in a procedure or function?
HI ALL,try this..,create or replace procedure ddl_proc(tabname in varchar2)asv_cursor INTEGER;ddl_exe INTEGER;beginv_cursor:=Dbms_sql.open_cursor;Dbms_sql.Parse(v_cursor,' Create Table '||tabn...
We can use DDL commands in Procedure & Functions through "EXECUTE IMMEDIATE " Command
Has there been a time when you were presented a problem and solved it?
Career Options for BCA Graduates
Describe a time when you had to convince a friend ?
How to handle academic gap while applying for a job?
Give me good reasons why should I choose you over others.
What do you do when things do not go as planned? Cite an example.
What is your way of building rapport with a person you just met?
Describe a time when you had to work under pressure.
What are the things you wish to achieve in 5 years?
Aptitude Test Preparation Tips
Ask Interview Question?
Have Career Question?
Ask Only Career questions.