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;

How to convert characters to times in oracle?

675

---

How to install oracle odbc drivers?

707

---

how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

1666

---

What are the advantages of oracle?

658

---

How do we create privileges in oracle?

669

---

---

How to build data dictionary view an new database?

641

---

How to create an oracle database manually?

666

---

What is a table index?

654

---

What is an Oracle index?

1274

---

Hi Can any one tell me what are the API's used in requisition import.

1582

---

What is raw datatype?

671

---

what is difference between sql plus and sql*plus? (not sql and sql plus).

3433

---

What are the differences between char and varchar2 in oracle?

652

---

how to do daily transactions with out sql* loader control file regesterd in apps?

1307

---

What is using clause and give example?

675

---