Oracle

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. First ensure that server port 1521 is turned onA. 1521 exception to firewall port increaseB. Firewall program add Oracle.exe exception (I don't deserve this)C. telnet 192.168.74.130 1521 test to be connectedError I encountered: Unable to open

Create DatabaseLink Jtkhjfdbconnect toKHJF identified byhellousing'( DESCRIPTION = (Address_list = (ADDRESS = (PROTOCOL = TCP) (HOST = 10.196.57.197) (PORT = 1521)) (Connec T_data = (service_name = Jtkhjfdb )))';SelectParty_id,realname

Using the Oracle official file (11G) exampleHere is the Oracle Official document interface, to learn about Oracle, the only way to read official documents is to get an overview of official documentation and a more intuitive understanding of official

Characteristics of the transaction (ACID)A (atomacity) atomicity: A transaction is a whole, and the processing statement that makes up a transaction forms a logical unit and cannot execute only part of it.C (consistency) Consistency: database is

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

Oracle 11g Settings Memory Auto-management:ALTER SYSTEM SET memory_target = 1024M scope=spfile;ALTER SYSTEM SET memory_max_target = 1500M scope=spfile;ALTER SYSTEM SET sga_target = 0 scope=spfile;ALTER SYSTEM SET sga_max_size=800m scope=spfile;ALTER

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

SELECT * FROM (select T1. table_name as "table name", t3.comments as "table description", T1. column_name as "field name", T1. Data_type as "data type", T1. Data_length as "Length", T1. NullAble as "is empty", t2.comments as "field description", T1.

TNS

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 (Numtodsinterval (NVL (sec,0),'Second'), the,5

This is written by a master in my collection to remind myself of Oracle learning Route1, SQL, PL/SQL (There are a lot of videos online, you can do a simple start, then read a few books, do more experiments）As the basic skill of Oracle, we need to be

"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

1. Databases and instancesWhat is a database, in fact, is very simple, the database is a medium for storing data. For example, the commonly used file is one, in oracle10g, the data storage has several kinds. The first is the file format, which is to

Operation Steps: (Open archive)In either node operation:[[email protected] ~]$ srvctl stop database -d mecbs[[email protected]  ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production  on mon sep 14 23:24:19 2015copyright  (c)

CREATE TABLE SpaceCreate tablespace usersDataFile ' D:\Oracle\oracle\oradata\users.dbf 'Size 100mAutoextend onNext 100m maxsize 20480mExtent management Local;Create userCreate user hy_pubres identified by 123;             Grant Create session to

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

The stored procedure is used to determine whether a person stays in the path of a day beyond the specified time.1. Problem Description In a project, the patrol staff's hand-held GPS will report the location of the staff to the total database at a