xxxxxxxxxx
create table bricks (
brick_id number(20, 0),
colour varchar2(10),
price number(10, 2),
purchased_date date
);
select column_name, data_type, data_length, data_precision, data_scale
from user_tab_columns
where table_name = 'BRICKS';
xxxxxxxxxx
mysql> select data_type from information_schema.columns where table_schema = 'business' and able_name = 'DataTypeDemo';