Select column name from table sql oracle

Hope this will help:-

SELECT * FROM
all_tab_cols where table_name ='Table Name'

Toad error - Can't initialize OCI. Error -1

If the toad gives error ensure that you have installed 32 bit oracle client instead of 64 bit.

Regards,
Amit Kurchania

How to find database size oracle

select round(sum(used.bytes) / 1024 / 1024 / 1024 ) ' GB' "Database Size"
, round(sum(used.bytes) / 1024 / 1024 / 1024 ) -
round(free.p / 1024 / 1024 / 1024) ' GB' "Used space"
, round(free.p / 1024 / 1024 / 1024) ' GB' "Free space"
from (select bytes
from v$datafile
union all
select bytes
from v$tempfile
union all
select bytes
from v$log) used
, (select sum(bytes) as p
from dba_free_space) free
group by free.p