#!/usr/local/bin/perl use DBI; $dbh=DBI->connect('dbi:Oracle:host=IP地址;sid=ORASID','用户/密码','')|| die('cann't connect to database'); $date=$dbh->prepare("select to_char(sysdate,'YYYYMMDD') from dual"); $date->execute(); while (@row=$date->fetchrow_array) { printf("$row[0] "); } $dbh->disconnect;