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 [...]
|
||||||
|
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 |
||||||
|
Copyright © 2010 El-Shihabi - All Rights Reserved |
||||||