Oracle vs SQL Server Datatype Mapping


SQL Server Data Type       Oracle Data Type

VARCHAR                    VARCHAR2

MONEY                      NUMBER(19,4)

BIT                        NUMBER(1,0)

IMAGE                      BLOB

SYSNAME                    VARCHAR2(128)

VARCHAR(MAX)               CLOB

DATETIME                   TIMESTAMP(3)

DECIMAL                    NUMBER

TINYINT                    NUMBER(3,0)

FLOAT                      NUMBER

CHAR                       CHAR

UNIQUEIDENTIFIER           CHAR(36)

BIGINT                     NUMBER(10,0)

INT                        NUMBER(10,0)

NUMBERIC                   NUMBER

NVARCHAR(MAX)              NCLOB

SMALLMONEY                 NUMBER(10,4)

NVARCHAR                   NVARCHAR2

TEXT                       CLOB
 

Comments

Post a Comment

Popular posts from this blog

C# code to Check IE Proxy Settings

private static void CheckIEProxySettings() {     string strFileURL = " http://programmersvision.blogspot.in ";     HttpWebRequest WebReqt = (HttpWebRequest)HttpWebRequest.Create(strFileURL);     WebProxy WP = new WebProxy(WebReqt.Proxy.GetProxy(new Uri(strFileURL)));     WP.Credentials = CredentialCache.DefaultCredentials;     Console.WriteLine(WP.Address);     // or use this method     //CheckForProxy(new Uri(" http://http://programmersvision.blogspot.in ")); } private static void CheckForProxy(Uri resource) {     WebProxy proxy = (WebProxy)WebProxy.GetDefaultProxy();     Uri proxyUri = proxy.GetProxy(resource);     if (proxyUri == resource)     {         Console.WriteLine("There is no proxy for {0}", resource);     }     else     { ...
Read more

Convert XElement to DataTable

public DataTable XElementToDataTable(XElement x)  {    DataTable dt = new DataTable();   XElement setup = (from p in x.Descendants() select p).First();    foreach (XElement xe in setup.Descendants()) // build your DataTable      dt.Columns.Add(new DataColumn(xe.Name.ToString(),typeof(string))); // add columns to your dt   var all = from p in x.Descendants(setup.Name.ToString()) select p;    foreach (XElement xe in all)    {      DataRow dr = dt.NewRow();      foreach (XElement xe2 in xe.Descendants())        dr[xe2.Name.ToString()] = xe2.Value; //add in the values      dt.Rows.Add(dr);    }    return dt;  }
Read more