Question { Polaris, 15751 }

I have one Excel file with 1,50,000 Records. Now I need to
load that whole file into Oracle Database with same columns
in Excel sheet .
I need PLSQL Procedure or used by SQL PLUS

Answer

Probably, u have to save the file in ur hard disk(namely in
ur D drive) first eg. sourav.txt
Then open pl/sql developer and open a command window. And
then type in: @ D:\sourav.txt
All the rows will be updated.. finally "commit" it.

Question { UST, 16547 }

how to delete duplicate rows from a specified table(only
single table)
how do you know which join is need to be used

Answer

If you wish to remove duplicate values, then use the
DISTINCT parameter.
Consider there is a table:emp, with deptno. as one of its
coloumn. This coloumn has repeated values. Then you should
use the following query to remove the duplicate values:
SELECT DISTINCT deptno FROM emp;

Question { 39908 }

find the third highest salary?

Answer

select * from (select * from order by salary
desc)where rownum<4

---this way u can get the record of the top 3 salaries and
easily filter out the 3rd positioned salary from there.

Is This Answer Correct ?

4 Yes

5 No

Question { CGI, 29353 }

Is there any command in Unix, other than:ls, to list the
files in a directory?
The answer will be highly appreciated...

Answer

I think the question was not clear to Anil or Dhina...What i
meant was that i don't want to use 'ls' to list the files...
Is there any other way to do so?

Question { Microsoft, 26150 }

how to find largest file?

Answer

In the Directry Give....

ls -ls|sort -nr|head -1

that gives the largest file statistics...

Question { Microsoft, 26150 }

how to find largest file?

Answer

There is no simple command available to find out the largest files/directories on a Linux/UNIX/BSD filesystem. However, combination of following three commands (using pipes) you can easily find out list of largest files:

du command : Estimate file space usage.
sort command : Sort lines of text files or given input data.
head command : Output the first part of files i.e. to display first 10 largest file.
find command : Search file.
Type the following command at the shell prompt to find out top 10 largest file/directories:
# du -a /var | sort -n -r | head -n 10

Sample outputs:

1008372 /var
313236 /var/www
253964 /var/log
192544 /var/lib
152628 /var/spool
152508 /var/spool/squid
136524 /var/spool/squid/00
95736 /var/log/mrtg.log
74688 /var/log/squid
62544 /var/cache