function gen_uuid
{
sqlplus -S -L /nolog<<EOF
connect $DB_UNAME/$DB_PWD@$DB_SID
spool $TMP_PATH/uuid.txt;
set termout off;
set echo off;
set feedback off;
set heading off;
set pagesize 0;
select sys_guid() uuid from dual;
spool off;
quit
EOF
uuid=`awk '/^20/{print $1}' $TMP_PATH/uuid.txt`
echo $uuid
}
linux shell生成oracle uuid
最新推荐文章于 2023-04-13 10:52:45 发布