oracle查询命令讲述.docx

1.create user username identified by password;//建用户名和密码oracle ,oracle 2.grant connect,resource,dba to username;//授权 grant connect,resource,dba,sysdba to username; 3.connect username/password//进入。4.select table_name,column_name from user_tab_columns where table_name=mview_log;//查询表中的表名，字段名等等。5. 如何执行脚本SQL文件? SQL@PATH/filename.sql; 6.Oracle oledb 提供者在command中执行多条SQL语句与SQL SERVER有少许差别,SQL Server只需使用;分割多条SQL语句,而Oracle需要遵守ORACLE调用规范,即除分号分割外,还需以begin /end;包围语句体. 使用C#描述应如下所示: this.oleDbCommand1.CommandText = begin INSERT INTO GROUP_INFO (GROUP_ID, GROUP_NAME) VALUES (1, \2\); INSERT INTO GROUP_INFO(GR