Oracle

Oracle OCP 11G 053 (1-200) Answer resolution directory 　 V13.02 version, 711 questions File version:3.2,200 problem version:5.4 1 http://blog.csdn.net/rlhua/article/details/16369867 490

There are Node1 and node2 two Oracle RAC Machines, performed in Node1 Su-oracle Pwd mkdir ~/.ssh CD. SSH SSH-KEYGEN-T RSA Generate RSA keys and public passwords all the way to the carriage First to resolve the local password-free login CP Id_

(1) Loading and registering the JDBC driver for the database Load JDBC Driver: Class.forName ("Oracle.jdbc.driver.OracleDriver"); Register JDBC Driver: Java.sql.DriverManager.registerDriver (New Oracle.jdbc.driver.OracleDriver ()); (2)

The operating system version and database version are as follows: Sql>!cat/etc/redhat-release Red Hat Enterprise Linux Server release 6.5 (Santiago) Sql> select * from V$version; BANNER -------------------------------------------------------------

Get table field: SELECT *From User_tab_columnswhere table_name= ' user table 'ORDER BY column_name Get Table Comments: SELECT *From User_tab_commentswhere table_name= ' user table ' ORDER BY table_name Get field Comments: SELECT *From

Please, note. This article was entirely based on a work do by me colleague developer, who hasn ' t got account on this webpage and also h ASN ' t got time to writing this article. I ' m writing it for him. I'll try to forward him the any comments

1. Modify the archive Path parameterSqlplus/as SYSDBASql> alter system set log_archive_dest_1= ' Location=+asmarch ' scope=spfile sid= ' * ';2. Close the database and all nodes are closedSrvctl Stop database-d racdb3. Boot a node database to mount

The previous parse link is as follows:Https://www.cnblogs.com/wcwen1990/p/9325968.html1. SQL Example 1:Sql> SELECT *From (SELECT * from TMP1 where C >= 1) T1 LEFT JOIN (SELECT * from TMP2 where B ) t2 on t1.a = t2.aand t2.d > 1 and t1.e >= 2Where t1.

1. Prepare the installation filesVirtualBox-5.2.8Oracle Linux 6.5 iso image fileXmanager52. Create a virtual machineVirtualBox-5.2.8 installation skipped2.1 Set the global IP in the Host network Manager, menu management, and set the same network

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

To see if the database is in non-archive modeClose the databaseShutdown immediateBackup control files and data files (no backup log files, recommended backup)[[email protected] PROD]$ lltotal 2014624-rw-r----- 1 oracle oinstall 9748480 Jan 24 21:49

Https://www.cnblogs.com/AmatVictorialCuram/p/5904914.html PromptOutput hints Set Feedback offUsed to turn off the output hint information, when there are a large number of execution statements, often turn off the "Output

The database server character Set select * from Nls_database_parameters, which is derived from props$, is the character set representing the database. 　　Client Character Set environment select * from Nls_instance_parameters, which originates from

One, sys users and system usersThe Oracle installation automatically generates SYS users and system users(1), sys user is superuser, has the highest privileges, has the SYSDBA role, has the rights to create database, the user's default password is

Plsql:Symbol:Assignment value:: =Basic example: set serveroutput on // sets the output to open. Declare -- description section begin -- program dbms_output.put_line (' HelloWorld');

? Define subqueries? Describe the types of problems that subqueries can solve? List the types of subqueries? Write single-line and multiline subqueries? Subquery: Type, syntax, and guidelines? Single-row subquery: – Group function in a subquery –

Source: http://blog.csdn.net/liverliu/article/details/6410287First: The cause of the problem, I previously in the f:/llh/directory created a bookspace table space, and later do not want this table space, so I deleted directly, this error is because

Control filesEach database has a control file, which is a binary data file that records the physical structure of the database. Control file database An important parameter file, when writing data, the control file must be a usable state. The

Linux modifies the Oracle database character set instance and the oracle Character Set 1. Log On As a dba in SQL * PLUS Conn/as sysdba > Shutdown immediate; (stop the database)> startup mount; (restart the database to change the condition)>

Oracle: View All Tables and table columns of the current user, including yellowcong and oracleyellowcong. I have previously written a tool to dynamically generate the oracle entity class function, but this tool can only be used for the Searsar