Oracle

A "user" Sys\system\sysman\scott1. View all users of the database (Dba_users data dictionary):Select username from dba_users;2. View Current User:Show user;3. Enable (Unlock) database users:Alter user username account unlock;Two "table

There are 5 types of---Constraints: PRIMARY key foreign key unique non-NULL check 5 class constraintsColumn-level constraints and table-level constraints in OracleColumn-level constraints: Columns are then added to the constraint when the table is

I. DB instanceFirst, you have to have a db instance that you can create without using the following tools:The database instance created is as follows:Two. Server-side listener configurationThe following database configuration listener is configured

C # Calling stored proceduresRefer to a lot of articles, write the following text, is to share itPurpose: To change the points and make certain verificationGeneral Debugging methods:DECLAREMyresult INT;BEGINP_changevipbalance (' 018604712233 ', -1, '

Reprint: http://www.idevelopment.info/data/Oracle/DBA_tips/Advanced_Queuing/AQ_2.shtmlOverview This article provides a brief overview on configuring and Using Oracle's advanced Queuing features using PL/SQL. This would demonstrate the

Today in the company's server installed a system, in the database guide the time has not been in, was originally 10g. dmp file, import 11g, suspect version incompatible, later put the. DMP table Open, change the version number inside to 11g, and

First, the common date data format1. Get the last digit of the year, two-bit, three-bit, four-bitSelect To_char (sysdate, ' Y ') from dual; --Get the last one of the yearSelect To_char (sysdate, ' YY ') from dual; --Get the last two digits of the

Recently, in the process of learning, found a very interesting function, it can achieve the concatenation of the column values. Let's take a look at its specific usage.Usage:The official documentation for its role is explained below:For a specified

Http://www.cnblogs.com/yugen/archive/2010/07/25/1784763.htmlBasic syntax and examples:EXP: There are three main ways (full, user, table)1. Complete:EXP System/manager buffer=64000 file=c:\full. DMP full=yIf you want to perform a full export, you

--1. View the name and size of the table spaceSELECTT.tablespace_name,round(SUM(bytes/(1024x768 * 1024x768)),0) Ts_size fromdba_tablespaces T, dba_data_files DWHERET.tablespace_name=D.tablespace_nameGROUP byT.tablespace_name;--2. View the table

Online a lot of peers should have encountered this problem, Baidu a search-based treatment method, is to increase the number of processes.But my side of the situation is not the same, because my Oracle 11g is just installed in the morning, with this

1.single-row FunctionsNVLNVL2NullifCoalesceCaseDECODE2.Character functionsLOWER (column|expression)--lowercaseUPPER (column|expression)--uppercaseInitcap (column|expression)--Capitalize first letterCONCAT

--varchar,varchar2Contact:1.varchar/varchar2 for storing variable-length stringssuch as varchar (20), which is stored in the string ' ABC ', the field in the database is only 3 bytes, not 20 bytesthe maximum value for 2.size is 4000, and the minimum

pagesize: The number of records displayed per page. pagecount: The total number of pages is automatically calculated based on the user-defined pagesize and total records in the table. recordcount: The total number of records in the table.

After Oracle has been running for some time, the system will automatically give some tuning recommendations, placed in the Dba_advisor_actions view, in the main fields of the view, see below:Task_name--Optimize task NameExecution_name--Execution

In the previous Oracle view Tablespace object, I explained how to query a table space for those database objects, so can we have a data file that contains those database objects? As shown below SELECT as Segment_type as Segment_name as

In ubuntu14, download the oracle-java8, ubuntu14apt-get through apt-get1. Install jdk1.8(1) download the oracle-java8 through apt-get, first, add the ppa source, equivalent to adding a software Repository Sudo add-apt-repository ppa:

OracleORA-01555 snapshot old description ORA-01555 snapshot is too old, is a common error in the database, such as when our transactions need to use undo to build CR block, and at this time the corresponding undo does no longer exist, at this time

Concepts of User and Schema in Oracle In database theory, database users and database models are not necessarily related. For detailed explanations of database models, you can find them

Do I need to manually set the CLUSTER_DATABASE parameter when using dbua upgrade? Do I need to manually set the CLUSTER_DATABASE parameter when using dbua upgrade?Source:Is Manual Setting Of CLUSTER_DATABASE Parameter Required For DBUA Upgrade?