Oracle

--Count The length of stringSelectLENGTHB ('SELECT * from Scott.emp') asCountted_by_byte, Length ('SELECT * from Scott.emp') asCountted_by_char fromdual;--for some character encoding, the length () and the LENGTHB () are same in 中文版--feature to

Also referenceHttp://www.linuxidc.com/Linux/2012-08/69082.htmHttp://www.linuxidc.com/Linux/2013-10/91270.htmFirst, hardware detection1, memory detection oracle11g minimum 1GB memory requiredgrep Memtotal /proc/meminfo2, swap space detection usually

As mentioned above to create a data restore point, the premise of data recovery is that we use the Delete command when deleted, delete will write the log during the deletion (so that our data can be recovered), of course, the write log will cause

Oracle's memory configuration is tied to Oracle performance. In general, it can be divided into two chunks: the shared portion (mainly the SGA) and the process-exclusive portion (mainly the PGA). In Oracle versions under 32-bit operating systems, it

User roles in Oracle are categorized into predefined roles and custom roles.The role is to centralize common permissions to form roles.Authorization/Assign Role commandsGrant permissions/Roles to usersRevoke permission command:RevokeComprehensive

One, import. sql file@data. sqlSecond, record the log:1. Enter command sqlplus database name/password @ Database Press ENTER2. Enter spool to specify the path: \a.log Press ENTER (This step is to track the bulk of SQL log, the path to write, as long

The use of the--oracle trunc () function/************** Date ********************/1.select trunc (sysdate) from dual--2013-01-06 today's date is 2013-01-062.select trunc (sysdate, ' mm ') from dual--2013-01-01 returns the first day of the

1. Create a new user (normal)Create user username identified by passwordexample, create a user named Xiaoming, with a password of XM2. Change the password to a normal user as an administrator (when the average user forgets his or her password)Alter

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

--create a stored procedureCREATE OR REPLACE PROCEDURExxxxxxxxxxx_p (--The parameter in represents the input parameter, out represents the input parameter, and the type can use the legal type in any Oracle. Is_yminch CHAR) as--Defining

1. Parse tables and indexes (analyze does not rebuild the index)Analyze table TableName COMPUTE statisticsEquivalent to analyze table TableName compute statistics for table for all indexes for all columnsStatistics for table exist in views:

If a user fails to log on for three consecutive times, the user is locked out for two days and two days later before the user can log on again.To create a profile:Update your account:Users will be locked out after three login failures:How to unlock

Oracle Database System is one of the most popular databases of customer, server (client/server) or b/s architecture in the United States, a group of software products provided by Oracle Corporation with distributed database as its core. For example,

Restart the Oracle database and listener under Linux: Method 1: Log in to Linux with root SSH and open the terminal to enter the following command: CD $ORACLE _home #进入到oracle的安装目录Dbstart #重启服务器Lsnrctl Start #重启监听器CD $ORACLE _home

How to grant users the permission to view Stored Procedure definitions only A user asked me how to grant a user the permission to view the definition of certain stored procedures, rather than letting the user modify or execute the stored procedure.

Oracle & amp; mysql Log InformationPreface The log information here refers to the log information used to perform command operations on the command line.Oracle1. Import and Export: imp omjx/ppet1205 @ xforcl full = y file = full path \ xf. dmp log =

[SQL entry level] First day of SQL preliminary, first day of SQL entry level SQL statements are categorized into the following types: DML: Data Manipulation Language DDL: Data Definition Language DCL: Data Control Language 1. Basic

Oracle Database Installation in Windows and OracleSQLDeveloper (graphic description) Problem: Install the Oracle database in windows Step: Use the URL"Http://www.oracle.com" to open the Oracle official website home page, click Downloads to enter the

Oracle multi-Table queryBasic multi-Table query syntax The implementation of cartesian products in SQL is not only Cross Join ). All join methods are converted into temporary Cartesian Product tables. Cartesian product is a concept in relational

Oracle442 application scenarios ---------- database instances The Application Scenario 1-7 is the installation process of Oracle. Here, I will explain a lot about it. There are a lot of materials on the Internet and it may be added