Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: 10g Raw DataType
Rafael tejera wrote:
> I'm trying to move my Mssql database to oracle. I had read that Raw database
> is the equivalent of uniqueidentifier (GUID), but I do not see it in 10g
> express Edition.
>
> There is any other equivalent or any other way to do it.
>
>
> Sincerely,
>
>
>
> Rafael
CREATE TABLE t (
rid RAW(32),
col VARCHAR2(20));
desc t
INSERT INTO t
(rid, col)
VALUES
(SYS_GUID(), 'ABC');
INSERT INTO t
(rid, col)
VALUES
(SYS_GUID(), 'DEF');
SELECT * FROM t;
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Fri Nov 30 2007 - 11:37:42 CST