本文展示了如何使用SQL*Plus连接到Oracle数据库并执行SQL脚本。通过具体示例，演示了如何创建函数及修改配置文件的过程。
C:\Users\snoopy>sqlplus sys/lubinsu@orcl_mine as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Sat Nov 17 16:19:42 2012
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> @ E:\oracle\product\10.2.0\db_2\RDBMS\ADMIN\utlpwdmg.sql
Function created.
Profile altered.
SQL>
SQL*Plus: Release 10.2.0.4.0 - Production on Sat Nov 17 16:19:42 2012
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> @ E:\oracle\product\10.2.0\db_2\RDBMS\ADMIN\utlpwdmg.sql
Function created.
Profile altered.
SQL>
then you can see these:
扫一扫
1251
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
