Oracle

Unconsciously also 10 days, weekends and overtime, I would like to take a half-day Monday morning to see the final NBA Finals ... Later, after all, is not a hardcore fan, back in the evening to repair the video to see the collection good.Company A

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

Upload the Oracle installation file to the Linux server first1. Unzip the zipUnzip Linux.x64_11gR2_database_1of2.zipUnzip Linux.x64_11gR2_database_2of2.zip2. Create the installation directoryMkdir/opt/oracle3. Create a user group:Groupadd

1. Standard SQL specification1 One, single if2 1,3 4 ifA=... Then5 .........6 End if;7 8 2,9 Ten ifA=... Then One ...... A Else - .... - End if; the - two or more if - - ifA=.. Then + ...... -Elsif A=.. Then + .... A End if; atThe middle here is "

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

I have to work overtime on weekends ... Do a lot of learning, and continue to watch the tutorial tonight, multi-table query1, Cartesian product: Multi-table should pay attention to2, outside the connection: Before a record, that is (+) This writing,

How do I create a tablespace in Oracle? There are two main ways: one is to use SQL commands, and the other is created by the Oracle Client Enterprise Manager console. Here are a few separate sections:1 Create a tablespace from SQL command1.1

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;

DescriptionCreating a stored procedure is much like writing a normal PL/SQL program, such as including the life part, the execution part, and the exception part. But there are a lot of differences between the two implementations, such as: Creating a

1, check the user's proifle is which, is generally default:Sql>select username,profile from Dba_users;2. View the password expiration settings for the specified profile (such as default):Sql>select * from Dba_profiles s WHERE s.profile= ' DEFAULT '

Oracle text and format string mismatch resolutionDate-Time type for OracleRemember to use the To_date () method when inserting data into the date type of Oracle.such as insert into Cuslogs (STARTTIME) VALUES (to_date (' 2009-5-21 18:55:49 ', '

Query and delete duplicate records of SQL statement 1, find redundant records in the table, duplicate records are based on a single field (ID) to determine the select * from table where Id in (the Select ID from table group Byid having count (ID) > 1

One: Start Oracle[Email protected] ~]# su-l Oracle[Email protected] ~]$ Sqlplus/nologSql*plus:release 10.2.0.4.0-production on Mon June 13 14:11:16 2016Copyright (c) 1982, Oracle. All rights Reserved.Sql> Conn/as SYSDBA Connected to an idle instance.

Http://www.cnblogs.com/chen1388/archive/2010/07/06/1771919.htmlDecode function:Decode (AA, 1, ' XS ', 2, ' ps ', ' MS ')Equivalent(Case AA If 1 then ' XS 'When 2 Then ' PS 'Else ' Ms

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

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 {/***

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