Oracle

Oracle Knowledge Point-jobOracle The job in crontab is similar to the role of a Linux-A to perform certain operations on a timedRelated views: dba_jobs,user_jobs,all_jobs,dba_jobs_runningRelated parameters:job_queue_processesRelated packages:

//sqlplus command before backing up the database create a database DMP deposit directorySqlplus/Nologconn/ asSysdbasql> Create or Replace directory Expdir as 'E:/kxdb'; the directory was created. CMD://Export DatabaseEXPDP emms/emms123

Record the oracle12c in the process of learning.ORACLE12C new Features: http://www.cnblogs.com/kerrycode/p/3386917.html--Create a temporary table spaceCREATE Temporary tablespace admin_tempTempfile ' file absolute path '//such as: '

1. Create a new user test on the local database and grant the following basic permissions (try not to authorize more, such as local permissions larger than remote, will cause the export failed, depressed!). ):Grant connect to test;Grant resource to

Dblink used in the database is more, simple and convenient. However, with the enhancement of Oracle security, normal user login can only be seen, user name and connection string. So how does the dblink password look?Very simple, requires SYS account

BrieflyCola in (x, Y, z) is equivalent to cola=x or cola=y or cola=zCola not in (x, Y, z) is equivalent to! (Cola=x or Cola=y or cola=z) is equivalent to Cola!=x and Cola!=y and Cola!=zBesides Cola=null and Cola!=null, the results of both

The stored procedures are as follows:Create procedure gokul_proc( pId in number, pName in varchar2, OutCur OUT G_PKG_REFCUR.rcDataCursor ) isBEGIN Open OutCur For select * from gokul_table ob where ob.active_staus-‘Y‘ AND

Oracle Data Pump Import and export case  oracle database Import and Export tool, you can use Exp/imp, but this is the older tool. This paper mainly introduces the use of data pump EXPDP/IMPDP tools. Establishing a data pump catalog using a data pump

4 states of Things in Oracle:commit--Submitrollback--All rolls backSavePoint name;--defines a point that rolls back to here: for example: SavePoint A;Rollback to [savepoint]name--rollback to a specified point such as rollback to A; roll it back to a

Excel connection column names generate Oracle annotationsNOTES:A2 is a column name, B2 is a comment= "Comment on column colagreementheader." &A2& "is Q ' {" &B2& "} ';"The effect is as follows: Comment on column table1.

1.oracle Dictionary Table Query /* Show Current User */show users available in SQL Plus, unavailable in PL SQL/* View all user names */select username,user_id,created from all_users;/* View user details for the current user */ Select

Original Sticker Address: http://19880614.blog.51cto.com/4202939/1316560PS: There are many errors in the source code, I have modified---------------------------------------------This is a split line----------------------------------------------------

How to query duplicate data and delete duplicate records in Oracle For example, there is a personnel table (table name: peosons) drop table PERSONS; create table PERSONS (PNAME VARCHAR2 (50), CARDID VARCHAR2 (18), ADDRESS VARCHAR2 (100 )); insert

Importing Oracle backup data to other tablespaces (only setting the default tablespace is invalid) When importing an Oracle backup data file (*. dmp) to another database user, you can use the following methods to replace the tablespace. Assume that

Oracle update, order by, oracleorder Today, I encountered a problem about converting SQL statements into Oracle statements, which is described as follows: Select * from emp orderby deptno; Select * from dept; SQL Server: Update dept a set

Oracle data types, functions, and stored proceduresString typeFixed Length: char nchar n indicates Unicode encodingVariable Length: varchar2 nvarchar2Number Type: number (P, S) P: integer digits, S decimal placesIntegerBINARY_FLOAT Single Floating

ORACLE11g poisoning recovery   Unfortunately, the win2003 server is neglected to manage and poisoned. After the virus is cleared, oracle is paralyzed. What should I do if the last backup is still one week ago?The first idea is to find another

Oracle table organization and Data Replication 1. Copy the table structure and data to generate a new table: Create table table_name_new as select * from table_name_old; 2. copy only the table structure: Create table table_name_new as select *

Oracledatabasewrc execute an error ORA-15557 [Oracle @ host capture] $ wrc system/oracle @ db1 REPLAYDIR =/home/oracle/cap_dir/Workload Replay Client: Release 11.1.0.7.0-Production on Sun Jul 19 17:16:56 2015 Copyright (c) 1982,200 7, Oracle. all

Oracle Stored Procedure Definition and debugging, and finally called code by C # C # Call a stored procedure I have read a lot of articles and wrote the following text to share it. Purpose: To change the credits and perform a certain