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);
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:
@ 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 =?
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
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
########################### 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);
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
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
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.
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:
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),
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 %
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
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
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
, 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
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