oracle issue
Yes, sure ! You must be the local admin of this computer, and not a domain user.
Moreover, I'm afraid you cannot install it in a domain, maybe you should (just for testing purposes) try to install a standalone Windows system and try installing Oracle 10g on it.
You know, a RDBMS database server must be installed on a server system. You can cheat, installing it on a standalone Windows system, the standalone system emulating a server. But I'm even not sure you can install it on a client machine. Oracle server is traditionally installed on server systems, and Oracle client is installed on client system.
Please, keep us informed, if you were successful loggin on your own system as localsystem administrator, and if you were then able to correctly install Oracle.
If not, I strongly suggest you to restart everything from scratch (even on an old machine) just for learning purposes. After installing on a brand new Windows standalone system, you will feel more confident for installing it on your client system.
Regards
Yordan
相关文档：
修改列属性
alter table tablename modify(name ,varchar2(10)) 列宽度不得小于修改前的宽度
日志管理
视图 v$logfile
alter database add logfile 'd:\orcl01.log' size 10m;//添加组
alter database add logfile member 'd:\orcl02.log' to group 4;//向4组中添加成员
alter database drop logfile member 'd: ......
一、 常用日期数据格式
1.Y或YY或YYY 年的最后一位，两位或三位
SQL> Select to_char(sysdate,'Y') from dual;
TO_CHAR(SYSDATE,'Y')
--------------------
7
SQL> Select to_char(sysdate,'YY') from dual;
TO_CHAR(SYSDATE,'YY')
---------------------
07
SQL> Select to_char(sysdate,'YYY') from ......
第一个bug fix 用到 Oracle的Update语句
update Table1 set Web=-1 where ProgID=N‘123’
CodeReview 时
Do we need a COMMIT; in the Oracle version?
上网查了一下Oracle COMMIT用法
COMMIT
Purpose
Use the COMMIT statement to end your current transaction and make permanent all changes ......
查看锁表进程SQL语句1：
select sess.sid,
sess.serial#,
lo.oracle_username,
lo.os_user_name,
ao.object_name,
lo.locked_mode
from v$locked_object lo,
dba_ ......
要创建两个文件
1: runBatch.bat
2: sql.txt
runBatch.bat 内容如下：
sqlplus username/password @sql.txt
pause
sql.txt内容如下：
spool sql.log
create table t1(cname char(20));
insert into t1(cname) values('test');
select * from t1;
spool off
exit
双击runBatch.bat就可以批量执行sql.txt中 ......
