[PL SQL] Basic SQL Operations

SELECT * FROM TableName WHERE calx = valx;


SELECT col1,col2,col3 INTO val1,val2,val3 FROM TableName WHERE calx = valx;


INSERT INTO TableName (col1, col2, col3) VALUES (val1, val2, val3 );


DELETE FROM TableName WHERE colx=valx;

UPDATE TableName SET col1= val1*val2 WHERE colx = (SELECT colx FROM TableNamex WHERE coly=valy)