Happy Coding
11 May 2012
Merge in Oracle
MERGE INTO TBL_MenU b
USING (
SELECT TRANNAME,TRANID
FROM TBL_TRANS
) e
ON (b.MenuTEXT = e.TRANNAME)
WHEN MATCHED THEN
UPDATE SET b.MENUURL = CONCAT( 'GuideMain.aspx?TransId=', e.TRANID)
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
SSRS: Configure User Authentication with ReportCredentials
No comments:
Post a Comment