摘要:
参考Oracle Database 9i/10g/11g编程艺术一书:login.sql代码如下:define _editor=viset serveroutput on size 1000000set trimspool onset long 5000set linesize 700set pagesize 9999column plan_plus_exp format a80column global_name new_value gnameset termout offdefine gname=idlecolumn global_name new_value gnameselect lo 阅读全文
摘要:
Oracle Database 9i/10g/11g编程艺术:深入数据库体系结构(第2版)中演示例子在Scott模式中进行。scott用户登录数据库:C:\>sqlplus scott/tiger@orcl执行demobld.sql文件:SQL> @d:\demobld.sqldemobld.sql文件放在D盘根目录,内容如下:---- Copyright (c) Oracle Corporation 1988, 1999. All Rights Reserved.---- NAME-- demobld.sql---- DESCRIPTION-- This script crea. 阅读全文
摘要:
SQL> conn / as sysdba; --DBA登录SQL> alter user scott account unlock; --解锁SQL> conn scott/tiger;......提示修改新密码SQL> conn scott/xxx; --新密码登录已连接。 阅读全文