Oracle

Objective:The company test environment on the Oracle 11G, but the system service is not configured, now need to configure Oracle as a system service, and with the system started, did not contact Oracle Baidu a bunch, it is best to find this way the

User:Sign in to SQL PlusSystem User: Sys,system (sys>system)SysmanScott (default password Tiger)Sign in to SQL Plus with system user[Username/password] [@server] [As Sysdba|sysoper]system/123456 @orcl as SysdbaORCL is the service name that you set

1, the table's primary key, the foreign key must have the index;2, the data volume of more than 300 of the table should be indexed;3. Tables that are often connected to other tables should be indexed on the connection field;4. Fields that often

ORACLE Database Simple testOperating system: Windows 7–Oracle:oracle Database 10.2.0.4First, the purposeTest the startup listener, the database is not the same user, whether the user can log on to the databaseIi. Introduction of the

A few days ago, on the test server, install an ERP system simulation environment.In the process of installing Oracle, I encountered the Oracle's EM unreachable, today tossing a morning, finally solved.Symptoms: Just loaded Oracle 11G, is accessible,

It is well known that Oracle will take up a lot of memory when booting up, and you have to go to the computer service to find services every time you want to use it. A startup of one, more troublesome. Here are two bat scripts to directly

In the work summary sometimes the program calls the stored procedure to implement certain functions, because in this case, the speed is faster. So it's very important to learn how to debug stored procedures.First of all, open plsql development first

--company average salary single row--select avg (SAL) from EMP;--Find the employee's name, position, and salary above this average wage--select E.ename,e.job,e.sal--from EMP E--where e.sal > (select AVG (SAL) from EMP);--Name of leader--select

Do not say nonsense, paste code:1 CREATE OR REPLACE FUNCTIONTo_time (secinch Number)RETURN VARCHAR2 is2 /*Turn the seconds into a time and minute format3 Auth Lzpong 201/09/164 */5 BEGIN6 RETURNTRUNC (NVL (sec,0)/3600)||':'||SUBSTR

V$sga_target_advice: This view can be used to suggest whether the SGA size setting is reasonable.SELECT a.sga_size,--SGA Expected sizeA.sga_size_factor,--expected SGA size as a percentage of the actual SGA sizeA.estd_db_time,--SGA is set to the

-To send instructions to the content;DeclareInt_count number (10);BeginInt_count: = 0;For CC in (select T.*,t.rowid from W902053.tmp_shengchanduchu_zc t where T.flag = ' Sendok 'and T.status=1 and T.biztype = ' + ' and t.servnumber= ' 13403165550 ')

1. Find redundant duplicate records in the table, duplicate records are based on a single field (Peopleid) to determine the select * from people where Peopleid in (select Peopleid from people GROUP by people Id having count (Peopleid) > 1)2, delete

To_date is converting a string to a date type conversion function in a databaseTo_char is to convert a date or number to a stringTo_number converting characters to numbersTo_dateConvert a character to a date using the To_date functionTo_date (char, '

"Case One"Topic:--Trigger:--Add employee information, serial number as auto number (generated by sequence),--and determine if the wage is less than 0, change to 0, or 10000 if it is greater than 10000.CREATE TABLE EMP2 (E_ID number,E_no

Create user1. First login to System user SYS (SYS user has permission to create user).2. Then write the code to create the user in the Code edit box.Syntax: CREATE USER uer_name identified by password;　　Example: Create user student identified by 1234

Goldengate software is a log-based structured data replication software. GoldenGate can realize the real-time capture, transform and delivery of large amount of transaction data, synchronize the data between the source database and the target

The set operation does not apply to lob,varray and escape table columns union, intersect, minus operators do not apply to long if the selection list contains an expression or function, you must define the column alias 1, Uinon: No weight union, for

The following statements can be used to query the 11g alarm log storage path:--Show the location of the Diagnostic_dest1.show parameter diagnostic_dest; --Querying the directory of XML files2.select value from V$diag_info where name= ' diag Alert ';-

Oracle learning-Data Warehouse (2) DimensionIn a data warehouse, there are two concepts: fact table and dimension table. A fact table is a central table in the data warehouse structure. It contains the numerical measurement values and keys that

Execution of PL/SQL in Oracle and various Process ControlPL/SQL Execution and exception in Oracle I. PL/SQL Execution. Value assignment statement. There are two assignment statements: one is to define a variable and then receive the user's IO