Oracle SQL query exercise skills (this is very practical, not blow)

  Table data; Menu_id Is_tree 0001 1 0002 1 0101 2 0102   0103   0201 5 0202 6       -------------

Oracle time format conversion Exception Handling Function

Create or replace function f_format_date (v_date varchar2, format varchar)/* time format processing format */return dateas v_enddate date; v_rn varchar2 (2); v_last_date varchar2 (10 ); Y varchar2 (4); m varchar2 (4); D varchar2 (4); H varchar2 (4);

Not in Oracle must not be pitted.

Recently, the process was quite busy, day and night, and I had no time to write a blog. Today, a very strange problem, especially a tough problem, has struggled for a long time and I have to write a blog. Select * From wlbtest3where (sname, SAGE)

Oracle automatic backup method

Oracle automatic backup method:   @ Echo offSetlocalSet SID =? // Modify the SID value based on the actual situationSet username =? // Assign values based on actual conditionsSet Password =? // Assign values based on actual conditionsSet bakdir =?

Confusing oracle. SQL. Timestamp

ProgramIt runs normally under weblogic10.3.0, but the program written under weblogic10.3.5 cannot pass, trackingCodeThen it is found that the resultset object returned by the resultset. GetObject (INT) method is Oracle. SQL. timestamp, rather than

Oracle tablespace & datafiles-Oracle tablespace-application instance (1)

TablespaceIn Oracle, table space is the basic method for data management. All user objects must be stored in the table space, that is, the user has the right to use the space to create user objects. otherwise, you do not need to create objects

Oracle creates tablespaces, users, and Backup Recovery

1. Create a tablespace-- DataCreate smallfile tablespace "myname_data"Datafile 'H: \ ora_data \ myname_data.ora 'size 10 mLoggingExtent management local segment space management auto;-- IndexCreate smallfile tablespace "myname_idx"Datafile 'H: \ ora_

Oracle stored procedure-parameter type research (in, out, in out)

########################### In ############ ################ Create or replace procedure pro_eight (p_one in varchar2, p_two out varchar2, p_three in out varchar2) is v_str1 varchar2 (32): = ''; v_str2 varchar2 (32) default ''; v_str3 varchar2 (32);

Install and configure the Oracle instance Client

Environment Description: The oracle11gr2 database is installed on the Virtual Machine (centos5.5 64bit). The database name is orcl and the user is test. Virtual Machine IP Address192.168.128.101 No database is installed on the Physical Machine

Oracle DBA exam

I. SQL tuning class 1: List several table Connection Methods2: How to view SQL Execution plans without using third-party tools3: How to Use CBO? What is the difference between CBO and rule?4: how to locate important (resource-consuming) SQL

Oracle recursive query of parent-child relationship records

The database often processes records of parent-child relationships. In Oracle, you can use a query statement to retrieve all the sub-records at a time. For example:T1T11T111T1111T12T121T1211 The DB data fields are as follows:Task_id task_name T.

Oracle startup and shutdown in Linux

Start the Oracle listener. Command: LSNRCTL start Start an instance: First, go to the sqlplus environment and run the following command: sqlplus/nolog. Log on as an administrator. Command: connect/As sysdba Start the instance with the command:

Oracle % type, % rowtype

1. Use % TypeIn many cases, PL/SQL variables can be used to store data in database tables. In this case, the variable should have the same type as the table column. For example, if the first_name column type of the Students table is varchar2 (20),

Oracle Database Start and Stop

1,StartDatabase: Oracle @ Suse92: ~> Sqlplus/nolog SQL * Plus: Release 9.2.0.4.0-production on Fri Jan 20 02:29:37 2006 copyright (c) 1982,200 2, Oracle Corporation. All Rights Reserved. SQL> connect/As sysdbaconnected to an idle instance. SQL>

Oracle SQL Performance Optimization (III)

8. Use the decode function to reduce processing timeYou can use the decode function to avoid repeated scan of the same record or join the same table.For example:Select count (*), sum (SAL) from EMP where dept_no = 0020 and ename like 'Smith %

Oracle SQL Performance Optimization (4)

13. Calculate the number of recordsIn contrast, count (*) is slightly faster than count (1). Of course, if you can search by index, the index column count is still the fastest. For example, count (empno)According to the author's suggestion: In the

Oracle uses the exceptions table to query duplicate records in the table

SQL> conn system/OracleConnected.SQL> Create Table Scott. T1 (ID number primary key, name varchar2 (10); -- create a test table Table created. SQL> select constraint_name, table_name, constraint_type, -- view the status of the corresponding

Oracle service charges

The service is becoming more and more important. A foreign Oracle expert provides technical services in USD. The service provider is a senior DBA professional with An OCP certificate, The service locations can be divided into remote and on-site, The

Oracle listeners are periodically down

Oracle , Down , Regular , Listener   Install Oracle 10.2.0.4 in Windows 2003 32bit and configure two instances., No Incremental backup, only for the SystemExecute an exp backup for a scheduled task. One data exists for two instances.A small amount

Oracle obtains the first and last days of this week, this month, this quarter, and this year.

-- This weekSelect trunc (sysdate, 'D') + 1From dual; -- next MondaySelect trunc (sysdate, 'D') + 7 fromDual;-- This monthSelect trunc (sysdate, 'mm ')From dual;Select last_day (trunc (sysdate) from dual;-- This seasonSelect trunc (sysdate, 'q')

Total Pages: 2147 1 .... 2104 2105 2106 2107 2108 .... 2147 Go to: GO

Contact Us

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

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.