Answer Posted / selvaraj v, anna university

In Oracle 10g :
---------------

no rows selected.


E.g:
----

SQL> SELECT * FROM job;

EMPNO JOBTITLE
--------- --------------------
1 Tester
2 Accountant
3 Developer
4 COder
5 Director
6 Mediator
7 Proffessor
8 Programmer
9 Developer

9 rows selected.

SQL> SELECT * FROM job WHERE 1=2;

no rows selected.

Explain the commit statement.

611

---

how to extract a unit value from a date and time? : Sql dba

552

---

What does := mean in pl sql?

551

---

What is a schema sql?

529

---

How can we store rows in PL/SQL using array?

662

---

---

What is having clause in sql?

525

---

What is clustered index in sql?

582

---

Is sql a dbms?

528

---

Explain locks? : Transact sql

565

---

Can we delete column in sql?

557

---

What is left inner join in sql?

515

---

How to assign sql query results to pl sql variables?

507

---

what are the authentication modes in sql server? How can it be changed? : Sql dba

699

---

what are the different type of sql's statements ? : Sql dba

518

---

What is a function in oracle pl sql?

538

---