共 15 篇文章 |
|
linux 启动oracle。su oracle。sqlplus /nolog.connect /as sysdba. 阅35 转0 评0 公众公开 17-03-02 17:00 |
阅55 转0 评0 公众公开 15-04-25 19:55 |
SQL> select to_char(0.258) from dual;TO_CHAR (number) converts n to a value of VARCHAR2 datatype, using the optional number format fmt.原来to_char在做转化时,如果你不指定可是,它就按它的格式去做转化,结果就把0给转不见了,所以在做转化时要给定格式。update AGRRESIDXRECORD t set t.agrresidxval = to_char(t.agrresidxval,... 阅995 转0 评0 公众公开 15-04-08 15:31 |
阅41 转0 评0 公众公开 15-03-27 16:24 |
ALLOCATE EXTENT使用样例:ALLOCATE EXTENT ALLOCATE EXTENT(SIZE integer [K | M]) ALLOCATE EXTENT(DATAFILE ''filename'') ALLOCATE EXTENT(INSTANCE integer) ALLOCATE EXTENT(SIZE integer [K | M] DATAFILE ''filename'') ALLOCATE EXTENT(SIZE integer [K | M] INSTANCE intege... 阅67 转0 评0 公众公开 15-03-13 12:34 |
oracle 数据导入导出一、导出1.使用exp命令导出C:\oracle\product\11.2.0\dbhome_1\BIN\exp.exe sisims/sisims log=C:\sisims.log file=C:\Users\kenneth\Desktop\sisims-two.dmp touser=sisims ignore=yes tablespaces=SISIMS. 阅147 转0 评0 公众公开 15-03-01 18:01 |
oracle 系统表查询1、查询包含CLOB'',''BLOB'',''LONG‘的表select table_name from user_tab_columns where data_type in (''CLOB'',''BLOB'',''LONG'') 阅37 转0 评0 公众公开 15-02-10 14:56 |
阅246 转0 评0 公众公开 15-02-06 20:46 |
阅854 转10 评0 公众公开 15-02-06 14:18 |
oracle 11g 远程连接配置(服务器端)修改 ORACLE_HOME/network/admin/目录下面的tnsnames.ora和listener.ora文件。SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = C:\oracle\product\11.2.0\dbhome_1) (PROGRAM = extproc) (ENVS = "EXTPROC_DLLS=ONLY:C:\oracle\product... 阅7668 转31 评0 公众公开 14-12-12 10:23 |