Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how generaty automatic sys_guid

User_76ZL9May 8 2015 — edited May 8 2015

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((

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 5 2015
Added on May 8 2015
2 comments
219 views