Oracle script

Hello Oracle experts;

In Oracle RDB you have commends like:

SQL> attach 'filename stl_rdb';
SQL> sho tables
User tables in database with filename stl_rdb
     BIN_INVENTORY
     CASTER
     CHARGE_MATERIAL
     CREW
     
and

SQL> sho table scrap_weights
Information for table SCRAP_WEIGHTS
 
Comment on table SCRAP_WEIGHTS:
Scrap charge information for this heat.
 
Columns for table SCRAP_WEIGHTS:
Column Name                     Data Type        Domain
-----------                     ---------        ------
HEAT_ID                         CHAR(5)          HEAT_ID
 Oracle Rdb default: ' '
MATERIAL_NAME                   CHAR(16)         MATERIAL_NAME
 Oracle Rdb default: ' '
SORT_ORDER                      INTEGER          SORT_ORDER
 Oracle Rdb default: 0
STD_WT                          REAL             STD_WT
 Oracle Rdb default: -123456789012345678.0
MAN_DMND_WT                     REAL             MAN_DMND_WT
 Oracle Rdb default: -123456789012345678.0
CALC_DMND_WT                    REAL             CALC_DMND_WT
 Oracle Rdb default: -123456789012345678.0
ORIG_LOG_WT                     REAL             ORIG_LOG_WT
 Oracle Rdb default: -123456789012345678.0
CHRGD_MAN_LOG_WT                REAL             CHRGD_MAN_LOG_WT
 Oracle Rdb default: -123456789012345678.0
CHRGD_RS_LOG_WT                 REAL             CHRGD_RS_LOG_WT
 Oracle Rdb default: -123456789012345678.0
CHRGD_COMP_LOG_WT               REAL             CHRGD_COMP_LOG_WT
 Oracle Rdb default: -123456789012345678.0
TIME_STAMP                      DATE VMS         TIME_STAMP
 Oracle Rdb default: CURRENT_TIMESTAMP
ORIG_CALC_DMND_WT               REAL             CALC_DMND_WT
 Oracle Rdb default: -123456789012345678.0
 
Table constraints for SCRAP_WEIGHTS:
 No Constraints found
 
Constraints referencing table SCRAP_WEIGHTS:
 No Constraints found
 
Indexes on table SCRAP_WEIGHTS:
SCRAP_WEIGHTS_KEY               with column HEAT_ID
                                and column MATERIAL_NAME
  No Duplicates allowed
  Type is Sorted
  Key suffix compression is DISABLED
  Node size  610
  Percent fill  90
 Store clause:          STORE IN SCRAP_WEIG_IDX
           (THRESHOLDS ARE ( 68,  68,  68 ))
 
 Partition information for index:
  Partition: (1) SYS_P00077
   Storage Area: SCRAP_WEIG_IDX
         Thresholds are (68, 68, 68)
 
Storage Map for table SCRAP_WEIGHTS:
     SCRAP_WEIG_MAP
 
Triggers on table SCRAP_WEIGHTS:
No triggers found
 
SQL>

My question to you today is there a simple query in Oracle that will give you the same information as

SQL> sho table scrap_weights
and
SQL> sho tables

Can you please get back to me I need this ASAP

Thank you so much for your time