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;

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

1065

---

How to revoke create session privilege from a user in oracle?

1068

---

Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

2176

---

How to export data with a field delimiter?

1085

---

What is literal?

1062

---

How do I use unicode codesets with the weblogic jdriver for oracle driver?

1124

---

How to use "in" parameter properly?

1119

---

How to define an oracle sub procedure?

1230

---

What happens to the data files if a tablespace is dropped?

1107

---

What do database buffers contain?

1083

---

Write a trigger example in oracle?

1113

---

How to empty your oracle recycle bin?

1074

---

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2423

---

What is data type in oracle?

1183

---

How to get maxsal , minsal, ename department wise in single query

1603

---