when i ran some sql quries on sqlcommand prompt, it give me line which are not in easily readable format, is there any general thing i should set on command prompt to get the output in easily readable format, like if i need output of
SQL>select * from dba_registry; it gives me 17 rows but very hard to read, what's the general/common setting i should do for this any any other queries like that?
like for example
SQL> COLUMN profile format a12
SQL> COLUMN limit format a9
SQL> SELECT * FROM dba_profiles
where profile = <profile_name> will give me easily readable format?