serisboy的专栏

D:\oracle\ora92\bin>sqlplus /nolog SQL*Plus: Release 9.2.0.1.0 - Production on 星期四 8月 16 11:32:22 2007 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. SQL> conn /as sys...

[code="java"]create table st as(select '324' id,'黄埔' name,'220' cc from dualunion all select '325','^UP','110' from dualunion all select '326','^UP','小计' from dualunion all select '327','萝岗','...

10g download addr：[url]http://www.blogjava.net/wangdetian168/archive/2011/03/01/345428.html[/url][code="java"]sql>sqlplus /nologsql>conn /as sysdba;sql>create user admin identified by admin;...

Database、User、Schema、Tables、Col、Row等之间的关系“可以把Database看作是一个大仓库，仓库分了很多很多的房间，Schema就是其中的房间，一个Schema代表一个房间，Table可以看作是每个Schema中的床，Table（床）就被放入每个房间中，不能放置在房间之外，那岂不是晚上睡觉无家可归了。然后床上可以放置很多物品，就好比Table上可以放...

oracle中使用绑定变量的好处[code="java"]Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 Connected as scottSQL> set timing on; Executed in 0.468 seconds SQL> create table ...