Oracle

For the sake of convenience, the following simple models are established and some test data are constructed:In a business admissibility subsystem BSS,SQL Code --customer data sheet Create table customers ( customer_id

In many cases, a database is just a few blocks of data file corruption. In this case, of course, we use database recovery or data file recovery to solve the problem. But the feeling of a little flak hitting the mosquitoes. Fortunately, Rman provides

Many of these days work around Oracle functions, and here's a summary of the functions that have been used in the work these days. In fact, it is not a summary, is to use these days for Oracle to make a simple list of knowledge. Returning data

Yesterday, a colleague asked some questions about Oracle Tablespace data file Self-growth, in the process of the way to organize, and other colleagues have the same questions can be directly consulted.Experimental content: Creates a mytest

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

1. Select * FROM your_table t//query your_table for all data, you can see three data2. Delete your_table//delete all data in your_table, three data disappears3. Select * FROM your_table t//No data.4. INSERT INTO your_table SELECT * from your_table

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

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

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

Accessing other Oracle database data from Oracle Data Create a database link in the local oracle databaseDrop database link mydblink;Create database link mydblink connect to zszq identified by "zszq" using '192. 168.0.175: 192/orcl '; SQL> DROP

In oracle, how does one obtain the local IP address and the domain name based on the IP address?----- Resolve the ip addressSQL> select utl_inaddr.get_host_address ('Google. com') from dual;UTL_INADDR.GET_HOST_ADDRESS ('Google. com ')----------------

Oracle11gexp export problem: some tables cannot be exported An issue found during command exp export from oracle is that some tables cannot be completely exported. After checking, it is found that any blank table cannot be exported. In the

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