El-Shihabi http://el-shihabi.com/blog Abdulaziz El-Shihabi Blog, Where you can find a useful things :D Fri, 26 Feb 2010 08:16:45 +0000 http://wordpress.org/?v=2.7.1 en hourly 1 The real golden age http://el-shihabi.com/blog/?p=115 http://el-shihabi.com/blog/?p=115#comments Fri, 26 Feb 2010 08:16:45 +0000 admin http://el-shihabi.com/blog/?p=115

]]>

]]> http://el-shihabi.com/blog/?feed=rss2&p=115 Data Base Administration “Recommended” http://el-shihabi.com/blog/?p=114 http://el-shihabi.com/blog/?p=114#comments Wed, 17 Feb 2010 05:55:38 +0000 admin http://el-shihabi.com/blog/?p=114 1- Tablespaces - create two table spaces (one for tables and other for indexes) 2- Index -bitmap for repeated value like = 0,1 - Femal, Mail -B-tree for large value

]]> 1- Tablespaces
- create two table spaces (one for tables and other for indexes)
2- Index
-bitmap for repeated value like = 0,1 - Femal, Mail
-B-tree for large value

]]> http://el-shihabi.com/blog/?feed=rss2&p=114 ORACLE IS_NUMBER FUNCTION http://el-shihabi.com/blog/?p=111 http://el-shihabi.com/blog/?p=111#comments Fri, 15 Jan 2010 23:03:58 +0000 admin http://el-shihabi.com/blog/?p=111 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 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;

]]> http://el-shihabi.com/blog/?feed=rss2&p=111 Create Oracle Tablespace SQL http://el-shihabi.com/blog/?p=109 http://el-shihabi.com/blog/?p=109#comments Thu, 14 Jan 2010 08:15:41 +0000 admin http://el-shihabi.com/blog/?p=109 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

]]> 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

]]> http://el-shihabi.com/blog/?feed=rss2&p=109 ORACLE - Shared Pool http://el-shihabi.com/blog/?p=106 http://el-shihabi.com/blog/?p=106#comments Wed, 06 Jan 2010 16:42:39 +0000 admin http://el-shihabi.com/blog/?p=106 GET POOL INFORMATION select name,bytes/(1024*1024) MB from v$sgastat where pool=’shared pool’ order by bytes desc;

]]> GET POOL INFORMATION
select name,bytes/(1024*1024) MB from v$sgastat where pool=’shared pool’ order by bytes desc;

]]> http://el-shihabi.com/blog/?feed=rss2&p=106 Oracle Database link http://el-shihabi.com/blog/?p=103 http://el-shihabi.com/blog/?p=103#comments Thu, 10 Dec 2009 09:07:33 +0000 admin http://el-shihabi.com/blog/?p=103 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;

]]> 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;

]]> http://el-shihabi.com/blog/?feed=rss2&p=103 XFORWARD http://el-shihabi.com/blog/?p=102 http://el-shihabi.com/blog/?p=102#comments Wed, 25 Nov 2009 07:51:34 +0000 admin http://el-shihabi.com/blog/?p=102 from the remote: export DISPLAY=host.name.com:port

from the local xhost host.name.com

]]> from the remote:
export DISPLAY=host.name.com:port

from the local
xhost host.name.com

]]> http://el-shihabi.com/blog/?feed=rss2&p=102 Sannib.com http://el-shihabi.com/blog/?p=99 http://el-shihabi.com/blog/?p=99#comments Tue, 17 Nov 2009 07:45:31 +0000 admin http://el-shihabi.com/blog/?p=99

]]>

]]> http://el-shihabi.com/blog/?feed=rss2&p=99 Q8khail.com http://el-shihabi.com/blog/?p=92 http://el-shihabi.com/blog/?p=92#comments Tue, 17 Nov 2009 07:33:24 +0000 admin http://el-shihabi.com/blog/?p=92 موقع عربي خليجي متخصص بالخيول ومعداتها صورة الموقع

يمكنكم من خلال الموقع

1- عرض خيولكم

2- بيع معداتكم

3- اعلانات لاستطبلاتكم

]]>

موقع عربي خليجي متخصص بالخيول ومعداتها
صورة الموقع

يمكنكم من خلال الموقع

1- عرض خيولكم

2- بيع معداتكم

3- اعلانات لاستطبلاتكم

]]> http://el-shihabi.com/blog/?feed=rss2&p=92 oracle timestamp http://el-shihabi.com/blog/?p=90 http://el-shihabi.com/blog/?p=90#comments Thu, 05 Nov 2009 13:41:57 +0000 admin http://el-shihabi.com/blog/?p=90 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

]]> 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

]]> http://el-shihabi.com/blog/?feed=rss2&p=90