PPM命令的解释
E:\>ppm
PPM interactive shell (2.1.1) - type 'help' for available commands.
PPM> help
Commands:
exit - leave the program.
help [command] - prints this screen, or help on 'command'.
install PACKAGES - installs specified PACKAGES.
quit - leave the program.
query [options] - query information about installed packages.
remove PACKAGES - removes the specified PACKAGES from the system.
search [options] - search information about available packages.
set [options] - set/display current options.
verify [options] - verifies current install is up to date.
version - displays PPM version number
exit --退出PPM程序
help --显示PPM帮助
install PACKAGES --安装模块,PACKAGES为模块名
quit --同exit,退出PPM程序
query [options] --查询当前已安装模块,不加参数:查询所有已安装模块
remove PACKAGES --卸载已安装模块
search [options] --查询可供安装的模块,在ActivePerl的站点上
set [options] --
verify [options] --
version --显示PPM版本号
创建新的用户:如user1/pass1,赋予connect,resource权限。
SQL> grant connect,resource to user1 identified by pass1;
SQL> conn user1/pass1
SQL> create table test(a varchar2(20),b date);
SQL> insert into test values('原有值',sysdate);
SQL> insert into test values('原有值',sysdate);
SQL> insert into test values('原有值',sysdate);
SQL> commit;
SQL> select a,to_char(b,'yyyy-mm-dd hh24:mi:ss') 日期 from test;
my $dbh = DBI->connect("dbi:Oracle:oradb", 'user1','pass1');
my $sql = qq{ insert into test values('网页生成值',sysdate)};
my $sth = $dbh->prepare( $sql );
$sth->execute();
$dbh->disconnect();