Oracle

1. Log in to SQL Plus with SYS user as SYSDBA and use Dba_users view to view user information: SELECT USERNAME, Account_status, CREATED from dba_users;--user name, account status, date of creation of the user 2. Create user, delete

I. Buffer overflow,limit of 10000 bytesDeclareBeginFor C in 1..1000 LoopDbms_output.put_line (' Test and test test ');End Loop;EndThe default size of the buffer is 10000 bytes. Loop 1000 times on a total of 6,000 Chinese characters, namely 12000

Rights Management1, default of three users2, create user3, Authorization, REVOKE permissions4, System permissions and object permissions5, role6, Manage permissions by role7. How to pass the permission, lose the administrator password3 Default

AWR snapshotBy default, Oracle automatically generates a snapshot every hour, saving a snapshot for the last 8 days.We can get the time interval and number of days to generate the snapshot by using the following statement:[Email protected] (lx15) >

Depending on the requirements of the project, PHP is required to transfer data from Oracle (on another machine). Because it is on the window platform (my environment is Win32 XP), the first thing to think about is the PHP OCI8 extension.Since I have

Motivation:You want to do insert/update directly with an SQL statement in Oracle.DescriptionWhen writing SQL statements, we often encounter a large number of simultaneous insert/update statements, that is, when there is a record, it is updated

First, the premise installation1. Need to install QT5.2.0, the introduction of the installation is Qt-windows-opensource-5.2.0-mingw48_opengl-x86-offline.exe;This article installs the directory: c:\Qt2. Install the Oracle client,This article is

SelectT.column_name,t.data_type, C.comments fromAll_tab_columns T, user_col_comments cwhere 1=1 andC.table_name=T.table_name andC.column_name=T.column_name andT.owner='ATS001' andT.table_name= 'entities'minusSelectT.column_name,t.data_type,

1, manually change the size of the data fileSql>conn/as SYSDBASql>createtablespace exampletb datafile ' e:\ examp01.dbf ' size 10M;Sql>alter database datafile ' E:\examp01.dbf ' resize 20m;Sql>alter database datafile ' E:\examp01.dbf ' resize 9m;2.

Turn: http://blog.csdn.net/clever101/article/details/1792075  Last Saturday, I took the time to learn about Pro * C/C ++. I used the reference book "proficient in Oracle 10gPro * C/C ++ programming". In my opinion, the Pro * C/C ++ syntax is not

1. with table as is equivalent to creating a temporary table (for SQL statements that place some intermediate results in a statement in a temporary tablespace). Oracle 9i adds the WITH syntax to name subqueries in the query, put it at the beginning

The database versions provided by oracle for individuals and enterprises are exactly the same, as long as they are not commercially available, we can use them for free as a good choice for learning. Oracle is used to learn the database in Dana, so

An index is an optional structure maintained by Oracle to provide quick access to data. It is difficult to accurately determine where an index needs to be used. Using an index helps adjust the search speed. When creating an index, you must specify

Although the table has been created, it cannot be checked whether the data in the table is legal. If you want to filter the data in the table, you can use the constraints, the main function of a constraint is to ensure the validity of the data in

Those who often write SQL should be exposed to oracle date and time functions. For example, financial software or human resources software should be collected every year, quarter, month, or even Week. Today, I am free to wait. I specially sorted out

1.1.1 RMAN-08138 Date: Environment: test environment [Scenario description] On the test machine, when RMAN is used to delete archived log files, a WARNING is prompted, and archive logs cannot be deleted. [Error message] RMAN> delete archivelog all

1.1.1 ORA-19573 Date: Environment: test environment [Scenario description] When the database instance is in the OPEN state (read write), an error is reported when the database restoration and restoration operations are performed in RMAN. [Error

Chapter 2 asm instanceasm instance type: After 10 Gb, an ASM type is added to the ORACLE instance type. Set the parameter INSTANCE_TYPE = ASM.ASM instance startup command: startupNomountStart the instance and background process, but no disk group is

Permission management1. The default three users2. Create a user3. Grant and revoke permissions.4. System and object permissions5. Role6. manage permissions through roles7. What should I do if the administrator password is lost during permission

ASM single point of failureUsers are often asked about best practices for avoiding ASM spof. As with other file systems or volume managers, failure of the ASM instance will cause the RDBMS instance running on to become unavailable. However, failure