Comments for El-Shihabi http://el-shihabi.com/blog Abdulaziz El-Shihabi Blog, Where you can find a useful things :D Mon, 06 Sep 2010 08:41:48 +0000 http://wordpress.org/?v=2.7.1 hourly 1 Comment on Oracle 10g DBA, Notes by Elizabeth nhu http://el-shihabi.com/blog/?p=46#comment-9333 Elizabeth nhu Mon, 10 May 2010 12:20:18 +0000 http://el-shihabi.com/blog/?p=46#comment-9333 I would like to have more information about: 1. Data Retention 2. Data update 3. Data replacement 4. Historical data (data that is replaced or deleted). I would like to have more information about:
1. Data Retention
2. Data update
3. Data replacement
4. Historical data (data that is replaced or deleted).

]]> Comment on Create Oracle Tablespace SQL by admin http://el-shihabi.com/blog/?p=109#comment-9176 admin Thu, 14 Jan 2010 08:37:26 +0000 http://el-shihabi.com/blog/?p=109#comment-9176 Do it as professional, not like me at first time :), add the extension .dbf Do it as professional, not like me at first time :), add the extension .dbf

]]> Comment on Alter tablespace for table(s) by dba http://el-shihabi.com/blog/?p=78#comment-9123 dba Fri, 27 Nov 2009 07:12:15 +0000 http://el-shihabi.com/blog/?p=78#comment-9123 1- create tablespace tbs_name Datafile 'tbs_name' SIZE 5120M AUTOEXT ON NEXT 100M; 1- create tablespace tbs_name Datafile ‘tbs_name’ SIZE 5120M AUTOEXT ON NEXT 100M;

]]> Comment on Getting Expire Domain in PLESK by admin http://el-shihabi.com/blog/?p=15#comment-9108 admin Sun, 31 May 2009 08:26:21 +0000 http://el-shihabi.com/blog/?p=15#comment-9108 select distinct domains.name, FROM_UNIXTIME(Limits.value,'%d-%m-%Y') as EXPIRE_DATE FROM domains, Limits Where Limits.id=domains.Limits_id and limit_name='expiration' order by Limits.value desc limit 0,500; select distinct domains.name, FROM_UNIXTIME(Limits.value,’%d-%m-%Y’) as EXPIRE_DATE FROM domains, Limits Where Limits.id=domains.Limits_id and limit_name=’expiration’ order by Limits.value desc limit 0,500;

]]> Comment on Getting Expire Domain in PLESK by Hisham http://el-shihabi.com/blog/?p=15#comment-3 Hisham Wed, 26 Nov 2008 07:33:15 +0000 http://el-shihabi.com/blog/?p=15#comment-3 I've tried this, it's lighter :) ----------------------------------------------------------------------------------- SELECT DISTINCT domains.name, FROM_UNIXTIME(Limits.value, '%d-%m-%Y') as EXPIRE_DATE FROM domains, Limits WHERE Limits.id=domains.Limits_id and FROM_UNIXTIME(Limits.value, '%m-%Y')='12-2008'; I’ve tried this, it’s lighter :)
———————————————————————————–
SELECT DISTINCT domains.name, FROM_UNIXTIME(Limits.value, ‘%d-%m-%Y’) as EXPIRE_DATE FROM domains, Limits WHERE Limits.id=domains.Limits_id and FROM_UNIXTIME(Limits.value, ‘%m-%Y’)=’12-2008′;

]]> Comment on Welcome Back ME! by Hisham http://el-shihabi.com/blog/?p=5#comment-2 Hisham Tue, 25 Nov 2008 06:07:45 +0000 http://el-shihabi.com/blog/?p=5#comment-2 Hee, welcome back Hee, welcome back

]]>