Example 1: Bulk Query The department number "10" and print them out.
DECLARE
TYPE Emp_table_type is table of My_emp%rowtype INDEX by Binary_integer;
V_emp_table Emp_table_type;
BEGIN
SELECT * BULK COLLECT into v_emp_table from My_emp WHERE
One: Problem description
Two: The cause of the error
Uploading the uncompressed Oracle installation software to the Linux server in Windows has resulted in three files being lost in execution permissions.Three: Solutions
Give it the appropriate
One: Problem description
Today, when the Oracle is equipped to monitor the error:
Netca/silent/responsefile/download/database_10g_64/response/netca.rsp
Exception in thread "main"
Some of the basics of Oracle have been learned some time ago, and for ease of practice and operation, an Oracle 10g was installed. After the installation, the book was directly discarded. Card to the death, card to directly can only be used as the
Oracle Linux 4.7 Configuration documentation for Oracle ASM
http://blog.csdn.net/liumengcheng/article/details/37358567
Oracle Linux 6 installation oracle11g R2 and Oracle Linux 4.7 installation oracle10g R2 different places are:
Required RPM
For continuous updates, see the pages on https://hnuhell.gitbooks.io/oracle_errmg/content/or https://hnuhell.github.io/Oracle_ERRMG/.
ORA-00000 to ORA-00877
ORA-00000: Normal successful completion (operation)
Ora-00000:normal, Successful
The failover of Oracle Data Guard was described in both previous articles, but there was no systematic explanation, so in this paper, DG's failover is described in a systematic note.
The processing of failover redo under physical data
Summary of long types in Oracle
1, Long data type is stored in variable-length strings, the maximum length limit is 2GB.2, for more than a certain length of text, the basic only long type to store, the data dictionary many objects are defined in a
1.sys and SystemSystem Admin user, SYS superuser, sys account has more permissions than the SYSTEM account, no Scott user after Oracle112. Import and export of tablesIMP username/password @ service name file= database table. DMP Storage Address
A: oracle64&32 Build: Oracle & 32 All need to build, there is a special document, Baidu to search, a lot of, here do not say, (because do not want to add pictures, good trouble) (test all need to build, development seems to only need 64 bit of it,
--=============== monitoring of DG Recovery process in standby ==================V$managed_standbyV$archived_standbyV$archive_desc_statusV$log_history--View status in the main librarySelect Dest_name,status,error from V$archive_dest;--Query the last
In connection with the database, sometimes encountered a "ORA12514: Listener currently does not recognize the service requested by the connection descriptor" error, which is actually the database dynamic registration (about dynamic registration will
Oracle database is a leading product in the field of database. It can be said that Oracle database system is currently the world's popular relational database management system, System portability, easy to use, strong function, applicable to all
CGS is the implementation of Oracle RAC instance management and is responsible for the following functions1) Heartbeat mechanism between instances2) Complete the reconfiguration of the DB cluster when the instance leaves or joins the cluster3) solve
In the database in order to facilitate user development, often provide a series of support functions, the use of these functions can be used for data processing. One, String functions String functions can be processed for strings in the
Solution to Oracle tnsping failure after firewall is enabled on Windows 2008
1. solution:Simply put, the Windows 1521 firewall has blocked the Oracle port. Just create and enable it. Of course, if your listener is another port, open the other ports
Oracle SQL * Plus is a client tool that interacts with Oracle. In SQL * Plus, you can run the SQL * Plus command and the SQL * Plus statement. The DML, DDL, and DCL statements we usually call are SQL * Plus statements. After they are executed, they
Show parameter service_names
select instance_name from v$instance;
Db_name is a real physical name. SERVICE_NAME carries the domain name, because if the two databases do not have the same domain, they can have the same name. The SID is the
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service