CREATE TABLE mytable
(
  ID   INTEGER                       NOT NULL,
  A    NUMBER(10)                    NOT NULL,
  B    VARCHAR2(10 BYTE)             NOT NULL,
  C    NUMBER(32,2)                  NOT NULL,
  D    DATE                          NOT NULL,
  E    INTEGER                       NOT NULL,
  F    INTEGER                       NOT NULL,
  G    INTEGER                       DEFAULT '0'
)
NOLOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;

CREATE INDEX mytable_B ON mytable
(B)
NOLOGGING
NOPARALLEL;

select ID,A,C,D from mytable where B = ?

SQL: SELECT id, a, c, d
    FROM mytable
    WHERE B = :1
Plan: 
select mytable
   Master.mytable table access (FULL)

select ID,A,C,D from mytable ORDER BY B

SELECT * from mytable

SELECT * FROM mytable ORDER BY b;