This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / 下周有个PL/SQL考试，大侠出几个题目考考我先吧。。。
-mycar(豪情煮水);
2004-9-28
(#1907527@0)
-
Here is a tricky one1,
You have a table as:
CompanyName, NetIncome
Please write a query to:
1) Retrive the company's names of top 10 net income
2) Retrive the company's names which net income are between 11th and 20th
Assume: Oracle version 8 to 9i
If you want, try it in Oracle 7 and see whether it works.
2,
If you got a message as "Function xxx does not guarantee not to update database"
What should you do to correct it?
Good Luck
-handd(大熊猫®);
2004-9-29
{439}
(#1908234@0)