求助，<Long> 数据类型 怎么查询显示数据内容

wangqing1026

<Long> 类型的数据，怎么SQL查询显示出数据内容 比如 字段
     A                        B

e4eddf66            <Long>

B类型为LONG类型  select a.b from dual 这样的显示是 b为 long  但是不会显示内容
能有好的办法 通过SELECT 查询显出LONG里面的内容


long类型数据如下：

5C1FE8B4F19CA322FABEEDE985CEA9E7353B7374331B5C88BC34AB7B5B57C3BA6984518C778527432703BCD87EEF29ABDE9172695B883E1B1879BC833A0564063B9189763EB46F5AD33B60E5B0F6C2B3E253725E299A0F5E0C6ADAE3354E3BC0972DE80E7EB9688D0E6CAA420BE669797B89945A19DDE14FAAB4BFD01A5AC854678D786518499F7C41BDCE0C890E07E7FCD13E393E8CEC7542565857916A3901259224D53C4DB82A66702797686B0A90DBDB96E0BB23B8AB2C55CE929DD9A96A5F03752D65E1757B4D39364D739B3BB84250EF9EFEC53F5B463D57C44657D0B42BEEDB970D796AD1FAA85322DD822DCC5E64A1067C56CA816361235EF21D3D0E42B646AA0B184A1553864A899398B332152CCFA9879AEB217DC6054FE746FDAEBDA759601D19C189BA14C739E0AAE50BC2A26CC7A2F50BD5513F85BE8BDC973F209F353C3A6DE66A5692E6B7BE4B00D49FC15D9C3759050D4476C5DE107756D0C4934AD6BAAC682DD0E944F09CECB90F64E4B4693A2470E5B175522DE6A88FAE8017FB07D709E39798F24CE9290E27CE8750301F00C45AEF4E78999BDE2555513F920BE73A24E803C8134334DCDDFAC2C001FED6FCA3B037951FAB3FCD73C7758AF0F59BC63BD7379A1237F4DCA876BFCAE126CF291C64D1EF69833F6434B15F281ED98A65FD951FF23D7DF5B6644843C46E7691124925854C1FDAA397BD6AFF9AC48404106F29593E1B352C3320BF64981B02DABBF20433C07AF2534EB026FF7A35C20AAA81A497FBE8FC59B938C5F40066F465DC8EDADBB06C00C976B999AD783974A4B919B9406B626791BEF963D72570C3E6CF06CD34FC45BDD113AB8F66BA62BE2C7666811738766518DA687F83A6E7C5728BFFD2F5717FCFD27313BA431AD8A8E5081F697CA14A2652F9AF12F3B4A47773ACABAEA1761138144490C248420E4F106CD2CF042130FAC70801A6F786EA1FF561E543402BE8C12386ECB73A6ECB0B9B16F2C27808FBB51FADBBE5194667A56E3DA29D06467BF46E46DC06E17FB53E20C854C128C3A16B3E074D53367E02502733D8BF88594D3516243BDE03B71475F7900779A2DA0897F71929D6C4E81C2969A80F6FF41B02F51B1E45CF856FEB34D5ACED45CFBE2745D813F8595189438A374C2D43C0EC29B926D8A76B1A10DF3A11EAB1ED73441DCE7C9AF7F9BECB285C88B3942681307727B0898E23EA6DE8990222EDC132B28B007F0DB3A0D97C60CE98FC0C6CF46C81C974F67AD9DFA26A18AEC1633B7D8356CC2C68003BA9D787ED6350B5096AC39DA9B2D6B09E66A3E8C86C382723789678A46E3756344B3609A5A83F706542EB77FCF459336444D834CC0FBB6D48F9C84B4F33EE3B43926428AABE62889DF50216B7C676155A539CB774C9D546D71CBB8EA197FC3D7D7D552308E79ACB6A95B6373D198C9E065208837128EE297F26F45DD807FADE571D2D81D5D207F9558B7D8A592F66C1E5F81B1C3320D43050D2FB265A074F2C22E4370172705BF067D8127252033B66FF8761EFD9ACE419DA1D98249E04C577541BEAA5450C1156E52EB2E28A7F0102CA284EC2CF5DE1FE8616459EE41FCB3993BDB7F20B19986301737C4485D3F1B148ED71534EBF7BEB2AF630F12606E80A1C4D44D3F8C0AFE0D5F53AA8A948AA16A40E5513F413E704FD9F9175D4EF1494363D6FC5FD8AF9607596B25F63E6D2DCC87DE87F9AC3B9AD1FB22190552A5A2556CCE92D599C3502702C1C2020F71007DDA49BE665A9113C2C863AF5D2F0AC659A592D2037B9930F340F517B61A94098BE003F1A5B0F21E7B124EDC853324A89A4F7370BF02D2457C8E26715C7479EA984628557A0880A8E141A16A3737458F2FCCA45D90BA38490C42C99D07CF8320B566036B4D8D96A161964685B3D011512FFF2D169699C4D8ADAFE3DC990400**C4EF682E227D1C271AEC9DA72E92D61D480A4865CA685A98C85427AE545E7798F2E3C0CB0263967466063C99ECD7208AA9CC268B75ACDFA4381C463C7A6AA832E59E5BB04AB409F61DD7C12228D8F429FBDBB0BAE1697D24F711F65DDEE6C69BFD5DF26B3255643158F3A1A86C88EE90215DF4C67566F7C7D6974CE18B038F0026D3171D849A1C6D6B6BAF5F6C456BE2E7EEE186E9425B6C053028573CE8CFCAC59031D795419830E8BF3B93393B956EEDBF226FA9903BB4D83EF97C9E0910AE3DBA9BFEFC310666957190AF40F85C624A3226DC2C4FDBF5DD37A0541F852DF16A4D81956E6F1A95B79AA0F9DAE600D729850E2A8F8799B78157878D09A04AB02376A5E5B0E788063D8C39B99650CD29DEA96A7B8215A8D742AA804DD4A11210C9686683C575CF88B8D4CF0B66A976759DE15B7243D51D86EB4BC0C1C4ABD5FC9320C14D942799044BEF35FD0302ED789087266B9FDF9E2E194BC7C033FA8B85048DC8C8A066644C5C1A5706A178EEB4992633F6973ACA58FE40038BB0D6BC99F890A92F234B07E8778F0D7CF1F9FA29F7868BD6CB5413E3C34F1A125B21BF0CB65BE6030D1AF18E3E1B5816D2B269A397642AE1C67DE7373A6E7703E53592C1A7E0DB331CEB37AEEFA49A1652DC10201CCC97FE3772A562C2223B47CA085A52802D2CE97D37DDD1A99F0915EE6605A96B25E52C52DFFC730F97C00E0611DC4806A55A25661A754CDF2A6FE8FA7FDBF9786FF08203C2D103344A08E0FF835CE4C787022AF1CDF1508A49B59F0850A058A1C57461EF17A4E1A03FD19A1F6CDE0D699D82C53366BE5AF85781C787A8C706D95DF993E401868621BE1CA262C8CD344D9D1947712F0250CFCB800B07F795C22F92EEB89E709C3FD44A36CB453D56DCEA8802B98627B8D2835432A8289FD828828D4505E3BA3607B7118DD015A82776D9C0B25613FE7FD3CFDDAE34D5E1597D9D6D7D89FF0FF6CF26C46EF88B5844757FC854CA93BEEE33967638D90FA8E216ECAA83CDFCCE2E72305C27F1A765305BD21ACAC243C48A790BAF2C577C1303B7063AA648499445B0B0DC304AE695E46E64FAB59F197D0C382142175DF9A2880A0BCABE1C4999A4B873356ECB083610A13F83AA1FEE60CBDEA89A4285E7EFC3C262C82B6AD192710D5C00392FAEA73B9A3051D404594FA6803E57BE4CCC47527616946F7F3B7237549A829E53CE042B7825C6A8E95A05E6798FDA5FB4E9F1758BE25CA3A69D3063F907551417E1C93D6CC41AEA2077F4492C24788B924A4FED7C80070784CA33E4F00DD437B9E0BD4E4CFFC12A65609ED649E4A6FA42D707BE5AEFD1D95D891F3538F5CFFAAF80416AD7914F4CE412AEC09C359BCD5BE823E5627116BD941B8F2BC094D5757A04831A6F5B6092712B2F9129A8A2447DD1E6370C223AE0BAA0EFCE6F88AFE1A1571A61DD9A4C41A970EB8AF6622558E4907F39A1472D0A2E88DB0C62070D70631F5AF78A9D952150ED16A2D4936A4EAC809AE4EE2E48A2B0287A1394E6BEE45CE44461E5A32EC5C0A13F3962D63FBF5B2D993B6FEDB6C62F87F5654971B942732ECF50D1CD4F2E89D467AB566B60E728E0AEB9E3B062F50FAD7972F4178A87A0C564313326FF3BED8FDB4485888478B391409C62F22E73489ACE9350A241F838929519CC48B09CF90750AC364E3E

newkid

你想用什么工具显示？有些工具需要你双击这个列，就会弹出窗口显示具体内容。

wangqing1026

newkid 发表于 2023-5-18 21:58
你想用什么工具显示？有些工具需要你双击这个列，就会弹出窗口显示具体内容。

我把类型改成 CLOB 类型，然后，通过oracle内置函数 DBMS_LOB.SUBSTR 来获取CLOB类型来显示数据。字段中要显示内容不能长度4000，超过4000就会报错。所以，我是采用字符分割方式来进行处理的。