How to trace the errors in pl/sql block code?
Answer Posted / shivashanker
select text from user_errors where name='PROCEDURE NAME OR FUNCTION NAME'
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
What are the advantages of normalization?
what are the features and advantages of object-oriented programming? : Sql dba
Does asenumerable execute the query?
What is varray in pl sql?
What is the requirement of self-join?
what is a trigger in mysql? : Sql dba
What does t sql mean?
What is row_number () in sql?
What are types of exception?
What is type and rowtype in pl sql?
what are all types of user defined functions? : Sql dba
What is cte?
What is triggering circuit?
Do we need to create index on primary key?