Sravani saka

Hi, can anyone tell me the advantages of alias name

hi, can we use sub query in order by clause?? and how?

how to drop multiple columns at a time.. i tried with the following syntax "alter table <table_name> drop column <col_name1>, <col_name2>" but i am getting syntactical error.

can we use double quotes to the column name while creating a table?? if yes, then how to insert the records into it???

Hi, can any one explain me about d2k. what it exactly mean, and its use. I got an opportunity to work with d2k. i have knowledge in Oracle. How can I learn d2k? Thanq in advance.