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
Post a Comment