Thursday, November 7, 2013

ORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least 1328M

1) create pfile from spfile;
2) SQL> startup nomount pfile=D:\app\oracle\product\11.2.0\dbhome_1\database\INITorcl.ora
3)  alter database open;
4) alter database open;
5) create spfile from pfile;

Spool table in excel sheet / html page

set feed on markup html on
spool c:\test.xls
select * from emp;
spool off
set feed off markup html off

same way you can export it in html also, you just need to change file extension from .xls to .html

Converting exponential value to numeric

e.g.
select 1987252000000000000 from dual
1.987252E18

Check this:
select to_char(''||1987252000000000000) from dual
1987252000000000000