Oracle

① log in to the database with the ' sys ' user, enter select * from dba_users; see if there are any Scott users, as shown in:650) this.width=650; "src=" Https://s2.51cto.com/wyfs02/M01/9D/5E/wKioL1l-8maBmLr0AABqgUF9CR8135.png "title=" Qq2017073117021

The permission system of Oracle database is divided into System permission and object permission. System permissions (Database system privilege) allow the user to execute a specific set of commands. For example, the CREATE TABLE permission allows a

Sometimes we forget the Oracle SYS and system passwords, and don't worry, you can change the password by Sqlplus. Can only be modified, can not be retrieved.Here's how:1. Open cmd interface, enter Sqlplus/nologThe results appear as follows: 2. Enter

String typeFixed length: char nchar n denotes Unicode encodingVariable length: varchar2 nvarchar2Numeric type: Number (p,s) P: integer digits, S decimal placeInteger integersBinary_float Single floating pointBinary_double Double floating pointFloat (

Grouping Functions , multi-line functions Summary of non-null dataOnly Lieri the null value first.Grouping is not requiredSql> Select COUNT (*), sum (Salary), AVG (Salary), min (Salary), Max (salary) from employees;sql> CREATE TABLE t1 (x int);sql>

=========================oracle Database Simple Statement ============--%type type--sql> declare var_name varchar2 (--zm_tree); Fname%type; Var_type varchar2 (+);--zm_tree. Flinktype%type; Begin SELECT T.fname,t.flinktype to Var_name,var_type from

By configuring the Sqlnet.ora file. We are able to change the Oracle login authentication method.Sqlnet. Authentication_services= (NTS); operating system-based authenticationSqlnet. Authentication_services= (NONE); Oracle-based authenticationSqlnet.

ReasonIn the process of operating the database, we may encounter this situation, the data in the table may be repeated, so that we have a lot of difficulties in the operation of the database, so how to delete these duplicate data?You may encounter a

Dual is a virtual table that makes up the syntax rules for SELECT, and Oracle guarantees that there will always be only one record in dual. We can use it to do a lot of things, as follows:1. To view the current user, you can execute the following

One: Sql*plus start/close:1.sqlplus/nolog start Sql*plus "Do not connect to the database"2.conn/as SYSDBA Connect to Oracle as a DBA3.startup Startup DatabaseThree ways to start a database and application scenarios1> Normal StartStartup [Open]

[Oracle Collation] ORA-12705 (character set issues)? . years 5 Month One Day18:11[Oracle collation ]ora-12705 ( Character Set issues )Description: This content is work to use to the knowledge point collation, comes from the work and the network.

For Oracle's self-increment column, use the serial number (sequence).Initialization phase to manually establish a sequence, and then insert the time, but also to manually read the sequence nextval assigned to the relevant fields, such as ID, the

Select Systemdate from dual--get timeSelect systemdate+300 from dual--date + number = date, which represents a date after several daysSelect systemdate-300 from dual--date + number = date, representing the date of the previous several daysSelect

①upper: Converts the input string into an uppercase string;②lower: Converts the input string into a lowercase string;③initcap: initial capital letter;④length: Find out the length of the string;⑤replace (' String ', ' replace before ', ' replace '):

Part two common SQL usage and considerations1. Exists and in2. Union and UNION ALL3. With AS4. ORDER BY5. GROUP BY6. Where and having7. Case and Decode1.exits and in usage1) Description:1. Exists first to the appearance of the loop, each cycle of

Just work in the morning, as usual, supporting the computer support, open the computer, there is a war film inside, back to the position, set up machine guns, ready to meet the enemy of the ritual sense. Everything is so familiar, in the start test

1 Database Startup1.1 Required PermissionsSYSDBA or Sysoper system permissions.1.2 How to start Sql*plus STARTUP Command Oracle Enterprise Manager (Enterprise Manager) SRVCTL Utility 1.3 Starting the processBoot is divided into

Whether the Action BLOB field produces a lot of redo, the answer is no . To do an experiment, the test database version number is 11.2.0.1.0:--Create a table for testingCREATE TABLE Test_blob(ID number,Tupian blob);Import

1. Merge function wm_concat (column)Wm_concat (column name), which separates the column values by the "," number and displays them as a row. If the column value is in Chinese, choose another way: Wm_concat (to_char (column name))For example, the

Before the Oracle12.2 version, a move operation on a table adds a exclusive lock to the table, and the DML operation cannot be performed on the table. Although the move operation has an online clause, it applies only to IoT tables, not to heap