Saturday, 20 February 2016

Find table size and set column size

Find table size :

 select segment_name,segment_type,bytes/1024/1024 MB
 from dba_segments
 where segment_type='TABLE' and segment_name='<yourtablename>';

Set column size :

sql>column column_name format a30
sql>set linesize 300

Cheers.

No comments:

Post a Comment

Show values in right side of shuttle

While working with select list and shuttle, when we want to display values into right side of shuttle depending upon selection from select ...