Legal | Privacy
drop table TypesTab;

create table TypesTab(
	num number, 
	bfloat binary_float, 
	bdouble binary_double, 
	vchar2 varchar2(24), 
	xchar char(24), 
	xraw raw(24), 
	xdat date);
	
insert into TypesTab values (
	111, 
	10000000.000001,
	1000000000000.000000002, 
 	'this is a varchar2', 
	'this is a char', 
	hextoraw (lpad ('b', 24, 'b')), 
	'19-Apr-2005');
commit;
select * from TypesTab;
E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy