Can we rollback after truncate?
What is data type in database?
what is the difference between a web-garden and a web-farm? : Sql dba
what is sql? : Sql dba
What is the differnce between view and materialized view
Explain the advantages and disadvantages of stored procedure?
how will i became good database developer?
Explain how exception handling is done in advance pl/sql?
What is sqlcontext?
I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman
How do sql databases work?
need to split a string into seperate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,b,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.
What is exception? What are the types of exceptions?