我用下面语句查找日志
select sql_text,last_LOAD_TIME from v$sql v
在sql_text字段的结果中发现下面一行语句看不懂
INSERT INTO "SYU_DYLSXX"
( "SYUDYLSH", "CXLSH", "CXBZ", "TBLSH", "DWBH", "DWMC", "GRBH", "GMSFHM", "XM", "XB", "CSRQ", "SYRQ", "SYZH", "SYZQFJG", "SYLBBH", "DWJBR", "SBRQ", "DYJFJS", "DYJFGS", "SYDYZE", "JZRQ", "FKSSQ", "YWZT", "WCBZ", "JBR", "JBRQ", "SHR", "SHRQ", "SPR", "SPRQ", "SPYJ", "BZ", "DYJFYS" )
VALUES
( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33 )
就是其中的值:1,:2、……之类的数字代表的值在哪里啊,我怎么看到这条语句实际更新的数据???
求教!!!
select sql_text,last_LOAD_TIME from v$sql v
在sql_text字段的结果中发现下面一行语句看不懂
INSERT INTO "SYU_DYLSXX"
( "SYUDYLSH", "CXLSH", "CXBZ", "TBLSH", "DWBH", "DWMC", "GRBH", "GMSFHM", "XM", "XB", "CSRQ", "SYRQ", "SYZH", "SYZQFJG", "SYLBBH", "DWJBR", "SBRQ", "DYJFJS", "DYJFGS", "SYDYZE", "JZRQ", "FKSSQ", "YWZT", "WCBZ", "JBR", "JBRQ", "SHR", "SHRQ", "SPR", "SPRQ", "SPYJ", "BZ", "DYJFYS" )
VALUES
( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33 )
就是其中的值:1,:2、……之类的数字代表的值在哪里啊,我怎么看到这条语句实际更新的数据???
求教!!!
参考一下这个文章:
oracle绑定变量:绑定变量的分析理解
http://www.crazycoder.cn/DataBase/Article21778.html
可以到v$sqlarea表查看解析后的sql。