Using the Define Command : define « SQL Plus « Oracle PL / SQL






  1. Oracle PL / SQL
  2. SQL Plus
  3. define

Using the Define Command

   

col segment_name for a27
define owner = '&1'
select segment_name,segment_type,extents from dba_segments where owner = upper ('&owner)
and extents > 10 and segment_name not like 'TMP%'
order by segment_type,extetns desc

@extents.sql








Related examples in the same category

1.show define
2.Check pre-defined variables