qq 117791303

win64_11gR2_database win10

oracle tree

oracle create user

举个栗子呗，就是语法错误找不到“FROM”，也是少了逗号。

ORA-12170:tns:connect timeout

ORA-12541: TNS: No listener

ORA-12514: TNS: The listener currently cannot recognize the service requested in the connection descriptor

Statement PreparedStatement CallableStatement

Caused by: java.sql.BatchUpdateException: ORA-01722: 无效数字

oracle EXPLAIN PLAN FOR

ORA-24344: success with compilation error

org.springframework.jdbc.datasource.DriverManagerDataSource ORACLE11G

ORA-28001 oracle密码过期

oracle 执行sql 插入或者修改错误，由于sql长度受限的原因

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...

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.

SYSTEM登录：select * from V$FLASH_RECOVERY_AREA_USAGE;select sum(percent_space_used)*3/100 from v$flash_recovery_area_usage;

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' 不是内部或外部命令...

SELECT * FROM v$reserved_words;SUCCESSFUL 10 N N N Y NCURRENT_SCHEMA 14 N N N N NINT 3 N N N N NROWS 4 N N N Y NDANGL...

ORA-12737 Instant Client Light:unsupported server character set ZHS16GBK

1>>>>>E:\Document-Change\Oracle10g\Oracle10g_install\stage\prereq\db<?xml version='1.0' encoding='windows-1252'?><!-- Copyright (c) 2004, Oracle. All Rights Reserved. --><!-- ref host for Windows --><HOST..

ORA-12541:tns:no listenerD:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN

SELECTLISTAGG(type_app, '#') WITHIN GROUP (ORDER BY cust_no) AS typeFROMTABLE;

SELECT * FROM testWHERE 1 = 1 AND TO_CHAR(etl_dt, 'yyyy-MM-dd hh24:mi:ss') = '2020-09-18 14:15:24'AND type = 'zwf'SELECT * FROM testWHERE 1 = 1AND etl_dt BETWEEN TO_DATE('2020-09-11', 'yyyy-MM-dd hh24:mi:ss') AND TO_DATE('2020-09-18', 'yyyy-MM-dd .

SELECT * FROM test;INSERT ALL INTO test VALUES ('005129', 'zwf') INTO test VALUES ('005128', 'zff')INTO test VALUES ('005128', 'zff')INTO test VALUES ('005128', 'zff')INTO test VALUES ('005128', 'zff')INTO test VALUES ('005128', 'zff')INTO test V.

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';暂时未解决触发!

CREATE TABLE test(name VARCHAR2(200),etl_dt DATE);SELECT * FROM test WHERE TO_CHAR(ETL_DT, 'yyyy-MM-dd') = '2020-03-31';

E:\app\Administrator\product\11.2.0\dbhome_1\deinstall

ORA-28040: No matching authentication protocol

Microsoft Windows [版本 6.1.7601]版权所有 (c) 2009 Microsoft Corporation。保留所有权利。C:\Users\Administrator>sqlplus /nologSQL*Plus: Release 11.2.0.1.0 Production on 星期五 6月 12 19:33:00 2020Copyright (c) 1982, 2010, Oracle. All rights reserved.SQL> con.

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..

D:\app\Administrator\product\11.2.0\dbhome_1\deinstall\deinstall.bat

查看 java.sql.Types 类，可以找到对应类型，调整相应的数据库里的类型，或者其他支持这个类型的方言。  

SELECT * FROM T_CSEPRO_TEMPLATE WHERE to_char(founder_time, 'YYYY-MM-DD') = '2018-03-19';6 rows selected in 0.131 seconds.=============================================================================...

org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnection...

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...