SQL Commands

Question 1

How do you add columns to a table?

Answer 1

ALTER TABLE dummy_table ADD dummy_column varchar2(100)

varchar2(100) is just to set the data type and character count.

Question 2

How do you insert records.

Answer 2

INSERT INTO dummy_table VALUES (‘x’, ‘y’, ‘z’)