Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create table foo
- (
- bar number(19,6)
- )
- ;
- create view baz
- as
- select bar from foo
- ;
- select
- *
- from all_tab_columns
- where table_name in ('FOO', 'BAZ')
- ;
- OWNER,TABLE_NAME,COLUMN_NAME,DATA_TYPE,DATA_TYPE_MOD,DATA_TYPE_OWNER,DATA_LENGTH,DATA_PRECISION,DATA_SCALE
- LD_PRICING,BAZ,BAR,NUMBER,,,22,19,6
- LD_PRICING,FOO,BAR,NUMBER,,,22,19,6
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement