往表ONLINESTATE 插入一条数据,其中 ONLINESTATE."userName" 需要从USEID 表查询出的结果,ONLINESTATE."OnLine"字段和ONLINESTATE."hostIP" 字段是需要手动录入的值
INSERT INTO ONLINESTATE (
ONLINESTATE."userName",ONLINESTATE."loginTime",
ONLINESTATE."heartbeat",
ONLINESTATE."OnLine",
ONLINESTATE."hostIP"
) SELECT
USEID."USE",
TO_CHAR (SYSDATE, 'yyyymmddhh24miss'),
TO_CHAR (SYSDATE,'yyyy-mm-dd hh24:mi:ss'),
1,
'192.168.2.114'
FROM
USEID
WHERE
USEID."USE" = 'gys'