Answer Posted / os reddy

select * from <table name>
where rownum<=2
order by last_updated_date;

OR

select * from emp where to_char(update_column,'dd')=2;

What has stored procedures in sql and how we can use it?

561

---

Mention what pl/sql package consists of?

531

---

How can we solve sql error: ora-00904: invalid identifier?

693

---

What is the usage of sql functions?

535

---

What do you understand by pl/sql records?

526

---

---

What type of database is sql?

613

---

What is the use of triggers?

536

---

Whis is not false in primary key?

971

---

what is table? : Sql dba

570

---

What is union and union all keyword in sql?

563

---

Why do we use procedures in sql?

542

---

Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

1668

---

What is the need of merge statement?

545

---

What is application trigger?

533

---

What are the most important ddl statements in sql?

565

---