Interested to Buy Any Domain ? << Click Here >> for more details...
select statement does not retrieve any records. what
exception is raised?
- 2 Answers
- 5774 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / madhu
Here two ways is there
you are using single select statement it display no rows
selected message.
If you are using in PL/SQL BLOCK at that time it raise the
error
NO_DATA_FOUND( IF YOU DECLARED) OTHER WISE IT GO FOR
WHEN OTHERS_THEN EXCEPTION HANDER.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is oracle and what are its different editions?
What is archive log in Oracle?
What is the string concatenation operator in oracle?
Explain mutating triggers.
How to shutdown your 10g xe server from command line?
Is insert autocommit in oracle?
What is a cursor and what are the steps need to be taken?
Differentiate between pre-select and pre-query?
Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15
how can get like this result table A col1 col2 --- ----- a A b B C C .. .. .. ... .. ... wants result like for a single column col1 ------ a,b,c,........n of data and another is col1 ------- A B C D ........ a b b d ........
What is raw datatype?
Explain what are the advantages of views?
Oracle General 
