Oracle

1:DDL statementsCreate a student tableCREATE TABLE Stu (ID Number (6) is not NULL,Name VARCHAR2 (20),Age Number (3),Gender char (1) Default ' m ',Grade number (1),Class VARCHAR2 (Constraint STU_CLASS_FK foreign key references class (ID),Email

Environment: Centos7+oracle 11GR2Public network: Fixed IPSymptom: 1521 port normal, netmanager configuration test Normal, PLSQL connection hint Ora-12514:tns:listener does not currently know of service requested in Connect

The oracle11g password file is under directory/u01/app/oracle/product/11.2.0/dbhome_1/dbscommand to create a new password fileOrapwd File=orapwcapaas (orapw+ database sid) password=oracle123 (SYS user's password) entries=10 (maximum number of

At the same time, modify Tnsnames.ora, Listener.ora the two files in the host behind hosts are modified to 127.0.0.1 and then restart Oracleservicexe, Oraclexetnslistener servicesListener.ora file revised toSid_list_listener = (Sid_list = (Sid_desc =

Create a temporary table spaceCREATE Temporary tablespace test_tempTempfile 'C:\oracle\product\10.1.0\oradata\orcl\test_temp01.dbf'SIZE 32MAutoextend onNEXT 32M MAXSIZE 2048MEXTENT MANAGEMENT LOCAL; Create a user table spaceCREATE tablespace

Create user user name password is sqltrain Create user Sqltrain identified by SqltrainAssigning permissions to user names Grant resource,dba,connect to Sqltrain;Change Password alter user Sqltrain identified by SqltrainLock user alter user

Starting early this month to learn Oracle, because it is completely 0 start, from the beginning of the installation of Oracle Download 1.1 to learn, today the system has been re-done, and then installed again ORACLE11GR2, the installation process to

Call the stored procedure with exec.A stored procedure with parameters.sql> CREATE OR REPLACE PROCEDURE HelloWorld1 (2 P_user_name VARCHAR23) as4 BEGIN5 dbms_output.put_line (' Hello ' | | p_user_name | | ‘!‘);6 END HelloWorld1;7/Procedure

After the Oracle installation is complete, find the SQL plus run in "Start" and ask for an account number and password to connect with the system/password.1. Oracle has a default Scott account password Tiger, which is connected using this

Graphic:650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M02/7E/37/wKioL1b6H1iBrQXeAACDFHtuFR0203.png "style=" float: none; "title=" 1.png "alt=" Wkiol1b6h1ibrqxeaacdfhtufr0203.png "/>650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/7

Graphic:650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/7E/3A/wKioL1b6N_ngz_LiAAEDbMFF_uU202.png "style=" float: none; "title=" 1.png "alt=" Wkiol1b6n_ngz_liaaedbmff_uu202.png "/>650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/7

40. Installation Steps of Oracledatabase11g in Windows XP Example of how to install Oracle11g R2 on Windows 7 32-bit operating system. Let's just talk about it. 1. Extract the two oracle 11gR2 packages to a separate folder. 2. Find setup.exe in the

Install and use Oracle in windows I. Download the oracle database from the official website Here I downloaded oracle 11g r2, and selected the corresponding download file based on my operating system. Here I am windows 64-bit, so select the second

0005 SQL note Note 01-SELECT statement, select statement example 1. SELECT basic statements: SELECT field name 1,..., field name n FROM Table Name 2. Search all fields and replace the field name with "*", which leads to inefficiency. SELECT * FROM

PL/SQL Developer exports data scripts and data, pldeveloper If you only Export the table structure (Table creation statement) and do not Export the table data, you can use Tools -- Export User Objects. Select the table to be exported, set the Export

Oracle study Note 5 --- Table queryThe scott user is used below. The tables used are shown at the bottom.1. view the table structureDesc [Table name] desc emp2. Run the distinct command to remove duplicate lines.3. ExerciseSelect deptno, job, sal

0001 Oracle database installation, 0001oracle Database I started learning Oracle from the beginning of this month. Since it was completely zero-start, I started learning from Oracle download and installation at. Today I re-installed the system and

Oracle Database basic learning (5) Multi-Table query, oracle Database Multi-Table query:Two or more tables are required for the query result. Multi-table join is required to generate multi-Table query.   1. Internal Connections (equivalent

Chinese data garbled by sqlldr When data is installed on the test machine, all Chinese fields are changed ???????, Character Set ProblemsChange UPDATE sys. props $ set value $ = 'we8iso8859p1 'where name like 'nls %' and value $ = 'zhs16gbk'; commit;

Advantages and disadvantages of using SQL GUID and auto-increment columns as primary keys [reprinted], sqlguid All databases in our company use GUID as the primary key. Many people are used to using int as the primary key. So here we will summarize