CREATE OR REPLACE FUNCTION is_number(char_in VARCHAR2) RETURN NUMBER IS
BEGIN
FOR x IN 1 .. LENGTH(char_in) LOOP
— remove , & .
IF SUBSTR(char_in,x,1) in (’,’ , ‘.’ , ‘ ‘) THEN
RETURN 0;
END IF;
END LOOP;
IF TO_NUMBER(char_in,’9999999′) > -1000000 THEN
RETURN 1 ;
END IF;
EXCEPTION
WHEN invalid_number THEN
RETURN 0;
WHEN OTHERS THEN
RETURN 0;
END is_number;
CREATE SMALLFILE TABLESPACE “TBS_NAME” DATAFILE ‘$ORACLE_BASE/$SID/file.dbf’ SIZE 5120M REUSE AUTOEXTEND ON NEXT 100M MAXSIZE 32767M LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
GET POOL INFORMATION
select name,bytes/(1024*1024) MB from v$sgastat where pool=’shared pool’ order by bytes desc;
Create Database link:
desc user_db_links
set linesize 121
col db_link format a20
col username format a20
col password format a20
col host format a20
SELECT * FROM user_db_links;
SELECT * FROM all_db_links;
SELECT table_name, tablespace_name FROM user_tables@conn_user;
from the remote:
export DISPLAY=host.name.com:port
from the local
xhost host.name.com
Select to_char(to_date(’01-JAN-1970′) + 1257424753/86400,’DD-MM-YYYY HH:MI:SS’) from dual;
SELECT to_char(TO_DATE(’19700101000000′,’YYYYMMDDHH24MISS’)
+ NUMTODSINTERVAL(1257424753, ‘SECOND’),’DD_MM_YY HH24:MI:SS’) FROM DUAL
**********************************************************
*/usr/local/psa/admin/sbin/statistics –calculate-one –domain-name=domain*
**********************************************************
select * into outfile '/tmp/outfile.txt' fields terminated by ',' from my_table_name;
