more

$value) { if (strpos($param, 'color_') === 0) { google_append_color($google_ad_url, $param); } else if (strpos($param, 'url') === 0) { $google_scheme = ($GLOBALS['google']['https'] == 'on') ? 'https://' : 'http://'; google_append_url($google_ad_url, $param, $google_scheme . $GLOBALS['google'][$param]); } else { google_append_globals($google_ad_url, $param); } } return $google_ad_url; } $google_ad_handle = @fopen(google_get_ad_url(), 'r'); if ($google_ad_handle) { while (!feof($google_ad_handle)) { echo fread($google_ad_handle, 8192); } fclose($google_ad_handle); } ?>

Monday, March 19, 2012

TYPES OF DATATYPES FOUND IN AN ORACLE DATABASE!

12:40 PM 0 comments



Types of Oracle Database Datatypes

  1. varchar2 this is the most common  datatype it allows you to store  alphanumeric characters. The length of varchar2 is 4000 bytes or characters. This was what set Oracle apart from other databases in prior years. While other databases had lengths up to 2000 Oracle had its character length set at 4000
  2. Number  datatype: allows you to store an interger as well as decimal values
  3. date datatype not to be confused with the time stamp datatype stores the date value - the default way of storing date in Oracle is DD-MON-YY
  4. Timestamp related to the date dataype but instead stoeres information witth a higher sense of precision and accuracy. It stores the date up to the second eg 14 -OCT-09 01.25.07.00002 PM
  5. Clob datatype - stores large objects that are over four gigabytes in size
  6. blob datatype allows for the storage of large binary objects a great example of this would be video.
Hope you enjoyed this post.

0 comments:

Post a Comment