Creating First table

CREATE TABLE DG_1
(
DG_NUMBER1 NUMBER,
DG_CHAR1 VARCHAR2(10 BYTE),
DG_NUMBER2 NUMBER,
DG_CHAR2 VARCHAR2(10 BYTE)
)
TABLESPACE USERS
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING;

-----
So we have first table ready DG_1 with four columns. The table does not has any value , and can be altered as desired.
Table can be made and data insertesd with different IDE available

My First Encounter with PL/SQL

My first encounter with PL/SQl was a long time ago. I was to run a few batch processes in the project then. Since then i have been associated of more Pl/Sql assignments.
Now when we start working on PL/SQL , is definitely not easy for the starters.
Here is what i have some SQL queries and how to change them to PL-SQL and like syntax.
Please this is what i learn , and all here are examples i used to learn.
there is nothing which i have taken from any project i have worked on. Its just an understanding of concepts and mistakes i have learned from Projects, and how to get out of them