Oracle

EXPDP:Sql> Create directory Dir_tables as '/home/oracle/tables ';Sql> Grant Read,write on the directory dir_tables to user name;EXPDP system/system password @sid tables= user name. Table name Directory=dir_tables dumpfile=tables.dmp

Create a database1 Creating an Oracle database using the Database Configuration Assistant toolStep One Action windowThere are 4 choices. A CREATE Database B metabase option C Delete database D Administrative TemplatesStep Two Database Template

Create or replace trigger [email protected]@  before insert or  update or delete on @[email protected]  referencing old as  old_emp new as new_emp  for each rowbegin  --when modified by the application, F_ Sync_update=null or f_sync_update=0, you do

Sql>set Colsep '; -Field Output delimiterSql>set echo off; Displays each SQL command in the script started by the start, which defaults to onsql> set echo on //Set whether the Run command is to Display statementsSql> set feedback on;

Oracle Tablespace and user creation1. Plsql, log in with Administrator account2. Create tablespace test datafile ' D:\test.ora ' size 1000m;--creating table space, test for tablespace name3. Create user test identified by test default Tablespace

1. Copy table structure and table dataCREATE TABLE Table_new as SELECT * from Table_old2. Duplicate table structureCREATE TABLE Table_new as SELECT * from Table_old where 1<>13. Copying the specified fields of a tableCREATE TABLE Table_new as select

1, GROUP by ROLLUP (A, B): can achieve a simple statistical report, the equivalent of group by a, B, then group by a, then GROUP by *2, Break on a SKIP 2: With the group by rollup, the break on a means that the same a only display 1 times, SKIP 2

And the advantage of the essay is that you can force yourself to learn, what you did not want to learn today, or how much to learnIn the afternoon by a bug, just the two days of interns have been on leave, had to self (but today this matter interns

/*** Copy any row in the Oracle table and change the corresponding sequence* /DeclareCursor Dept_cursor is a select * from Scene_pic WHERE picid= ' 63563908576556815641 ';BeginFor Dept_rs in Dept_cursorLoopDept_rs. picid:= ' 63563908576556815642

1. Modify the host name:# sed-i "s/hostname=localhost.localdomain/hostname=oracledb/"/etc/sysconfig/network# hostname OracleDB2. Add resolution host name record# vi/etc/hosts192.168.1.11 OracleDB3. Installing dependent Packages# yum-y Install glibc*

Java programs Packagecom.test;Importjava.sql.CallableStatement;Importjava.sql.Connection;ImportJava.sql.ResultSet;Importjava.sql.SQLException;Importjava.sql.Types;ImportCom.jdbc.BaseJdbcDAO;Importoracle.jdbc.OracleTypes; Public classTest {/***

[Email protected] ~]# su-oracle[Email protected] ~]$ Sqlplus/nologSql> Conn/as sysdba;Sql> Show user;USER is "SYS"Sql> select name from V$datafile;Create a temporary table spaceCreate temporary tablespace xsgj_tempTempfile

Today's study of Oracle encountered this problem ora-01033:oracle initialization or shutdown in progress, after the analysis of the study finally solved, write down a memorial. My library is Oracle 9i, specifically 90.First of all: the cause of the

Did not expect May full one months not to write essays, I always so, three minutes of heat, it is difficult to stick down. May almost no weekend, are working overtime, evening also often overtime, but fortunately, do not feel tired, but the Dragon

Reference documentsDocument 1:HTTP://BLOG.ITPUB.NET/24104518/VIEWSPACE-730682, character format, need to clean up a bitLiterature 2:http://www.cnblogs.com/fengyun627/archive/2009/07/27/1532551.htmlLiterature

Select COUNT (1), Features_level from (SELECT i.features_level, I.features, t.baseamine_id, T.column_name, V.column_value, v.detail_id,(case when i.features = ' count ' and v.column_value = ' NG ' then 0 when ( I.features = ' metering ' and v.column_

Friendly tip: Please be in business idle is operation. Why is it?--oracle 11g  interval partition (INTERVAL) Rename, batch generate rename partition script set linesize 180set serverout  ONDECLAREV_TABLE_OWNERVARCHAR2 (100)  :=  ' op% ';

1. Delete the lexical parserexec ctx_ddl.drop_preference (' my_lexer ');2. Create Chinese lexical parserexec ctx_ddl.create_preference (' my_lexer ', ' chinese_vgram_lexer ');3. Create full-text index, multi-fieldEXEC ctx_ddl.create_preference ('

In the development process, encountered a problem: in the Oracle database, using the PL/SQL database development tools to develop, a field length can not meet the requirements, the following syntax to modify the lineALTER TABLE name modify field

Select T.YYDM,T.YYDJ,T.jsny,T.xzlbzh xzlb/*,(Select Item_nameFrom TB_DIC_FYSHJS_BBLBwhere item_id = T.xzlbzhand Valid_flag = ' 1 ') xzlbmc*/From (select YYDM,(select YLJGMC from tb_dic_ddyljg where YLJGDM = YYDM) YYMC,(Select YLJGLBMCFrom [email