SELECT x.org _name
The FROM organization x, y system_user, system_user_post sp
WHERE y.s ys_user_id=a.o per_id
AND y.s ys_user_id=sp. Sys_user_id
_id _id=x.org AND sp.org
AND x.l an_id=a. an_id
) AS JSBSS_APPLYDEPTCODE, a.s ign_person AS JSBSS_USERID, a.o per_phone AS JSBSS_USERTEL, (
The SELECT xx. Agreement_undertaker_org_code
The FROM xx
agreement_undertaker_orgWHERE xx. Agreement_undertaker_org_id=b.a greement_undertaker_org
) AS APPLYDEPTCODE
, (
SELECT yy. Agreement_undertaker_code
The FROM agreement_undertaker yy
WHERE yy. Agreement_undertaker_id=b.a greement_undertaker_id
) AS APPLYUSERID, a. an_id AS BSS_APPLYRANGE, a.c ust_id AS JSBSS_CUSTOMCODE, a.a greement_name AS CONTRACTNAME, to_char (a.a ccept_end_time, '- dd yyyy - mm) AS THEORYPAYDATE_DAYS
, a.c ust_name AS PARTBNAME, a.c ust_name AS MANUNAME, a.s ign_place AS CONSADDR, to_char (a.a ccept_begin_time, '- dd yyyy - mm) AS SIGNDATE, to_char (a.a ccept_end_time,' - dd yyyy - mm) AS ENDDATE
, (
The SELECT aa. Param_val
The FROM dc_system_param aa
WHERE aa. Param_code='URL_FOR_MSS_AGREEMENT'
)
| | 'servlet/GetAgreeInfoForMssServlet? Msg_id='
| | NVL (b.m sg_id, 'X108')
| | '& amp; amp; '
| | 'agreement_id='
| | a.a greement_id AS URL, b.m sg_id AS MSGID, 'A018 AS PARTATYPE,' contractfiles_162 'AS the Type, a.a greement_name
| | 'doc' AS the name
, a.a greement_text, (
The SELECT aa. Mss_name
The FROM agreement_mss aa
WHERE aa. Mss_id=b.a greement_mss_name
) AS PARTANAME, a.a greement_id
The FROM agreement a, agreement_mss_info b
WHERE
State='D'
AND agreement_kind='15'
AND
A.a greement_id=b.a greement_id
And agreement this is the main table? Inside is a field that I check when alone, even if there is no data, why don't even give me show field?
Requests each great god, I now need to do the test data, but do not know how to insert the data, I am a novice, here is I want to do after inserting data judge to modify SQL:
String lockSql="update agreement a set a.s Tate=? Where a.a greement_id=?" ;
CodePudding user response:
This is done through the query returns the result spliced into a servlet, good long ah, you can see what is this a few table data;You open a window, you should open a window, SQL, so you can look up to the value of the agreement
CodePudding user response:
If you do the test data can use pl/SQL data in the tools menu generator... Tools, and then select your owner, and the table