Oracle

--- Spfile is created when you use dbca to create a database.--- Spfile must be created on the shared volume or shared raw device--- All instances use the same spfile--- If you create a database manually, use pfile to create a spfile.[Oracle @ rac11

% Type attributeIn PL/SQL, you can declare variables and constants as built-in or user-defined data types to reference a column name and inherit its data types and sizes. This dynamic value assignment method is very useful. For example, the data

Install Oracle10g in HPHttp://www.ixpub.net/archiver/tid-467908.htmlInstall Oracle 9.2 under HPHttp://blog.chinaunix.net/u/28815/showart_281067.htmlInstall oracle10gr2 on aix5.3Http://oldboy.itpub.net/post/29104/270188Install oracle10gr2 in

Modify data encoding to UTF-8 How to view and modify the Oracle encoding format -- view the Oracle database character set: Select userenv ('language') from dual; Query results: Simplified chinese_china.al32utf8 -- Modify the character set

Today, a colleague asked me how to dynamically call the stored procedure in Oracle PL/SQL. I think there should be no problem. I just tried OK, mainly using the execute immediate syntax, note that the in and out parameters are specified in using.

When installing Oracle 11g RAC, the following error is reported:Info: Checking single client access name (SCAN )...Info: Checking name resolution setup for "racscan "...Info: Error:Info: PRVF-4664: found inconsistent name resolution entries for scan

 The following is an explanation:-------------------------------------------------------------------Data Table connections include:1. Inner join (natural join): Only the rows matching the two tables can appear in the result set.2. external

Oracle stored procedure, cursor Create or replace procedure p_tb_task_log is -- function: Insert a task to the task log table v_task_start_date date;V_task_end_date date;V_ SQL _code number;V_ SQL _msg varchar2 (4000): = ''; -- SQL error

Insert into values (values, readername, values, countrycardid, citizencardid, password, values, libraries identity, nationality, openaccountdate, libraryreadertype, values, isotherlibraryreader, readercarstate) values ('hangzhou', 'shenchao', 1, '201

This article introduces some basic concepts of Oracle execution plans for learning and application. 1. Related Concepts The concept of rowid: rowid is a pseudo column. Since it is a pseudo column, this column is not user-defined, but added by the

Oracle SQL optimization rules: Use the in operator as few as possible. Basically, all in operators can be replaced by exists. The SQL statements written in are easier to write and understand, but the SQL statements written in always have low

When my colleague retrieved the database, it was Oracle 10 Gb. The previous deletion method was Delete. I do not know whether to use trancate. The SCN (System Change number) is spelled as system change number, which is a very important data

Document directory Connection to Oracle database with myeclipse Connection to Oracle database with myeclipse When myeclipse Database Explorer establishes an Oracle database connection, no matter which Oracle JDBC driver package (classes12

  Sorting: fenngDate: 25--200-2004Source: http://www.dbanotes.netVersion: 0.91 Sometimes, as a DBA, you may need to collect information about the deployed Oracle database. Hardware configuration, operating system conditions, software installation

[Oracle]Several important e-booksDownloadInitial link:Http://www.dbanotes.net/Oracle/DB_Books_Download.htmFor Oracle technology enthusiasts.For the purpose of communication, please do not use this content for commercial purposes. If you infringe

Q. What if your dad loses his car keys?A. 'parent keys not found! ' Q. What if your old girl friend spots you with your new one?A. 'duplicate value on index! ' Q. What if the golf ball doesn't get into the hole at all?A. 'value larger than specified

Truncate and delete have the following differences:1. truncate is very fast on various tables, whether large or small. If the rollback command Delete is used, the truncate command is not used.2. truncate is a DDL language. Like all other DDL

Let's put it simply. For details, see Example 1. Try not to use like '% .. %' 2. For like '... %...' (not starting with %), Oracle can apply index 3 on colunm. For like '%...' (not ending with %), you can change it to like '... %' in the form of

Recently, I just made a performance optimization job. According to the statspack report of one week, I wrote an optimization solution. I. Existing major performance problems of the systemAccording to the typical statspack report in the last week,

When Oracle DBA is used, the application administrator notifies us that the application is slow and the database is slow, when we go to the database, we do a few examples of select and find the same problem, sometimes we will not be able to start,