{"id":416,"date":"2010-07-27T21:10:00","date_gmt":"2010-07-28T02:10:00","guid":{"rendered":"http:\/\/www.dpriver.com\/blog\/?page_id=416"},"modified":"2018-01-12T23:17:25","modified_gmt":"2018-01-13T04:17:25","slug":"oracle-datatypes","status":"publish","type":"page","link":"https:\/\/www.dpriver.com\/blog\/list-of-demos-illustrate-how-to-use-general-sql-parser\/translate-sql-query-between-different-databases\/oracle-datatypes\/","title":{"rendered":"oracle datatypes"},"content":{"rendered":"<p>\nDatatype conversion is one of the key issues when <a href=\"http:\/\/www.dpriver.com\/blog\/list-of-demos-illustrate-how-to-use-general-sql-parser\/translate-sql-query-between-different-databases\/\">convert one dialect of SQL to another<\/a>. This article documents Oracle datatypes and how to convert it to corresponding datatype of other databases.\n<\/p>\n<p>\nOracle Database provides a number of built-in datatypes as well as several categories for user-defined types that can be used as datatypes.\n<\/p>\n<p>\nA datatype is either scalar or nonscalar. A scalar type contains an atomic value, whereas a nonscalar (sometimes called a &#8220;collection&#8221;) contains a set of values. A large object (LOB) is a special form of scalar datatype representing a large scalar value of binary or character data.\n<\/p>\n<p>\nWe focused on bulit-in datatypes and ansi supported datatypes in this article. user defined datatypes and Oracle supplied types(Any Types, XML Types, Spatial Types and Media Types) were not discussed here.\n<\/p>\n<h3> <span>bulit-in datatypes: Character<\/span><\/h3>\n<ul>\n<li>CHAR [(size [BYTE | CHAR])]\n<ul>\n<li><b>Description:<\/b> Fixed-length character data of length size <u>bytes<\/u> or <u>characters<\/u>.<br \/>\nMaximum size is 2000 bytes or characters. Default and minimum size is 1 byte.<\/li>\n<li><b>ISO synonym:<\/b> character, char<\/li>\n<li><b>SQL Server:<\/b> char[(size)], 1 <= size <= 8,000 bytes<\/li>\n<\/ul>\n<\/li>\n<li>VARCHAR2(size [BYTE | CHAR])\n<ul>\n<li><b>Description:<\/b> Variable-length character string having maximum length size <u>bytes<\/u> or <u>characters<\/u>.<br \/>\nMaximum size is 4000 bytes or characters,and minimum is 1 byte or 1 character.<br \/>\nYou must specify size for VARCHAR2.<br \/>\nBYTE indicates that the column will have byte length semantics.<br \/>\nCHAR indicates that the column will have character semantics.<\/li>\n<li><b>ISO synonym:<\/b> character varying, char varying<\/li>\n<li><b>Oracle synonymous:<\/b>VARCHAR,To avoid possible changes in behavior, always use the VARCHAR2 datatype to store variable-length character strings.<\/li>\n<li><b>SQL Server:<\/b> varchar(size), 1 <= size <= 8,000 bytes<\/li>\n<\/ul>\n<\/li>\n<li>NCHAR[(size)]\n<ul>\n<li><b>Description:<\/b> Fixed-length character data of length size <u>characters<\/u>.<br \/>\nThe number of bytes can be up to two times size for AL16UTF16 encoding and three times size for UTF8 encoding.<br \/>\nMaximum size is determined by the national character set definition, with an upper limit of 2000 bytes.<br \/>\nDefault and minimum size is 1 character.<\/li>\n<li><b>ISO synonym:<\/b> national character, national char, nchar<\/li>\n<li><b>SQL Server:<\/b> nchar[(size)]<\/li>\n<\/ul>\n<\/li>\n<li>NVARCHAR2(size)\n<ul>\n<li><b>Description:<\/b> Variable-length Unicode character string having maximum length size <u>characters<\/u>.<br \/>\nThe number of bytes can be up to two times size for AL16UTF16 encoding and three times size for UTF8 encoding.<br \/>\nMaximum size is determined by the national character set definition, with an upper limit of 4000 bytes.<br \/>\nYou must specify size for NVARCHAR2.<\/li>\n<li><b>ISO synonym:<\/b> national character varying, national char varying, nchar varying<\/li>\n<li><b>SQL Server:<\/b> nvarchar(size)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h3> <span>bulit-in datatypes: long and raw<\/span><\/h3>\n<ul>\n<li>long\n<ul>\n<li><b>Description:<\/b> Character data of variable length up to 2 gigabytes, or 2^31 -1 bytes. Provided for backward compatibility.<\/li>\n<li><b>ISO synonym:<\/b> N\/A<\/li>\n<li><b>SQL Server:<\/b> varchar(max)<\/li>\n<\/ul>\n<\/li>\n<li>long raw\n<ul>\n<li><b>Description:<\/b> Raw binary data of variable length up to 2 gigabytes.<\/li>\n<li><b>ISO synonym:<\/b> N\/A<\/li>\n<li><b>SQL Server:<\/b> image\/varbinary(max)<\/li>\n<\/ul>\n<\/li>\n<li>raw(size)\n<ul>\n<li><b>Description:<\/b> Raw binary data of length size <u>bytes<\/u>. Maximum size is 2000 bytes. You must specify size for a RAW value.<\/li>\n<li><b>ISO synonym:<\/b> N\/A<\/li>\n<li><b>SQL Server:<\/b> varbinary(size)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h3> <span>bulit-in datatypes: large object<\/span><\/h3>\n<ul>\n<li>clob\n<ul>\n<li><b>Description:<\/b> A character large object containing single-byte or multibyte characters.<br \/>\nBoth fixed-width and variable-width character sets are supported, both using the database character set.<br \/>\nMaximum size is (4 gigabytes &#8211; 1) * (database block size).<\/li>\n<li><b>ISO synonym:<\/b> N\/A<\/li>\n<li><b>SQL Server:<\/b> varchar(max)<\/li>\n<\/ul>\n<\/li>\n<li>nclob\n<ul>\n<li><b>Description:<\/b> A character large object containing Unicode characters.<br \/>\nBoth fixed-width and variable-width character sets are supported, both using the database national character set.<br \/>\nMaximum size is (4 gigabytes &#8211; 1) * (database block size).<br \/>\nStores national character set data.<\/li>\n<li><b>ISO synonym:<\/b> N\/A<\/li>\n<li><b>SQL Server:<\/b> ntext<\/li>\n<\/ul>\n<\/li>\n<li>blob\n<ul>\n<li><b>Description:<\/b> A binary large object. Maximum size is (4 gigabytes &#8211; 1) * (database block size).<\/li>\n<li><b>ISO synonym:<\/b> N\/A<\/li>\n<li><b>SQL Server:<\/b> varbinary(max)\/image<\/li>\n<\/ul>\n<\/li>\n<li>bfile\n<ul>\n<li><b>Description:<\/b> Contains a locator to a large binary file stored outside the database.<br \/>\nEnables byte stream I\/O access to external LOBs residing on the database server.<br \/>\nMaximum size is 4 gigabytes.<\/li>\n<li><b>ISO synonym:<\/b> N\/A<\/li>\n<li><b>SQL Server:<\/b> VARBINARY(MAX) <\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h3> <span>bulit-in datatypes: Number<\/span><\/h3>\n<ul>\n<li>NUMBER [ (p [, s]) ]\n<ul>\n<li><b>Description:<\/b> Number having precision p and scale s. The precision p can range from 1 to 38. The scale s can range from -84 to 127. Both precision and scale are in decimal digits.<br \/>\nIn a NUMBER column, floating point numbers have decimal precision.<br \/>\nIn a BINARY_FLOAT or BINARY_DOUBLE column, floating-point numbers have binary precision.<br \/>\nNUMBER (*, scale), In this case, the precision is 38, and the specified scale is maintained.\n<\/li>\n<li><b>ISO synonym:<\/b> numeric[(p [, s])]<\/li>\n<li><b>SQL Server:<\/b>number to float; number(p [,s]) to numeric(p [,s]),  if s > p, then set p = s.<\/li>\n<\/ul>\n<\/li>\n<li>FLOAT [(p)]\n<ul>\n<li><b>Description:<\/b>A subtype of the NUMBER datatype having precision p. A FLOAT value is represented internally as NUMBER. The precision p can range from 1 to 126 in binary digits. A FLOAT value requires from 1 to 22 bytes.<\/li>\n<li><b>ISO synonym:<\/b> float<\/li>\n<li><b>SQL Server:<\/b> float[(p)], if p>53, then convert to float.<\/li>\n<\/ul>\n<\/li>\n<li>BINARY_FLOAT\n<ul>\n<li><b>Description:<\/b>32-bit floating point number. This datatype requires 5 bytes, including the length byte.<\/li>\n<li><b>ISO synonym:<\/b> real <\/li>\n<li><b>SQL Server:<\/b> float(24) <\/li>\n<\/ul>\n<\/li>\n<li>BINARY_DOUBLE\n<ul>\n<li><b>Description:<\/b>64-bit floating point number. This datatype requires 9 bytes, including the length byte.<\/li>\n<li><b>ISO synonym:<\/b> double precision<\/li>\n<li><b>SQL Server:<\/b> float(53)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h3> <span>bulit-in datatypes: Datetime and Interval Datatypes <\/span><\/h3>\n<ul>\n<li>date\n<ul>\n<li><b>Description:<\/b>stores date and time information. Although date and time information can be represented in both character and number datatypes, the DATE datatype has special associated properties. For each DATE value, Oracle stores the following information: century, year, month, date, hour, minute, and second.\n\t<\/li>\n<li><b>ISO synonym:<\/b> N\/A<\/li>\n<li><b>SQL Server:<\/b> DATETIME <\/li>\n<\/ul>\n<\/li>\n<li>timestamp[(fractional_seconds_precision)], 0<= fractional_seconds_precision <=9\n  \n\n<ul>\n<li><b>Description:<\/b>The TIMESTAMP datatype is an extension of the DATE datatype. It stores the year, month, and day of the DATE datatype, plus hour, minute, and second values. This datatype is useful for storing precise time values.\n\t<\/li>\n<li><b>ISO synonym:<\/b> N\/A<\/li>\n<li><b>SQL Server:<\/b> DATETIME <\/li>\n<\/ul>\n<\/li>\n<li>timestamp[(fractional_seconds_precision)] with time zone, 0<= fractional_seconds_precision <=9\n  \n\n<ul>\n<li><b>Description:<\/b>a variant of TIMESTAMP that includes a time zone region name or a a time zone offset in its value. The time zone offset is the difference (in hours and minutes) between local time and UTC (Coordinated Universal Time\u2014formerly Greenwich Mean Time). This datatype is useful for collecting and evaluating date information across geographic regions.\n\t<\/li>\n<li><b>ISO synonym:<\/b> N\/A<\/li>\n<li><b>SQL Server:<\/b>VARCHAR(37), fetched from <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ms151817.aspx\">this article<\/a> <\/li>\n<\/ul>\n<\/li>\n<li>timestamp[(fractional_seconds_precision)] with local time zone, 0<= fractional_seconds_precision <=9\n  \n\n<ul>\n<li><b>Description:<\/b>is another variant of TIMESTAMP that includes a time zone offset in its value. It differs from TIMESTAMP WITH TIME ZONE in that data stored in the database is normalized to the database time zone, and the time zone offset is not stored as part of the column data. When a user retrieves the data, Oracle returns it in the user&#8217;s local session time zone. The time zone offset is the difference (in hours and minutes) between local time and UTC (Coordinated Universal Time\u2014formerly Greenwich Mean Time). This datatype is useful for displaying date information in the time zone of the client system in a two-tier application.\n\t<\/li>\n<li><b>ISO synonym:<\/b> N\/A<\/li>\n<li><b>SQL Server:<\/b>VARCHAR(37) <\/li>\n<\/ul>\n<\/li>\n<li>INTERVAL YEAR [(year_precision)] TO MONTH, 0<= year_precision <=9, default is 2.\n  \n\n<ul>\n<li><b>Description:<\/b>stores a period of time using the YEAR and MONTH datetime fields. This datatype is useful for representing the difference between two datetime values when only the year and month values are significant.\n\t<\/li>\n<li><b>ISO synonym:<\/b>N\/A<\/li>\n<li><b>SQL Server:<\/b>N\/A<\/li>\n<\/ul>\n<\/li>\n<li>INTERVAL DAY [(day_precision)] TO SECOND [(fractional_seconds_precision)] , 0<= day_precision <=9, default is 2. 0<= fractional_seconds_precision <=9,default is 6.\n  \n\n<ul>\n<li><b>Description:<\/b>stores a period of time in terms of days, hours, minutes, and seconds. This datatype is useful for representing the precise difference between two datetime values.\n\t<\/li>\n<li><b>ISO synonym:<\/b>N\/A<\/li>\n<li><b>SQL Server:<\/b>N\/A<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h2 class=\"pagetitle\">ANSI SQL datatypes<\/h2>\n<p>SQL statements that create tables and clusters can also use ANSI SQL datatypes. Oracle recognizes the ANSI SQL datatype name that differs from the Oracle Database datatype name. It converts the datatype to the equivalent Oracle datatype, records the Oracle datatype as the name of the column datatype, and stores the column data in the Oracle datatype based on the conversions shown in the table that follow.<\/p>\n<div id=\"comparet\">\n<table summary=\"ANSI SQL Datatypes converted to Oracle datatypes\">\n<caption>ANSI SQL Datatypes converted to Oracle datatypes<\/caption>\n<thead>\n<tr class=\"odd\">\n<td scope=\"col\" abbr=\"Home\">ANSI SQL Datetype<\/td>\n<td scope=\"col\" abbr=\"Home\">Oracle data type<\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>character(n)<\/td>\n<td>char(n)<\/td>\n<\/tr>\n<tr class=\"odd\">\n<td>char(n)<\/td>\n<td>char(n)<\/td>\n<\/tr>\n<tr>\n<td>character varying(n)<\/td>\n<td>varchar2(n)<\/td>\n<\/tr>\n<tr class=\"odd\">\n<td>char varying(n)<\/td>\n<td>varchar2(n)<\/td>\n<\/tr>\n<tr>\n<td>national character(n)<\/td>\n<td>nchar(n)<\/td>\n<\/tr>\n<tr class=\"odd\">\n<td>national char(n)<\/td>\n<td>nchar(n)<\/td>\n<\/tr>\n<tr>\n<td>nchar(n)<\/td>\n<td>nchar(n)<\/td>\n<\/tr>\n<tr class=\"odd\">\n<td>national character varying(n)<\/td>\n<td>nvarchar2(n)<\/td>\n<\/tr>\n<tr>\n<td>national char varying(n)<\/td>\n<td>nvarchar2(n)<\/td>\n<\/tr>\n<tr class=\"odd\">\n<td>nchar varying(n)<\/td>\n<td>nvarchar2(n)<\/td>\n<\/tr>\n<tr>\n<td>numberic[(p,s)]<\/td>\n<td>number(p,s)<\/td>\n<\/tr>\n<tr class=\"odd\">\n<td>decimal[(p,s)]<\/td>\n<td>number(p,s)<\/td>\n<\/tr>\n<tr>\n<td>integer<\/td>\n<td>number(38)<\/td>\n<\/tr>\n<tr class=\"odd\">\n<td>int<\/td>\n<td>number(38)<\/td>\n<\/tr>\n<tr>\n<td>smallint<\/td>\n<td>number(38)<\/td>\n<\/tr>\n<tr class=\"odd\">\n<td>float<\/td>\n<td>float(126)<\/td>\n<\/tr>\n<tr>\n<td>double precision<\/td>\n<td>float(126)<\/td>\n<\/tr>\n<tr class=\"odd\">\n<td>real<\/td>\n<td>float(63)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<h3> <span>References:<\/span><\/h3>\n<ul>\n<li>\n<a href=\"http:\/\/download.oracle.com\/docs\/cd\/B28359_01\/server.111\/b28286\/sql_elements001.htm#i54330\">Oracle datatypes<\/a>\n<\/li>\n<li>\n<a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ms151817.aspx\">Oracle datatypes to SQL Server<\/a>\n<\/li>\n<li>\n<a href=\"http:\/\/download.oracle.com\/docs\/cd\/B19306_01\/gateways.102\/b14270\/apa.htm\">Microsoft SQL Server data types to Oracle data types<\/a>\n<\/li>\n<li>\nOracle: <a href=\"http:\/\/www.ixora.com.au\/notes\/number_representation.htm\">Internal representation of the NUMBER datatype<\/a>\n<\/li>\n<li>\n<a href=\"http:\/\/download.oracle.com\/docs\/cd\/B10500_01\/appdev.920\/a96584\/oci03typ.htm\">Internal representation of Number datatype in Oracle document<\/a>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Datatype conversion is one of the key issues when convert one dialect of SQL to another. This article documents Oracle datatypes and how to convert it to corresponding datatype of other databases. Oracle Database provides a number of built-in datatypes as well as several categories for user-defined types that can be used as datatypes. A datatype is either scalar or nonscalar. A scalar type contains an atomic value, whereas a nonscalar (sometimes called a &#8220;collection&#8221;) contains a set of values. A large object (LOB) is a special form of scalar datatype representing a large scalar value of binary or character\u2026<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":401,"menu_order":10,"comment_status":"closed","ping_status":"open","template":"gsp_sql_translate_tt.php","meta":[],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":5}},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Help you to make better use of General SQL Parser<\/title>\n<meta name=\"description\" content=\"oracle datatypes\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dpriver.com\/blog\/list-of-demos-illustrate-how-to-use-general-sql-parser\/translate-sql-query-between-different-databases\/oracle-datatypes\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Help you to make better use of General SQL Parser\" \/>\n<meta property=\"og:description\" content=\"oracle datatypes\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dpriver.com\/blog\/list-of-demos-illustrate-how-to-use-general-sql-parser\/translate-sql-query-between-different-databases\/oracle-datatypes\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL and Data Blog\" \/>\n<meta property=\"article:modified_time\" content=\"2018-01-13T04:17:25+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#organization\",\"name\":\"SQL and Data Blog\",\"url\":\"https:\/\/www.dpriver.com\/blog\/\",\"sameAs\":[],\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/07\/sqlpp-character.png\",\"contentUrl\":\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/07\/sqlpp-character.png\",\"width\":251,\"height\":72,\"caption\":\"SQL and Data Blog\"},\"image\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#website\",\"url\":\"https:\/\/www.dpriver.com\/blog\/\",\"name\":\"SQL and Data Blog\",\"description\":\"SQL related blog for database professional\",\"publisher\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dpriver.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/list-of-demos-illustrate-how-to-use-general-sql-parser\/translate-sql-query-between-different-databases\/oracle-datatypes\/\",\"url\":\"https:\/\/www.dpriver.com\/blog\/list-of-demos-illustrate-how-to-use-general-sql-parser\/translate-sql-query-between-different-databases\/oracle-datatypes\/\",\"name\":\"Help you to make better use of General SQL Parser\",\"isPartOf\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#website\"},\"datePublished\":\"2010-07-28T02:10:00+00:00\",\"dateModified\":\"2018-01-13T04:17:25+00:00\",\"description\":\"oracle datatypes\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/list-of-demos-illustrate-how-to-use-general-sql-parser\/translate-sql-query-between-different-databases\/oracle-datatypes\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dpriver.com\/blog\/list-of-demos-illustrate-how-to-use-general-sql-parser\/translate-sql-query-between-different-databases\/oracle-datatypes\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/list-of-demos-illustrate-how-to-use-general-sql-parser\/translate-sql-query-between-different-databases\/oracle-datatypes\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.dpriver.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"List of demos illustrate how to use general sql parser\",\"item\":\"https:\/\/www.dpriver.com\/blog\/list-of-demos-illustrate-how-to-use-general-sql-parser\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Translate SQL query between different databases\",\"item\":\"https:\/\/www.dpriver.com\/blog\/list-of-demos-illustrate-how-to-use-general-sql-parser\/translate-sql-query-between-different-databases\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"oracle datatypes\"}]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Help you to make better use of General SQL Parser","description":"oracle datatypes","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dpriver.com\/blog\/list-of-demos-illustrate-how-to-use-general-sql-parser\/translate-sql-query-between-different-databases\/oracle-datatypes\/","og_locale":"en_US","og_type":"article","og_title":"Help you to make better use of General SQL Parser","og_description":"oracle datatypes","og_url":"https:\/\/www.dpriver.com\/blog\/list-of-demos-illustrate-how-to-use-general-sql-parser\/translate-sql-query-between-different-databases\/oracle-datatypes\/","og_site_name":"SQL and Data Blog","article_modified_time":"2018-01-13T04:17:25+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/www.dpriver.com\/blog\/#organization","name":"SQL and Data Blog","url":"https:\/\/www.dpriver.com\/blog\/","sameAs":[],"logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/07\/sqlpp-character.png","contentUrl":"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/07\/sqlpp-character.png","width":251,"height":72,"caption":"SQL and Data Blog"},"image":{"@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"WebSite","@id":"https:\/\/www.dpriver.com\/blog\/#website","url":"https:\/\/www.dpriver.com\/blog\/","name":"SQL and Data Blog","description":"SQL related blog for database professional","publisher":{"@id":"https:\/\/www.dpriver.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dpriver.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.dpriver.com\/blog\/list-of-demos-illustrate-how-to-use-general-sql-parser\/translate-sql-query-between-different-databases\/oracle-datatypes\/","url":"https:\/\/www.dpriver.com\/blog\/list-of-demos-illustrate-how-to-use-general-sql-parser\/translate-sql-query-between-different-databases\/oracle-datatypes\/","name":"Help you to make better use of General SQL Parser","isPartOf":{"@id":"https:\/\/www.dpriver.com\/blog\/#website"},"datePublished":"2010-07-28T02:10:00+00:00","dateModified":"2018-01-13T04:17:25+00:00","description":"oracle datatypes","breadcrumb":{"@id":"https:\/\/www.dpriver.com\/blog\/list-of-demos-illustrate-how-to-use-general-sql-parser\/translate-sql-query-between-different-databases\/oracle-datatypes\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dpriver.com\/blog\/list-of-demos-illustrate-how-to-use-general-sql-parser\/translate-sql-query-between-different-databases\/oracle-datatypes\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dpriver.com\/blog\/list-of-demos-illustrate-how-to-use-general-sql-parser\/translate-sql-query-between-different-databases\/oracle-datatypes\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dpriver.com\/blog\/"},{"@type":"ListItem","position":2,"name":"List of demos illustrate how to use general sql parser","item":"https:\/\/www.dpriver.com\/blog\/list-of-demos-illustrate-how-to-use-general-sql-parser\/"},{"@type":"ListItem","position":3,"name":"Translate SQL query between different databases","item":"https:\/\/www.dpriver.com\/blog\/list-of-demos-illustrate-how-to-use-general-sql-parser\/translate-sql-query-between-different-databases\/"},{"@type":"ListItem","position":4,"name":"oracle datatypes"}]}]}},"_links":{"self":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/pages\/416"}],"collection":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/comments?post=416"}],"version-history":[{"count":53,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/pages\/416\/revisions"}],"predecessor-version":[{"id":1743,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/pages\/416\/revisions\/1743"}],"up":[{"embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/pages\/401"}],"wp:attachment":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/media?parent=416"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}