![](https://img-blog.csdnimg.cn/4f912be9bbbf4325bd76fc8c944d4885.png?x-oss-process=image/resize,m_fixed,h_224,w_224)
oracle
oracle
spencer_tseng
这个作者很懒,什么都没留下…
展开
-
oracle tree
oracle tree原创 2024-05-29 23:00:51 · 1038 阅读 · 0 评论 -
Oracle Create user
oracle create user原创 2023-12-24 21:38:36 · 648 阅读 · 0 评论 -
ORA-00923: FROM keyword not found where expected
举个栗子呗,就是语法错误找不到“FROM”,也是少了逗号。原创 2023-07-28 20:18:46 · 218 阅读 · 0 评论 -
ora-12170:tns:connect timeout
ora-12170:tns:connect timeout原创 2023-02-24 21:54:22 · 80 阅读 · 0 评论 -
ORA-12541: TNS: No listener
ORA-12541: TNS: No listener原创 2022-12-03 13:20:05 · 468 阅读 · 0 评论 -
ORA-12514: TNS: The listener currently cannot recognize the service requested in the connection desc
ORA-12514: TNS: The listener currently cannot recognize the service requested in the connection descriptor原创 2022-12-03 13:17:12 · 106 阅读 · 0 评论 -
Statement PreparedStatement CallableStatement
Statement PreparedStatement CallableStatement原创 2022-11-18 13:36:06 · 247 阅读 · 0 评论 -
Caused by: java.sql.BatchUpdateException: ORA-01722
Caused by: java.sql.BatchUpdateException: ORA-01722: 无效数字原创 2022-11-17 00:27:15 · 843 阅读 · 0 评论 -
oracle EXPLAIN PLAN FOR
oracle EXPLAIN PLAN FOR原创 2022-10-17 11:18:27 · 217 阅读 · 0 评论 -
[Err] ORA-24344: success with compilation error
ORA-24344: success with compilation error原创 2022-10-16 12:09:40 · 502 阅读 · 0 评论 -
java.sql.SQLException: ORA-28001: the password has expired
oracle密码过期原创 2022-06-07 11:03:30 · 584 阅读 · 1 评论 -
TO_DATE TO_CHAR
SELECT * FROM T_CSEPRO_TEMPLATE WHERE to_char(founder_time, 'YYYY-MM-DD') = '2018-03-19';6 rows selected in 0.131 seconds.=============================================================================...原创 2018-03-19 16:38:15 · 134 阅读 · 1 评论 -
oracle ORA-01704: string literal too long
ORA-01704: 字符串文字太长DECLARE clobValue T_FB_FORM.FILL_IN_REMARK%TYPE; BEGIN clobValue := '<p> <p> (1)本表填写现职和1 年内离职,近四学年内承担参评专业的专业课(含专业基础课)教学(含课堂教学、毕业论文/设计指导、实习指导)的,所有专兼职教师情况。教...原创 2018-03-06 15:30:24 · 1236 阅读 · 0 评论 -
ORA-28001: the password has expired
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnection...原创 2018-03-19 10:44:17 · 987 阅读 · 2 评论 -
ORA-12519: TNS:no appropriate service handler found
select count(*) from v$process;select value from v$parameter where name = 'processes';SELECT osuser, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwher...原创 2018-03-12 11:53:12 · 151 阅读 · 0 评论 -
ORA-12737 Instant Client Light:unsupported server character set ZHS16GBK
用安装oracle目录下的oci.dll替换客户端工具下面的oci.dllF:\oracle\product\10.2.0\db_1\BIN原创 2020-10-04 17:28:42 · 182 阅读 · 0 评论 -
oracle charset (server, client)
server:SELECT * FROM nls_database_parameters;============================================================================client:SELECT USERENV('language') FROM dual;------------原创 2018-01-25 10:46:02 · 613 阅读 · 0 评论 -
oracle query by date
CREATE TABLE test(name VARCHAR2(200),etl_dt DATE);SELECT * FROM test WHERE TO_CHAR(ETL_DT, 'yyyy-MM-dd') = '2020-03-31';原创 2020-09-01 17:31:10 · 132 阅读 · 0 评论 -
ORA-28040: No matching authentication protocol
ORA-28040: No matching authentication protocol原创 2020-06-15 10:42:22 · 904 阅读 · 0 评论 -
org.hibernate.MappingException: No Dialect mapping for JDBC type: -9
查看 java.sql.Types 类,可以找到对应类型,调整相应的数据库里的类型,或者其他支持这个类型的方言。原创 2018-05-21 15:20:03 · 1851 阅读 · 0 评论 -
tablespace
create tablespace data_ptlogging datafile 'D:\Oracle11g\oradata\data_pt.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;原创 2017-12-18 14:45:08 · 180 阅读 · 0 评论 -
oracle table strategy is empty
原创 2017-10-13 09:41:07 · 251 阅读 · 0 评论 -
oracle rman
Microsoft Windows [版本 6.1.7601]版权所有 (c) 2009 Microsoft Corporation。保留所有权利。C:\Users\Administrator.USER-20200323CP>conn sys/oracle@orcl'conn' 不是内部或外部命令,也不是可运行的程序或批处理文件。C:\Users\Administrator.USER-20200323CP>sql /nolog'sql' 不是内部或外部命令...原创 2020-11-23 09:57:32 · 508 阅读 · 0 评论 -
ORA-01722: invalid number
http://blog.itpub.net/519536/viewspace-660522/原创 2017-10-27 16:47:02 · 325 阅读 · 0 评论 -
oracle sql format
--0.14sec--SELECT id, name, start_time, end_time, year, status, del_flag, founder_id, founder_time, operator_id, operation_time,procedure_name, TRUNC(t3.complete_count / t2.form_count, 2)原创 2017-08-31 11:47:50 · 655 阅读 · 1 评论 -
ORA-28002
java.sql.SQLWarning: ORA-28002: the password will expire within 7 days at oracle.jdbc.driver.DatabaseError.addSqlWarning(DatabaseError.java:950) at oracle.jdbc.driver.DatabaseError.newSqlWarning(DatabaseError.java:894) at oracle.jdbc.driver.T4CTTIoer..原创 2020-06-01 15:30:25 · 405 阅读 · 0 评论 -
select userenv('language') from dual
select userenv('language') from dual原创 2017-09-21 21:30:46 · 5559 阅读 · 0 评论 -
oracle LONG_TO_CHAR
CREATE OR REPLACE FUNCTION LONG_TO_CHAR(v_table_name IN VARCHAR2, v_column_name IN VARCHAR2)RETURN VARCHAR2AS uVal VARCHAR2(32767); BEGIN SELECT DATA_DEFAULT INTO uVal FROM USER_TAB_COLS WHERE TABLE_NAME = UPPER(v_table_name) AND column_name = UPPE.原创 2020-11-26 16:14:48 · 1811 阅读 · 1 评论 -
oracle db development PL/SQL
1:我用的是oracle9i,因为我觉得它用来学习oracle数据库相当的不错2:用SYSTEM用户登录,创建表空间,就是物理文件,写在某个磁盘文件下。3:创建用户4:导入数据库原创 2017-08-21 01:36:08 · 412 阅读 · 0 评论 -
view
INSERT INTO t_sys_dict(id, name, code, pid, remark, seq, type, lv)SELECT id, name, code, pid, remark, seq, state, lv FROM t_sys_org;COMMIT;CREATE TABLE zwf_01( a VARCHAR2(100), b VARCHA原创 2018-01-31 17:12:45 · 243 阅读 · 0 评论 -
set define off; PL/SQL Developer Oracle client tool
PL/SQL Developer Oracle client tool set define off;原创 2018-01-24 10:13:05 · 1680 阅读 · 0 评论 -
varchar2 length
原创 2017-10-31 15:55:24 · 181 阅读 · 0 评论 -
Oracle LISTAGG
SELECTLISTAGG(type_app, '#') WITHIN GROUP (ORDER BY cust_no) AS typeFROMTABLE;原创 2020-09-21 15:24:41 · 92 阅读 · 0 评论 -
java.sql.SQLException: ORA-01790: expression must have same datatype as corresponding expression
http://blog.csdn.net/spencer_tseng/article/details/78800391原创 2017-12-13 16:00:32 · 4528 阅读 · 0 评论 -
oracle operation
原创 2017-08-28 13:43:43 · 474 阅读 · 0 评论 -
oracle SELECT COLUMN = DEFAULT_VALUE
SELECT data_default FROM user_tab_columns WHERE table_name ='TEST222' AND column_name = 'CODE'CREATE TABLE "ZWF"."TEST222" ( "CODE" VARCHAR2(100) default 20, "NAME" VARCHAR2(100) );INSERT INTO test222 VALUES('0...原创 2020-11-26 16:22:14 · 350 阅读 · 0 评论 -
ORA-08103:object no longer exists
ORA-08103:object no longer existsselect obj#,dataobj#,name,type#,owner# from obj$ where name = 'TEST';select object_name,object_type,object_id,data_object_id from user_objects where object_name = 'zwf';暂时未解决触发!原创 2020-09-07 14:56:05 · 597 阅读 · 0 评论 -
ora-12541:tns:no listener
D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN原创 2020-09-22 10:27:46 · 99 阅读 · 0 评论 -
Oracle Java Mission Control
原创 2020-08-22 19:54:54 · 546 阅读 · 1 评论 -
oracle trigger
这几天复习的事。原创 2017-08-29 17:25:48 · 235 阅读 · 0 评论