Answer Posted / shachindra pandey

proc sql;
select id,name,population from populations where
population=(select max(population) from
populations
where population < (select max(population) from
populations));


quit;

Explain the truncate in oracle?

543

---

What is a dynamic performance view in oracle?

604

---

Where are the settings stored for each instance in oracle?

621

---

How to insert a record into a table?

636

---

What happens if recursive calls get out of control?

546

---

---

What happens if the imported table already exists?

547

---

What is oracle join syntax?

568

---

What is the difference between formal parameters and actual parameters?

543

---

How to convert dates to characters in oracle?

577

---

How to export several tables together?

564

---

What is recycle bin in Oracle?

713

---

What is the difference between a user and a schema in oracle?

556

---

How to create a stored procedure in oracle?

573

---

How to handle a single quote in oracle sql?

593

---

Calculate difference between 2 date / times in oracle sql?

570

---