帮忙看看，我要怎么在这条sql插入数据，谢谢各路大神了。

[qq_40760930]

SELECT a.agreement_code AS SOURCE_ID, (
SELECT x.org_name
FROM organization x, system_user y,system_user_post sp
WHERE y.sys_user_id = a.oper_id
AND y.sys_user_id = sp.sys_user_id
AND sp.org_id = x.org_id
AND x.lan_id = a.lan_id
) AS JSBSS_APPLYDEPTCODE, a.sign_person AS JSBSS_USERID, a.oper_phone AS JSBSS_USERTEL, (
SELECT xx.agreement_undertaker_org_code
FROM agreement_undertaker_org xx
WHERE xx.agreement_undertaker_org_id = b.agreement_undertaker_org
) AS APPLYDEPTCODE
, (
SELECT yy.agreement_undertaker_code
FROM agreement_undertaker yy
WHERE yy.agreement_undertaker_id = b.agreement_undertaker_id
) AS APPLYUSERID, a.lan_id AS BSS_APPLYRANGE, a.cust_id AS JSBSS_CUSTOMCODE, a.agreement_name AS CONTRACTNAME, to_char(a.accept_end_time, 'yyyy-mm-dd') AS THEORYPAYDATE_DAYS
, a.cust_name AS PARTBNAME, a.cust_name AS MANUNAME, a.sign_place AS CONSADDR, to_char(a.accept_begin_time, 'yyyy-mm-dd') AS SIGNDATE, to_char(a.accept_end_time, 'yyyy-mm-dd') AS ENDDATE
, (
SELECT aa.param_val
FROM dc_system_param aa
WHERE aa.param_code = 'URL_FOR_MSS_AGREEMENT'
)
|| 'servlet/GetAgreeInfoForMssServlet?msg_id='
|| nvl(b.msg_id, 'X108')
|| '&'
|| 'agreement_id='
|| a.agreement_id AS URL, b.msg_id AS MSGID, 'A018' AS PARTATYPE, 'contractfiles_162' AS Type, a.agreement_name
|| '.doc' AS name
, a.agreement_text, (
SELECT aa.mss_name
FROM agreement_mss aa
WHERE aa.mss_id = b.agreement_mss_name
) AS PARTANAME, a.agreement_id
FROM agreement a, agreement_mss_info b
WHERE
state = 'D'
AND agreement_kind = '15'
AND
a.agreement_id = b.agreement_id






并且agreement这个算是主表吧？里边是有字段的，我单独查的时候，就算没有数据，为什么连字段都不给我显示的？


请求各路大神了，我现在需要数据做测试，但是不知怎么插入数据，我是新手，以下是我要插入数据后做判断要修改的sql:

String lockSql="update agreement a set a.state=? where a.agreement_id=?";

[qq_31991873]

这是通过查询了返回结果拼接到servlet吗，好长啊，你可以看看这几个表是什么数据；
你开的是个测试窗口。。你应该开个sql窗口。。这样就能查到agreement的值

[嶶風]

如果做测试数据的话可以用pl/sql 菜单 tools里的 data generator... 工具，然后选择好你的owner 和 table