Oracle

Some time ago learning Oracle To do the study notes, organized a bit, the following is a share of the Oracle common functions of some notes, and later will share other parts of the notes, please criticize correct.Use of the To_date () function in a 1

Recently read Oracle data, understand the concept of rownum, previously only known to the database table simple additions and deletions; After seeing the concept of rownum, I suddenly thought that a lot of business scenarios should be applicable,

1. System Kernel parameter setting Cat >>/etc/sysctl.conf RHEL 6 Shmall and Shmmax are configured to use the default settings, Shmmax is generally set to half of the system memory, 4195057664=4GB After modification, the Execute command takes effect:

I. Naming rules for table and column names1), must start with a letter2), length cannot exceed 30 characters3), cannot use Oracle's reserved words4), use only the following characters a-Z,a-Z0-9, $, #等 ii. data type1), character classesCharfixed

1. Create a table2. Create a stored procedureValues3. Create a timer job and specify it to be executed once a minuteDeclare numberbegin'job_proc;' TRUNC (sysdate, 'mi') + 1/(24*60)'end 4. Test View Table Data5. Stop TimerRight-click Edit to

There are three kinds of permissions for Oracle:Object Privileges Objects PermissionsRole Privileges Roles PermissionsSystem Privileges Systems Permissions(i), object permissionsIn general, object permissions are for a user access to certain tables,

Please note: Be careful to modify read checkpoints and write checkpoints for each process of Oracle GoldenGate (OGG). Make sure you have mastered the specific meanings of read checkpoints and write checkpoints for each process in Ogg.BEGIN {now |

First, IntroductionThis section focuses on how to manage permissions and roles in Oracle, and what the difference between permissions and roles is.When a user is just established, the user does not have any permissions and cannot perform any action.

Due to business needs, you need to use whitelist to restrict the address of user login database, decide to use database whitelist function!In general, but the instance database startup whitelist only needs to add the following to the Sqlnet.ora:TCP.

The content mainly includes:(1) Three kinds of cycles and their simplification(2) Use of cursors(3) Exception handling(4) Stored procedures(5) Storage function(6) Trigger(7) Other PL/SQL operationsDefine variables---------------Loop loop-------------

Oracle Table SpaceThe biggest difference between a SQL Server database and an Oracle database is a tablespace design. Oracle database pioneered the design concept of tablespaces, which made an indelible contribution to the high performance of Oracle

I am in the process of learning Oracle's own sentiment and the online other great God's experience, there is nothing wrong place hope everyone correct!Principle One: Note the connection order in the WHERE clause:Oracle uses a bottom-up sequential

--Creating table Create [GLOBAL Temporary] table table_name (coloum_name TYPE [CONSTRAINT constraint_def DEFAULT Default_exp][,colou M_name TYPE [CONSTRAINT constraint_def DEFAULT default_exp] ...]) [on COMMIT {DELETE | PRESERVE} rows]tablespace Tab_

Inserting an article (1000~2000) into the Clob property of a database today in a project will report an error with a string that is too long.The internet says to deal with the stream, not to do so. This is like a bug, as long as the inserted data,

I. What is Oracle archive modeThe Oracle database has an online redo log, which records changes made to the database, such as inserting, deleting, updating data, etc., which are recorded in the online redo log. A generic database must have at least 2

Tables tableTest table: My_test_table--Create tablecreate table my_test_table ( A VARCHAR2 (), B number (Ten) default 1, C DATE) tablespace bosswg_ CFG pctfree initrans 1 maxtrans 255 Storage ( initial 64K minextents 1 Maxextents

OracleDBA user management, oracledba user management I would like to share with you the management of users in Oracle. The following are my Oracle learning notes stored on the database. I will share them with you today. For more information, see the

Oracle primary key deletion, joint primary key Creation1. Delete the primary key alter table tablename drop PRIMARY_KEY execute the preceding SQL statement to delete the primary key; if it fails, use ALTER TABLE TABLENAME DROP CONSTRAINTS COLUMN

Adjusting the size of oraclesga causes ORA-00851 and ORA-00844 errors Today, I adjusted the sga size. As a result, the following error is returned when I restart the database.SQL> alter system set sga_max_size = 1024 M scope = spfile;SQL> shutdown

Oracle ?????????????? :&?? '??????????????, Oracle ???????????????????? Oracle ???????????????????????? Toad ?????????????????????? AMP ???????????????????????????????????? Insert ??????????????????????????????????????? ????????? AMP ????????????????