sql - Insert Number values -


when inserting values database, , datatype number, number need in quotation marks:

here object code:

create type computerfile_objtyp object ( computerfileno number, comp_ref ref computer_objtyp, computerfilename varchar2(50), computerfilesize number ) / 

here insert code:

insert computerfile_objtab select 1, ref(cobj), 'c:\app1\app1.exe', 1000 computer_objtab cobj cobj.compno = 1; 

does code above work, or need this:

insert computerfile_objtab select 1, ref(cobj), 'c:\app1\app1.exe', '1000' computer_objtab cobj cobj.compno = 1; 

(i referring 'computerfilesize number' attribute)

i cannot test out database not running @ moment.

no, numbers should not put between quotes in oracle.


Comments

Popular posts from this blog

blackberry 10 - how to add multiple markers on the google map just by url? -

php - guestbook returning database data to flash -

delphi - Dynamic file type icon -