xuqinglei2000

 Profile Answers by xuqinglei2000 Questions by xuqinglei2000

• Nov 21st, 2007

ALTER SYSTEM SET SHARED_POOL_SIZE=.....

Answer Question  Select Best Answer

Is there any way to import the excel data in to oracle database without using the SQL loader, please let me know.

xuqinglei2000

 Profile Answers by xuqinglei2000 Questions by xuqinglei2000

• Nov 21st, 2007

Well,if you have less data ,you can just copy the data; for exampleselect * from table for update then open the lock, then copy  the data from excel to the database;

Answer Question  Select Best Answer

Select round(13.19,1) from dual will return 13.2Select round(13.19,-1) from dual ....what will be the output.....IN ORACLE

Imran_Javed

 Profile Answers by Imran_Javed Questions by Imran_Javed

• May 13th, 2008

SELECT ROUND(13.19,-1) FROM DUAL;RETURN result IS 10; WHEN you pass second argument AS "-1" , rounding takes place BEFORE the DECIMAL point.That IS the reason IN the above example it rounds 13 TO 10. IF you USE 15 OR more than 15 it will ROUND TO 20

xuqinglei2000

 Profile Answers by xuqinglei2000 Questions by xuqinglei2000

• Nov 21st, 2007

SELECT ROUND(13.19,-1) FROM DUALRETURN RESULT IS 10;

Answer Question  Select Best Answer