Advertisement
Guest User

Untitled

a guest
Jun 25th, 2019
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.33 KB | None | 0 0
  1. create table foo
  2. (
  3. bar number(19,6)
  4. )
  5. ;
  6.  
  7. create view baz
  8. as
  9. select bar from foo
  10. ;
  11.  
  12. select
  13. *
  14. from all_tab_columns
  15. where table_name in ('FOO', 'BAZ')
  16. ;
  17.  
  18. OWNER,TABLE_NAME,COLUMN_NAME,DATA_TYPE,DATA_TYPE_MOD,DATA_TYPE_OWNER,DATA_LENGTH,DATA_PRECISION,DATA_SCALE
  19. LD_PRICING,BAZ,BAR,NUMBER,,,22,19,6
  20. LD_PRICING,FOO,BAR,NUMBER,,,22,19,6
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement