Oracle

I. Related content1. Verify system Rights Management.2. Verify role management.3. Verify profile Management.Second, the specific operationA1. Grant and recycle the system permissions according to the following requirements:(1) Create a user User1

Both of these methods can be used in Sqlplus:EXEC pro_name (parameter 1:);Call Pro_name (parameter 1:);Difference:1. But exec is a sqlplus command and can only be used in sqlplus; call is a SQL command with no restrictions.2. When the stored

--Create TableCreate TableCOURSE (CNOVARCHAR2(5) not NULL, CNAMEVARCHAR2( -) not NULL, TNO Number not NULL) tablespace USERS pctfreeTenInitrans1Maxtrans255Storage (initial 64KNext1M minextents1Maxextents Unlimited);--Add comments to the

CREATE TABLE SpaceCreate Tablespace BOSSTempfile ' d:/oraclexe/boss.dbf 'Size 500MAutoextend on next 50M maxsize 4000M;Delete Table spaceDrop tablespace BOSS including contents and datafilesmodifying character setsALTER SYSTEM ENABLE RESTRICTED

Archive Log (Archive log) a non-active redo log backup. By using the archive log, you can keep all the redo history, when the database is in Archivelog mode and log-switched, and the background process arch will save the contents of the redo log to

Reference article, original address: http://blog.csdn.net/cicada688/article/details/7802881Problem 1:sqlserver database goes directly to Oracle. field types are converted to Oracle type by type of SQL ServerProblem 2:sql Server field is

Recently Idle, researched the next Oracle, the following is the entire process of installing Oracle under Win7:Then unzipClick setup.exeI'm using the default installation D drive.The database password is Wangxiaofei.NextFirst on your own Windows 7

Navicat for Oracle is primarily used for the management and development of Oracle databases, with an intuitive and powerful graphical interface that brings new experiences to Oracle database users. This navicat tutorial will illustrate the NAVICAT

1. Turn off all Oracle services. Can be turned off in the Windows Service Manager;2. Open the registry: Regedit Open path:Hkey_local_machine\system\currentcontrolset\services\ removes all service names starting with Oracle under this path, which is

today, at dinner, my friend's database has a problem, CPU occupancy is 97%, when I see this problem, I think of the SQL is probably the cause of this problem, because can't help eating, temporarily did not help him to see this problem, this is my

First, the concept of ROWIDStores the location of row in the data file: 64-bit encoded data, A-Z, A-Z, 0-9, +, and/,How row is stored in the data blockSELECT ROWID, last_name from hr.employees WHERE department_id = 20;For example:

1. Introduction to relational databaseThe basic concept of relational data (relational database) is very simple to understand. A relational database is a set of related information that has already been organized into a table structure. Each table

--1. Character functions--upper (String|column) can turn characters into uppercaseSelect Upper (' Helloword ') from dual;Select Upper (ename) from EMP;--lower (String|column) converts the specified string to lowercaseSelect lower (' Helloword ')

Before you forget it, record it. Oracle's RowNum principle and use (finishing a few people's posts) Organized and learned a bit about the online master about RowNum posts:Reference: http://tech.ddvip.com/2008-10/122490439383296.htmland

ObjectiveThe problem of correcting that detail is because there was a scene like this before:A classmate, gave me a statement of the database, asked, why such a statement can not be executed under the Oracle statement.SELECT * from xx where xxx is

Features of temporary tables:(1). Oracle allocates storage space for users only when they add data to the table. (2). allocate space for temporary tables from temporary table spaces , avoiding storage space with data from persistent objects;

SQL statement for querying and deleting duplicate records1, look for redundant records in the table, duplicate records are based on a single field (ID) to determineselect * FROM table where Id in (select ID from table group Byid have count (Id) > 1) 

Tag:oracle    Delete table     Delete user     user query     Query all user information in Oracle, delete users, tables, prohibit foreign keys, etc.  1. View all Users: Select * from dba_users;   select * from all_users ;

Database backup (Export):First: Connect DBA database method: Connect database with SYSDBA, user name: sys password: OracleThe first method:Sqlplus/nologConn Sys/[email protected] as SysdbaThe second method:Sqlplus Sys/[email protected] as SysdbaI.

WebLogic configuration details: "WebLogic Installation and Configuration Diagram"Oracle+plsql configuration details: "PL/SQL access to remote Oracle Server (multiple Ways)"MyEclipse configuration: "Eclipse in the development of Web project