Oracle

Key Words: an explicit cursor When a query returns more than one row, an explicit cursor is required, at which point the user cannot use the SELECT INTO statement. Pl/sql manages implicit cursors, which are open when the query starts, and when the

The For Loop Pl/sql language of the/* cursor provides the cursor's for loop statement, "Automatically performs the function of the cursor's open,fetch,close statement and circular statement," and when entering the loop, the cursor for Loop statement

Transferred from: http://blog.csdn.net/joshua_peng1985/article/details/6213593 Introduction Materialized views are a special physical table, and the materialized view is relative to a normal view. Normal view is a virtual table, the application of a

After I generate the code with MyBatis generator, the Date Type field in Oracle is only accurate until the date of year, followed by zero seconds, when executing the query statement. Later discovered is jdbctype problem, change into jdbctype=

http://www.cnblogs.com/phoebus0501/archive/2011/01/17/1937141.html SYS: With DBA, SYSDBA, Sysoper (System Operator) roles or permissions, is the highest user of Oracle permissions and can only log on as SYSDBA or Sysoper and cannot log in as normal.

Oracle Database Basic Knowledge Summary 1. One instance corresponds to a database 2. Mode 3. Table Space (Segment > Area > Block) Improve management efficiency From the user's point of view, there are several patterns in a library (the pattern

1. Close the database instance: Srvctl Stop instance-d tar-n RAC2 To stop a database instance on only one node RAC2 2. View database Instance Status: Srvctl status database-d tar-f-V My side four node cluster, currently only up Node 1 and Node 2. 3.

The following is a detailed analysis of the character set in Oracle, the need for friends can refer to the following Basic conceptsCharacter Set (Character set): Is a collection of all abstract characters supported by a system. Characters are the

The use of Row_numbeR is very extensive, sorting is best used, it will generate an ordinal number for each row of the query, sorted and will not repeat, note that when using the Row_number function, you must choose to sort a column with the over

Some simple process is not listed here, there are many online, here is the main write down some of the problems encountered, as well as solutions The environment of CentOS 7 is $ uname-a Linux Oracle 3.10.0-123.13.1.el7.x86_64 #1 SMP Tue DEC 9 23:06

Oracle Beginner's TipsOracle's system is too large, for beginners, it is inevitable that some will not be able to feel, what all want to learn, the results of what are not good, so the learning experience to share, I hope that the people just

Introduction to Functions The Lpad function fills the string with the specified character from the left. It is also understandable from its literal meaning that L is the shorthand for left, the pad is the meaning of the padding, so the lpad is the

Reprint please indicate the source: http://blog.csdn.net/anxpp/article/details/51550479, thank you. 1. Overview This article describes the string type and related functions, based on the current Oracle 12c. The string is referred to as strings below.

ora-28009:connection as SYS should be as Sysdba Afraid to forget can: Click "Password Management", Open Password Management dialog box, such as figure, set SYS, and system user password, can be set to the same, username and password are the same,

For simpler tables, the amount of data is not a very much table, you can use a simple SQL statement to back up CREATE TABLE t_fa_cat_20121207 as SELECT * from T_fa_cat Create a new table and save the data INSERT INTO T_fa_cat select * from

Show Parameter Service_names Select instance_name from V$instance; Db_name is a real physical name. Service_Name with a domain name, because if two databases no longer have the same name as the same domain. The SID is the instance name of the

  There is a user's table to be imported into our system, the original table TM_WWM date is varchar (8) Type, the format is YYYYMMDD. Before importing to my system, we need to see if the date is legal SQL1 Select To_date (saledate, ' YYYYMMDD ')

Oracle dba Pen TestOne: SQL tuning class 1: Enumerate several table connection ways2: How to view SQL execution plan without the help of Third-party tools3: How to use the difference between CBO,CBO and rule4: How to locate the SQL that is important

If you have a string in an SQL statement that is enclosed in a single or double quotation mark, you need to be consistent in the same table, or you will see a "Row not found" error. Use of ALTER statements the use of ALTER statements requires that

DBCA Log Path[Email protected] ~]# cd/u01/app/oracle/cfgtoollogs/dbca/[email protected] dbca]# LLTotal 1700-RW-R-----1 Oracle oinstall 1740250 Jul 10:31 trace.log_2018-07-24_09-31-27-am-RW-R-----1 Oracle Oinstall 0 Jul 09:31 Trace.log_2018-07-24_09-3