Forum Stats

  • 3,734,267 Users
  • 2,246,934 Discussions
  • 7,857,216 Comments

Discussions

generaty automatic sys_guid

User_76ZL9
User_76ZL9 Member Posts: 60 Blue Ribbon
edited May 7, 2015 7:45AM in SQL

Hi?

I have table

create table dbusers

(id number,

guid varchar(100))

and i insert id  form 1 to 555;

insert into dbusers(id) values(1);

insert into dbusers(id) values(2);

......

insert into dbusers(id) values(555);

now i want insert for each guid column  different(unique) sys_guid

select substr(sys_guid(),0,16 )GUID from dual;

how i cant do it? it is not correct run 555 times select substr(sys_guid(),0,16 )GUID from dual; this script((

Tagged:
Sign In or Register to comment.