Oracle

Grey Original address:http://www.cnblogs.com/greyzeng/p/5346833.html ?Environment: Windows 10 Professional Edition Oracle Database 12c Release 1 ?Flashback ExampleScenario 1:? Create a new table

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

/* Query Current User table information/Select a.column_name Field Name,A.data_type data type,A.data_length length,A.data_precision integer digits,A.data_scale decimal digits,A.nullable allows null values,A.data_default default Value,B.comments

Create a view using the system SYS or DBA authority account as follows:1. It is mainly obtained from table dba_data_files,dba_segments two tables in the database.2. The default database holds a byte unit, and the conversion relationship is as

Oracle Four-sheet EMP Dept Salgrade bunus Structure, remembering the benefits of later SQL statement learning employee table (EMP) No. field type description 1 empno

Basic query statements SELECT [DISTINCT] column_name1,... | * FROM table_name [WHERE conditions] formatting in sql*plus change display field name: COLUMN column_name HEADING new_name    (note column

Detailed introduction to oracle11 I can learn about oracle recently, so I installed oracle yesterday and couldn't connect my mysql for unknown reasons. To be honest, it is a little complicated if you read the tutorial and install it. Especially for

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

First article on OracleSQL classical Query Oracle SQL classic query Article 1 This article is the first article on typical Oracle SQL queries. It is just the author's own opinion. If you have any questions, I hope you can provide suggestions or

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

Install and uninstall oracle10gI. installation 1. due to the special nature of oracle, I chose to install the flagship version of windows 7 to install the database through a virtual machine. If your system is windows xp, windows 7, windows 8, you

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;

0003 64-bit Oracle11gR2 cannot run SQL Developer solution, 0003oracle11gr2 "SQL Developer" under "Application Development" double-click unavailable, "Windows is looking for SQLDEVELOPER. BAT "tips, such as: Search blog garden, find:

Basic Oracle Database Learning (III), oracle Database The emp dept salgrade bunus structure of Oracle's four tables. Remember that it is helpful for later SQL statement learning.    Employee table (emp) No. Field Type

Conversion from row to Column--- Create table tb (name varchar (10), subject varchar (10), result int); insert into tb values ('zhang san', 'China', 74 ); insert into tb values ('zhang san', 'mat', 83); insert into tb values ('Li si', 'China', 80 );

How to import Oracle12c database to 11g, oracle12c11g The packages backed up from oracle 12c (expdp) are restored to 11 GB. We all know that there will be compatibility issues. Sure enough, an error is returned: ORA-39142: Version 4.1 (in the