Oracle

  SQL code Select mc | 'id' as Alias, nl + 20 as age from student;   In SQL, strings and dates must be enclosed by single quotation marks. You can add, subtract, multiply, and divide (+,-, *,/) numbers and dates in SQL ,-,*,/). SQL strings can be

The directory structure is as follows:Row-to-ColumnColumn-to-row[1]. Row-to-column Conversion 1.1 initial test data Table Structure: TEST_TB_GRADE SQL codeCreate table TEST_TB_GRADE(Id number (10) not null,USER_NAME VARCHAR2 (20 CHAR ),COURSE

The select statement in Oracle can use the start with... connect by prior clause to implement recursive queries. The connect by clause is used in structured queries. Its basic syntax is as follows:Select... from Where Start with Connect by ;: Filter

Use expdp/impdp for oracle Import and ExportMy colleague in version 11gR2 11.2.0.1.0 is 11gr1. You need to specify the version 11.1.0.6.0. I installed oracle 11gR2. My colleague installed 11gR1 and used expdp to export impdp import. The system

Oracle provides three types: pre-defined exceptions, non-pre-defined exceptions, and custom exceptions.The predefined exceptions are used to handle common oracle errors;Non-pre-defined exceptions are used to handle oracle errors that cannot be

1. scott unlockAfter installing the Oracle 10 Gb database, I forgot to unlock the scott account. In this case, you can go to the SQL plus tool (START | all programs | | Application Development | SQL Plus), or unlock the scott account through

  Java code #! /Bin/bash   Source/home/oracle/. bash_profile Export NLS_DATE_FORMAT = 'yyyy-mm-dd hh24: mi: ss ';   $ ORACLE_HOME/bin/rman target/msglog =/backup/log/baklog _ 'date' + % Y % m % d % H % M % s'. log Run { Allocate channel c1

1. ## query of telephone bill products and commissions -- SQLSQL code-- Select count (*)Select t2.product _ name, t2.money, t1.fast _ price, t1.fast _ commission, t2.roll _ backFrom t_commission t1, t_product_type t2, T_BUSSINESS_SAFE t3Where 1 = 1

The Oracle instance and service knowledge point shutdown is to start the service for the instance, it does not mean that the instance is started. There are three steps to start a database: 1. nomount (that is, only instance is started, but database

To sum up the amount of the FORM Master/Slave header line: 1. when the master block CUX_OM_HEADER is created, the following items are summarized: _ RTOT_DB, NUMBER (38)/DISPLAY_ITEM, TOTAL_AMOUNT_RTOT_DB, non-database item, not displayed 2. create

To configure Oracle 11gR2 DataGuard_02, follow these steps: 1. Enable forced log 2. Configure Transmission Parameters for pri. 3. Back up the pri database. 4. Copy files to the sty end. 5. Configure transmission parameters for the sty end. 6. Start

Detailed description of the Oracle configuration file listener. ora, sqlnet. ora, tnames. ora configuration file listener. ora, sqlnet. ora, tnsnames. ora is stored in the $ Oracle_home \ network \ admin directory. Key points: the role of the three

Redo log management 1. add a log group alter database add logfile group 1 ('/u02/oradata/bolan/redo01.log') size 100 m; 2. add the log group member alter database add logfile member '/u02/oradata/bolan/redo01.log' to group 1; 3. delete the alter

If you use dbca to create a single-instance database in the Oracle 11g RAC environment, oracle automatically registers it to the default port 1521 and listener. In most cases, we use non-default listeners and non-default listening ports. In the

Oracle random password generation requirement: the password needs to be changed regularly. The password must be 1 and 11 digits. 2. It must contain uppercase/lowercase letters, numbers, and special characters. 3. exclude some special characters,

Oracle deletes the table structure and clears the recycle BIN oracle10g. After you select and delete the table in pl/SQL, a table similar to BIN $ nJ5JuP9cQmqPaArFei384g ==$ 0 is displayed. 1. view the recycle bin select * from user_recyclebin; 2.

Implementation Statement of oracle update data update SQL> -- create demo tableSQL> create table Employee (2 ID VARCHAR2 (4 BYTE) not null,3 First_Name VARCHAR2 (10 BYTE ),4 Last_Name VARCHAR2 (10 BYTE ),5 Start_Date DATE,6 End_Date DATE,7 Salary

Oracle data recovery-if you need to learn how to delete data files due to incorrect OEM operations, refer. A complete group deletion that contains data files and content is sent out. If you use it manually, I am afraid DBAs will be very careful in

Oracle remotely connects to the database. If port 1521 is open to the external network, you can first install an oracle client on the local machine, for example, any 10 Gb green version, download a PLSQL Developer and configure tnsnames. oraWhere

To enable the Oracle client to connect to an Oracle server installed on windows with a firewall, it is not enough to open a 1521 or custom listening port. Sometimes we need to map the port to remotely access the Oracle database. There is a firewall