A good SQL script tutorial and advice

Question

User-1581580067 posted

Hi Everyone

I am a bit confused. What is the difference between normal SQL query, PLSQL, and Stored Procedures ? I thought I know how to write a bit of SQL query and thought it is good enough but this morning I saw a script , please see below

UPDATE [dbo].[tbl_Report] SET [Report_Binary]=0x2f2f2f203c585254797065496e666f3e0d0a2f2f2f2020203c417373656d626c7946756c6c4e616d653e446576457870726573732e587472615265706f7274732e76392e332c2056657273696f6e3d392e332e332e302c2043756c747572653d6e65757472616c2c205075626c69634b6579546f6b656e3d623838643137353464373030653439613c2f417373656d626c7946756c6c4e616d653e0d0a2f2f2f2020203c417373656d626c794c6f636174696f6e3e433a5c57696e646f77735c617373656d626c795c4741435f4d53494c5c446576457870726573732e587472615265706f7274732e76392e335c392e332e332e305f5f623838643137353464373030653439615c446576457870726573732e587472615265706f7274732e76392e332e646c6c3c2f417373656d626c794c6f636174696f6e3e0d0a2f2f2f2020203c547970654e616d653e446576457870726573732e587472615265706f7274732e55492e587472615265706f72743c2f547970654e616d653e0d0a2f2f2f2020203c4c6f63616c697a6174696f6e3e656e2d55533c2f4c6f63616c697a6174696f6e3e0d0a2f2f2f203c2f585254797065496e666f3e0d0a6e616d65737061636520587472615265706f727453657269616c697a6174696f6e207b0d0a202020200d0a202020207075626c696320636c61737320787472615265706f727431203a20446576457870726573732e587472615265706f7274732e55492e587472615265706f7274207b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e546f704d617267696e42616e6420546f704d617267696e3b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e44657461696c42616e642044657461696c3b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e58525461626c65207461626c65343b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e58525461626c65526f77207461626c65526f77343b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c207461626c6543656c6c353b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c207461626c6543656c6c32383b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c207461626c6543656c6c33343b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c207461626c6543656c6c33373b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c207461626c6543656c6c33383b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c207461626c6543656c6c383b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e426f74746f6d4d617267696e42616e6420426f74746f6d4d617267696e3b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e5265706f727448656164657242616e64205265706f72744865616465723b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e58524c6162656c206c6162656c323b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e58525461626c65207461626c65313b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e58525461626c65526f77207461626c65526f7731323b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c207461626c6543656c6c313b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c207461626c6543656c6c33353b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c207461626c6543656c6c33363b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e58525461626c65526f77207461626c65526f77333b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c207461626c6543656c6c373b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e58525461626c65526f77207461626c65526f77323b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c207461626c6543656c6c343b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c207461626c6543656c6c32303b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c207461626c6543656c6c32313b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e58525461626c65207461626c65333b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e58525461626c65526f77207461626c65526f77383b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c207461626c6543656c6c32323b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c207461626c6543656c6c32333b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c207461626c6543656c6c32343b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e58525461626c65526f77207461626c65526f77393b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c207461626c6543656c6c32353b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c207461626c6543656c6c32363b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c207461626c6543656c6c32373b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e5061676548656164657242616e6420506167654865616465723b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e58525461626c65207461626c65323b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e58525461626c65526f77207461626c65526f77313b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c207461626c6543656c6c323b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c207461626c6543656c6c31313b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c207461626c6543656c6c333b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c207461626c6543656c6c31333b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c207461626c6543656c6c31363b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c207461626c6543656c6c31353b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c207461626c6543656c6c31343b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c207461626c6543656c6c31373b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e58524c6162656c206c6162656c32343b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e58524c6162656c206c6162656c32393b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e58524c6162656c206c6162656c313b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e50616765466f6f74657242616e642050616765466f6f7465723b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e58524c6162656c206c6162656c32373b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e585250616765496e666f2070616765496e666f323b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e58524c6162656c206c6162656c32383b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e585250616765496e666f2070616765496e666f313b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e47726f757048656164657242616e642047726f7570486561646572313b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e58524c6162656c206c6162656c333b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e47726f757048656164657242616e642047726f7570486561646572323b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e58524c6162656c206c6162656c353b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e58524c6162656c206c6162656c343b0d0a20202020202020207072697661746520446576457870726573732e587472615265706f7274732e55492e466f726d617474696e6752756c6520666f726d617474696e6752756c65313b0d0a2020202020202020707269766174652053797374656d2e5265736f75726365732e5265736f757263654d616e61676572205f7265736f75726365733b0d0a20202020202020207075626c696320787472615265706f7274312829207b0d0a202020202020202020202020746869732e496e697469616c697a65436f6d706f6e656e7428293b0d0a20202020202020207d0d0a2020202020202020707269766174652053797374656d2e5265736f75726365732e5265736f757263654d616e61676572207265736f7572636573207b0d0a202020202020202020202020676574207b0d0a20202020202020202020202020202020696620285f7265736f7572636573203d3d206e756c6c29207b0d0a2020202020202020202020202020202020202020737472696e67207265736f75726365537472696e67203d2040227a73727676674541414143524141414162464e356333526c625335535a584e7664584a6a5a584d75556d567a62335679593256535a57466b5a5849734947317a5932397962476c694c4342575a584a7a61573975505449754d4334774c6a417349454e3162485231636d5539626d563164484a68624377675548566962476c6a53325635564739725a573439596a63335954566a4e5459784f544d305a5441344f534e5465584e305a573075556d567a623356795932567a4c6c4a31626e5270625756535a584e7664584a6a5a564e6c64414941414141414141414141414141414642425246424252464330414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141413d3d223b0d0a2020202020202020202020202020202020202020746869732e5f7265736f7572636573203d206e657720446576457870726573732e587472615265706f7274732e53657269616c697a6174696f6e2e58525265736f757263654d616e61676572287265736f75726365537472696e67293b0d0a202020202020202020202020202020207d0d0a2020202020202020202020202020202072657475726e20746869732e5f7265736f75726365733b0d0a2020202020202020202020207d0d0a20202020202020207d0d0a20202020202020207072697661746520766f696420496e697469616c697a65436f6d706f6e656e742829207b0d0a202020202020202020202020746869732e546f704d617267696e203d206e657720446576457870726573732e587472615265706f7274732e55492e546f704d617267696e42616e6428293b0d0a202020202020202020202020746869732e44657461696c203d206e657720446576457870726573732e587472615265706f7274732e55492e44657461696c42616e6428293b0d0a202020202020202020202020746869732e426f74746f6d4d617267696e203d206e657720446576457870726573732e587472615265706f7274732e55492e426f74746f6d4d617267696e42616e6428293b0d0a202020202020202020202020746869732e5265706f7274486561646572203d206e657720446576457870726573732e587472615265706f7274732e55492e5265706f727448656164657242616e6428293b0d0a202020202020202020202020746869732e50616765486561646572203d206e657720446576457870726573732e587472615265706f7274732e55492e5061676548656164657242616e6428293b0d0a202020202020202020202020746869732e50616765466f6f746572203d206e657720446576457870726573732e587472615265706f7274732e55492e50616765466f6f74657242616e6428293b0d0a202020202020202020202020746869732e47726f757048656164657231203d206e657720446576457870726573732e587472615265706f7274732e55492e47726f757048656164657242616e6428293b0d0a202020202020202020202020746869732e47726f757048656164657232203d206e657720446576457870726573732e587472615265706f7274732e55492e47726f757048656164657242616e6428293b0d0a202020202020202020202020746869732e7461626c6534203d206e657720446576457870726573732e587472615265706f7274732e55492e58525461626c6528293b0d0a202020202020202020202020746869732e7461626c65526f7734203d206e657720446576457870726573732e587472615265706f7274732e55492e58525461626c65526f7728293b0d0a202020202020202020202020746869732e7461626c6543656c6c35203d206e657720446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c28293b0d0a202020202020202020202020746869732e7461626c6543656c6c3238203d206e657720446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c28293b0d0a202020202020202020202020746869732e7461626c6543656c6c3334203d206e657720446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c28293b0d0a202020202020202020202020746869732e7461626c6543656c6c3337203d206e657720446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c28293b0d0a202020202020202020202020746869732e7461626c6543656c6c3338203d206e657720446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c28293b0d0a202020202020202020202020746869732e7461626c6543656c6c38203d206e657720446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c28293b0d0a202020202020202020202020746869732e6c6162656c32203d206e657720446576457870726573732e587472615265706f7274732e55492e58524c6162656c28293b0d0a202020202020202020202020746869732e7461626c6531203d206e657720446576457870726573732e587472615265706f7274732e55492e58525461626c6528293b0d0a202020202020202020202020746869732e7461626c6533203d206e657720446576457870726573732e587472615265706f7274732e55492e58525461626c6528293b0d0a202020202020202020202020746869732e7461626c65526f773132203d206e657720446576457870726573732e587472615265706f7274732e55492e58525461626c65526f7728293b0d0a202020202020202020202020746869732e7461626c65526f7733203d206e657720446576457870726573732e587472615265706f7274732e55492e58525461626c65526f7728293b0d0a202020202020202020202020746869732e7461626c65526f7732203d206e657720446576457870726573732e587472615265706f7274732e55492e58525461626c65526f7728293b0d0a202020202020202020202020746869732e7461626c6543656c6c31203d206e657720446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c28293b0d0a202020202020202020202020746869732e7461626c6543656c6c3335203d206e657720446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c28293b0d0a202020202020202020202020746869732e7461626c6543656c6c3336203d206e657720446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c28293b0d0a202020202020202020202020746869732e7461626c6543656c6c37203d206e657720446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c28293b0d0a202020202020202020202020746869732e7461626c6543656c6c34203d206e657720446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c28293b0d0a202020202020202020202020746869732e7461626c6543656c6c3230203d206e657720446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c28293b0d0a202020202020202020202020746869732e7461626c6543656c6c3231203d206e657720446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c28293b0d0a202020202020202020202020746869732e7461626c65526f7738203d206e657720446576457870726573732e587472615265706f7274732e55492e58525461626c65526f7728293b0d0a202020202020202020202020746869732e7461626c65526f7739203d206e657720446576457870726573732e587472615265706f7274732e55492e58525461626c65526f7728293b0d0a202020202020202020202020746869732e7461626c6543656c6c3232203d206e657720446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c28293b0d0a202020202020202020202020746869732e7461626c6543656c6c3233203d206e657720446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c28293b0d0a202020202020202020202020746869732e7461626c6543656c6c3234203d206e657720446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c28293b0d0a202020202020202020202020746869732e7461626c6543656c6c3235203d206e657720446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c28293b0d0a202020202020202020202020746869732e7461626c6543656c6c3236203d206e657720446576457870726573732e5874726152, [Last_Updated_Datetime]='2011-08-24 18:16:47.917' WHERE [Report_Id]=143
UPDATE [dbo].[tbl_Report] SET [Report_Binary].WRITE(0x65706f7274732e55492e58525461626c6543656c6c28293b0d0a202020202020202020202020746869732e7461626c6543656c6c3237203d206e657720446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c28293b0d0a202020202020202020202020746869732e7461626c6532203d206e657720446576457870726573732e587472615265706f7274732e55492e58525461626c6528293b0d0a202020202020202020202020746869732e6c6162656c3234203d206e657720446576457870726573732e587472615265706f7274732e55492e58524c6162656c28293b0d0a202020202020202020202020746869732e6c6162656c3239203d206e657720446576457870726573732e587472615265706f7274732e55492e58524c6162656c28293b0d0a202020202020202020202020746869732e6c6162656c31203d206e657720446576457870726573732e587472615265706f7274732e55492e58524c6162656c28293b0d0a202020202020202020202020746869732e7461626c65526f7731203d206e657720446576457870726573732e587472615265706f7274732e55492e58525461626c65526f7728293b0d0a202020202020202020202020746869732e7461626c6543656c6c32203d206e657720446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c28293b0d0a202020202020202020202020746869732e7461626c6543656c6c3131203d206e657720446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c28293b0d0a202020202020202020202020746869732e7461626c6543656c6c33203d206e657720446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c28293b0d0a202020202020202020202020746869732e7461626c6543656c6c3133203d206e657720446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c28293b0d0a202020202020202020202020746869732e7461626c6543656c6c3136203d206e657720446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c28293b0d0a202020202020202020202020746869732e7461626c6543656c6c3135203d206e657720446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c28293b0d0a202020202020202020202020746869732e7461626c6543656c6c3134203d206e657720446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c28293b0d0a202020202020202020202020746869732e7461626c6543656c6c3137203d206e657720446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c28293b0d0a202020202020202020202020746869732e6c6162656c3237203d206e657720446576457870726573732e587472615265706f7274732e55492e58524c6162656c28293b0d0a202020202020202020202020746869732e70616765496e666f32203d206e657720446576457870726573732e587472615265706f7274732e55492e585250616765496e666f28293b0d0a202020202020202020202020746869732e6c6162656c3238203d206e657720446576457870726573732e587472615265706f7274732e55492e58524c6162656c28293b0d0a202020202020202020202020746869732e70616765496e666f31203d206e657720446576457870726573732e587472615265706f7274732e55492e585250616765496e666f28293b0d0a202020202020202020202020746869732e6c6162656c33203d206e657720446576457870726573732e587472615265706f7274732e55492e58524c6162656c28293b0d0a202020202020202020202020746869732e6c6162656c35203d206e657720446576457870726573732e587472615265706f7274732e55492e58524c6162656c28293b0d0a202020202020202020202020746869732e6c6162656c34203d206e657720446576457870726573732e587472615265706f7274732e55492e58524c6162656c28293b0d0a202020202020202020202020746869732e666f726d617474696e6752756c6531203d206e657720446576457870726573732e587472615265706f7274732e55492e466f726d617474696e6752756c6528293b0d0a202020202020202020202020282853797374656d2e436f6d706f6e656e744d6f64656c2e49537570706f7274496e697469616c697a652928746869732e7461626c653429292e426567696e496e697428293b0d0a202020202020202020202020282853797374656d2e436f6d706f6e656e744d6f64656c2e49537570706f7274496e697469616c697a652928746869732e7461626c653129292e426567696e496e697428293b0d0a202020202020202020202020282853797374656d2e436f6d706f6e656e744d6f64656c2e49537570706f7274496e697469616c697a652928746869732e7461626c653329292e426567696e496e697428293b0d0a202020202020202020202020282853797374656d2e436f6d706f6e656e744d6f64656c2e49537570706f7274496e697469616c697a652928746869732e7461626c653229292e426567696e496e697428293b0d0a202020202020202020202020282853797374656d2e436f6d706f6e656e744d6f64656c2e49537570706f7274496e697469616c697a6529287468697329292e426567696e496e697428293b0d0a2020202020202020202020202f2f200d0a2020202020202020202020202f2f20546f704d617267696e0d0a2020202020202020202020202f2f200d0a202020202020202020202020746869732e546f704d617267696e2e48656967687446203d20313030463b0d0a202020202020202020202020746869732e546f704d617267696e2e4e616d65203d2022546f704d617267696e223b0d0a2020202020202020202020202f2f200d0a2020202020202020202020202f2f2044657461696c0d0a2020202020202020202020202f2f200d0a202020202020202020202020746869732e44657461696c2e436f6e74726f6c732e41646452616e6765286e657720446576457870726573732e587472615265706f7274732e55492e5852436f6e74726f6c5b5d207b0d0a202020202020202020202020202020202020202020202020746869732e7461626c65347d293b0d0a202020202020202020202020746869732e44657461696c2e48656967687446203d203238463b0d0a202020202020202020202020746869732e44657461696c2e4e616d65203d202244657461696c223b0d0a202020202020202020202020746869732e44657461696c2e5072696e744f6e456d70747944617461536f75726365203d2066616c73653b0d0a2020202020202020202020202f2f200d0a2020202020202020202020202f2f20426f74746f6d4d617267696e0d0a2020202020202020202020202f2f200d0a202020202020202020202020746869732e426f74746f6d4d617267696e2e48656967687446203d20313030463b0d0a202020202020202020202020746869732e426f74746f6d4d617267696e2e4e616d65203d2022426f74746f6d4d617267696e223b0d0a2020202020202020202020202f2f200d0a2020202020202020202020202f2f205265706f72744865616465720d0a2020202020202020202020202f2f200d0a202020202020202020202020746869732e5265706f72744865616465722e436f6e74726f6c732e41646452616e6765286e657720446576457870726573732e587472615265706f7274732e55492e5852436f6e74726f6c5b5d207b0d0a202020202020202020202020202020202020202020202020746869732e6c6162656c322c0d0a202020202020202020202020202020202020202020202020746869732e7461626c65312c0d0a202020202020202020202020202020202020202020202020746869732e7461626c65337d293b0d0a202020202020202020202020746869732e5265706f72744865616465722e48656967687446203d20343032463b0d0a202020202020202020202020746869732e5265706f72744865616465722e4e616d65203d20225265706f7274486561646572223b0d0a202020202020202020202020746869732e5265706f72744865616465722e50616765427265616b203d20446576457870726573732e587472615265706f7274732e55492e50616765427265616b2e416674657242616e643b0d0a2020202020202020202020202f2f200d0a2020202020202020202020202f2f20506167654865616465720d0a2020202020202020202020202f2f200d0a202020202020202020202020746869732e506167654865616465722e436f6e74726f6c732e41646452616e6765286e657720446576457870726573732e587472615265706f7274732e55492e5852436f6e74726f6c5b5d207b0d0a202020202020202020202020202020202020202020202020746869732e7461626c65322c0d0a202020202020202020202020202020202020202020202020746869732e6c6162656c32342c0d0a202020202020202020202020202020202020202020202020746869732e6c6162656c32392c0d0a202020202020202020202020202020202020202020202020746869732e6c6162656c317d293b0d0a202020202020202020202020746869732e506167654865616465722e48656967687446203d203132352e37303833463b0d0a202020202020202020202020746869732e506167654865616465722e4e616d65203d202250616765486561646572223b0d0a202020202020202020202020746869732e506167654865616465722e5374796c655072696f726974792e55736554657874416c69676e6d656e74203d2066616c73653b0d0a202020202020202020202020746869732e506167654865616465722e54657874416c69676e6d656e74203d20446576457870726573732e587472615072696e74696e672e54657874416c69676e6d656e742e546f7043656e7465723b0d0a2020202020202020202020202f2f200d0a2020202020202020202020202f2f2050616765466f6f7465720d0a2020202020202020202020202f2f200d0a202020202020202020202020746869732e50616765466f6f7465722e436f6e74726f6c732e41646452616e6765286e657720446576457870726573732e587472615265706f7274732e55492e5852436f6e74726f6c5b5d207b0d0a202020202020202020202020202020202020202020202020746869732e6c6162656c32372c0d0a202020202020202020202020202020202020202020202020746869732e70616765496e666f322c0d0a202020202020202020202020202020202020202020202020746869732e6c6162656c32382c0d0a202020202020202020202020202020202020202020202020746869732e70616765496e666f317d293b0d0a202020202020202020202020746869732e50616765466f6f7465722e48656967687446203d2032332e3030303032463b0d0a202020202020202020202020746869732e50616765466f6f7465722e4e616d65203d202250616765466f6f746572223b0d0a2020202020202020202020202f2f200d0a2020202020202020202020202f2f2047726f7570486561646572310d0a2020202020202020202020202f2f200d0a202020202020202020202020746869732e47726f7570486561646572312e436f6e74726f6c732e41646452616e6765286e657720446576457870726573732e587472615265706f7274732e55492e5852436f6e74726f6c5b5d207b0d0a202020202020202020202020202020202020202020202020746869732e6c6162656c337d293b0d0a202020202020202020202020746869732e47726f7570486561646572312e47726f75704669656c64732e41646452616e6765286e657720446576457870726573732e587472615265706f7274732e55492e47726f75704669656c645b5d207b0d0a2020202020202020202020202020202020202020202020206e657720446576457870726573732e587472615265706f7274732e55492e47726f75704669656c64282254726164696e675f5265705f436f6465222c20446576457870726573732e587472615265706f7274732e55492e5852436f6c756d6e536f72744f726465722e417363656e64696e67297d293b0d0a202020202020202020202020746869732e47726f7570486561646572312e48656967687446203d203233463b0d0a202020202020202020202020746869732e47726f7570486561646572312e4c6576656c203d20313b0d0a202020202020202020202020746869732e47726f7570486561646572312e4e616d65203d202247726f757048656164657231223b0d0a2020202020202020202020202f2f200d0a2020202020202020202020202f2f2047726f7570486561646572320d0a2020202020202020202020202f2f200d0a202020202020202020202020746869732e47726f7570486561646572322e436f6e74726f6c732e41646452616e6765286e657720446576457870726573732e587472615265706f7274732e55492e5852436f6e74726f6c5b5d207b0d0a202020202020202020202020202020202020202020202020746869732e6c6162656c352c0d0a202020202020202020202020202020202020202020202020746869732e6c6162656c347d293b0d0a202020202020202020202020746869732e47726f7570486561646572322e47726f75704669656c64732e41646452616e6765286e657720446576457870726573732e587472615265706f7274732e55492e47726f75704669656c645b5d207b0d0a2020202020202020202020202020202020202020202020206e657720446576457870726573732e587472615265706f7274732e55492e47726f75704669656c6428224163636f756e745f4e756d626572222c20446576457870726573732e587472615265706f7274732e55492e5852436f6c756d6e536f72744f726465722e417363656e64696e67297d293b0d0a202020202020202020202020746869732e47726f7570486561646572322e48656967687446203d2032352e3030303036463b0d0a202020202020202020202020746869732e47726f7570486561646572322e4e616d65203d202247726f757048656164657232223b0d0a2020202020202020202020202f2f200d0a2020202020202020202020202f2f207461626c65340d0a2020202020202020202020202f2f200d0a202020202020202020202020746869732e7461626c65342e466f6e74203d206e65772053797374656d2e44726177696e672e466f6e742822417269616c222c203946293b0d0a202020202020202020202020746869732e7461626c65342e4c6f636174696f6e466c6f6174203d206e657720446576457870726573732e5574696c732e506f696e74466c6f61742839372e3438333833462c203346293b0d0a202020202020202020202020746869732e7461626c65342e4e616d65203d20227461626c6534223b0d0a202020202020202020202020746869732e7461626c65342e50616464696e67203d206e657720446576457870726573732e587472615072696e74696e672e50616464696e67496e666f28322c20322c20302c20302c2031303046293b0d0a202020202020202020202020746869732e7461626c65342e526f77732e41646452616e6765286e657720446576457870726573732e587472615265706f7274732e55492e58525461626c65526f775b5d207b0d0a202020202020202020202020202020202020202020202020746869732e7461626c65526f77347d293b0d0a202020202020202020202020746869732e7461626c65342e53697a6546203d206e65772053797374656d2e44726177696e672e53697a6546283534392e35313632462c20323546293b0d0a202020202020202020202020746869732e7461626c65342e5374796c655072696f726974792e557365466f6e74203d2066616c73653b0d0a202020202020202020202020746869732e7461626c65342e5374796c655072696f726974792e55736550616464696e67203d2066616c73653b0d0a2020202020202020202020202f2f200d0a2020202020202020202020202f2f207461626c65526f77340d0a2020202020202020202020202f2f200d0a202020202020202020202020746869732e7461626c65526f77342e43656c6c732e41646452616e6765286e657720446576457870726573732e587472615265706f7274732e55492e58525461626c6543656c6c5b5d207b0d0a202020202020202020202020202020202020202020202020746869732e7461626c6543656c6c352c0d0a202020202020202020202020202020202020202020202020746869732e7461626c6543656c6c32382c0d0a202020202020202020202020202020202020202020202020746869732e7461626c6543656c6c33342c0d0a202020202020202020202020202020202020202020202020746869732e7461626c6543656c6c33372c0d0a202020202020202020202020202020202020202020202020746869732e7461626c6543656c6c33382c0d0a202020202020202020202020202020202020202020202020746869732e7461626c6543656c6c387d293b0d0a202020202020202020202020746869732e7461626c65526f77342e4e616d65203d20227461626c65526f7734223b0d0a202020202020202020202020746869732e7461626c65526f77342e576569676874203d20313b0d0a2020202020202020202020202f2f200d0a2020202020202020202020202f2f207461626c6543656c6c350d0a2020202020202020202020202f2f200d0a202020202020202020202020746869732e7461626c6543656c6c352e4461746142696e64696e67732e41646452616e6765286e657720446576457870726573732e587472615265706f7274732e55492e585242696e64696e675b5d207b0d0a2020202020202020202020202020202020202020202020206e657720446576457870726573732e587472615265706f7274732e55492e585242696e64696e67282254657874222c206e756c6c2c202253686f727420506f736974696f6e2e53656375726974795f436f646522297d293b0d0a202020202020202020202020746869732e7461626c6543656c6c352e4e616d65203d20227461626c6543656c6c35223b0d0a202020202020202020202020746869732e7461626c6543656c6c352e54657874203d20227461626c6543656c6c35223b0d0a202020202020202020202020746869732e7461626c6543656c6c352e576569676874203d20302e31353638393034353730343036303631313b0d0a2020202020202020202020202f2f200d0a2020202020202020202020202f2f207461626c6543656c6c32380d0a2020202020202020202020202f2f200d0a202020202020202020202020746869732e7461626c6543656c6c32382e4461746142696e64696e67732e41646452616e6765286e657720446576457870726573732e587472615265706f7274732e55492e585242696e64696e675b5d207b0d0a2020202020202020202020202020202020202020202020206e657720446576457870726573732e587472615265706f7274732e55492e585242696e64696e67282254657874222c206e756c6c2c202253686f727420506f736974696f6e2e53656375726974795f53686f72745f4e616d6522297d293b0d0a202020202020202020202020746869732e7461626c6543656c6c32382e4e616d65203d20227461626c6543656c6c3238223b0d0a202020202020202020202020746869732e7461626c6543656c6c32382e54657874203d20227461626c6543656c6c3238223b0d0a202020202020202020202020746869732e7461626c6543656c6c32382e576569676874203d20302e353332383837323738313934393934363b0d0a2020202020202020202020202f2f200d0a2020202020202020202020202f2f207461626c6543656c6c33340d0a2020202020202020202020202f2f200d0a202020202020202020202020746869732e7461626c6543656c6c33342e4461746142696e64696e67732e41646452616e6765286e657720446576457870726573732e587472615265706f7274732e55492e585242696e64696e675b5d207b0d0a2020202020202020202020202020202020202020202020206e657720446576457870726573732e587472615265706f7274732e55492e585242696e64696e67282254657874222c206e756c6c2c202253686f727420506f736974696f6e2e436f6e74726163745f4e756d626572222c20227b303a232c23302e30307d22297d293b0d0a202020202020202020202020746869732e7461626c6543656c6c33342e4e616d65203d20227461626c6543656c6c3334223b0d0a202020202020202020202020746869732e7461626c6543656c6c33342e5374796c655072696f726974792e55736554657874416c69676e6d656e74203d2066616c73653b0d0a202020202020202020202020746869732e7461626c6543656c6c33342e54657874203d20227461626c6543656c6c3334223b0d0a202020202020202020202020746869732e7461626c6543656c6c33342e54657874416c69676e6d656e74203d20446576457870726573732e587472615072696e74696e672e54657874416c69676e6d656e742e546f704c6566743b0d0a202020202020202020202020746869732e7461626c6543656c6c33342e576569676874203d20302e32393338313735323135333634303038393b0d0a2020202020202020202020202f2f200d0a2020202020202020202020202f2f207461626c6543656c6c33370d0a2020202020202020,NULL,NULL) WHERE [Report_Id]=143

After seeing the above script, i was like gezz what's happening in there (appreciate if someone could tell me what are those series of number mean here). Seriously looking for a way (good tutorials/books) to improve my knowledge on SQL and all of its related stuff. Appreciated if someone could point me to the right directions or give any advice. Thanks all.

Answer 1

User-837620913 posted

SQL is Structured Query Language.  People often refer to SQL to mean the standards-based or compliant SQL.

PLSQL stands for Procedural Language/Structured Query Language.  It is Oracle's procedural extension to SQL.  (Note that all vendors generally add custom extensions to SQL to try to lock you in to their platform and/or make your programming job easier.)

What appears to be going on with your query is an update is setting the value of a binary field, a file like a Word or Excel document, along with the lastupdatedtime.  Those series of numbers are Hexadecimal, a way of converting a binary BLOB into human-readable text.