![](https://img-blog.csdnimg.cn/20201014180756916.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Oracle
imisewer
Just Ewer
展开
-
Create Table
DECLARE CURSOR TABCURSOR IS SELECT COUNT(*) AS COUNTROW FROM USER_OBJECTS WHERE OBJECT_TYPE=TABLE AND OBJECT_NAME=CS30_CSPURVIEW;V_SQL VARCHAR2(2000);BEGINFOR TAB IN TABCURSOR LOOP原创 2009-07-15 11:05:00 · 224 阅读 · 0 评论 -
查询SQL大小写问题
对连接执行:alter session set NLS_COMP=ANSIalter session set NLS_SORT=BINARY_CI 或者通过编写触发器转载 2009-07-15 15:45:00 · 237 阅读 · 0 评论