PL/SQL Table, Row (테이블,데이터) 지우기

Oracle 11g PL/SQL 에서

테이블 내용(ROW)를 전부지우는법입니다.

DELETE FROM table_name;

생성된 테이블 자체을 지우는 방법입니다.

DROP TABLE table_name;
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s