Oracle to SQL porting [modified]
-
Hi, I am pretty new to database section. I tried porting a table created in Oracle to SQL Server 2005. In Oracle, i could see a column defined holding the user details. The column is defines as given below. CREATE_USER VARCHAR2(255 BYTE) DEFAULT USER NOT NULL My doubt is regarding default value USER. I would like to know 1) What will be the value keyword "USER" will be returning in ORACLE. Is it an in built property or function which returns the default user? 2) And the equivalent value to be used for "USER" in SQL Server 2005? Please help Thanks, Arudya
modified on Wednesday, October 27, 2010 12:01 AM
-
Hi, I am pretty new to database section. I tried porting a table created in Oracle to SQL Server 2005. In Oracle, i could see a column defined holding the user details. The column is defines as given below. CREATE_USER VARCHAR2(255 BYTE) DEFAULT USER NOT NULL My doubt is regarding default value USER. I would like to know 1) What will be the value keyword "USER" will be returning in ORACLE. Is it an in built property or function which returns the default user? 2) And the equivalent value to be used for "USER" in SQL Server 2005? Please help Thanks, Arudya
modified on Wednesday, October 27, 2010 12:01 AM
The value returned for USER will be the userid that was supplied to establish the connection. If SQL*Plus is available, login to an oracle database and try the command
select user from dual. It should return the same value as you supplied as the userid when you logged in. As for the equivalent in SQL Server, I'd suggest try googling for an equivalent. :)Chris Meech I am Canadian. [heard in a local bar] In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]