SQLplus basics

Several useful commands.

Basic Retrieval from single table
SELECT [DISTINCT] display_fields
FROM tables
WHERE field_conditions
ORDER BY field_name [ASC | DESC];

e.g: select * from MethodParameter;
e.g: select * from MethodParameter where NAME=DUNHAM;

Delete the whole content of table
DROP TABLE tablename;

e.g: drop table MethodParameter;

Delete one or more records from a table
DELETE FROM table_name
WHERE record_retrieval_conditions;

e.g: delete from MethodParameter where NAME='DUNHAM BUSH';


Popular posts from this blog

HIVE: Both Left and Right Aliases Encountered in Join

Assign select result to variable in Netezza stored procedure

Splitting value in Netezza using array_split