PL/SQL编程基础——PL/SQL中执行sql语句

1.select语句

SELECT expression_list INTO variable_list | record_variable
FROM table_name WHERE condition;

最重要:有且只能返回一行数据,否则报错

2.DML语句-insert,update,delete

INSERT INTO table_name[(col1, ..., coln)]
    VALUES (val1, ..., valn);
posted @ 2017-09-05 23:29  yulamont  阅读(228)  评论(0)    收藏  举报