Date Format: DD-MON-YY
Run the following command on the server to checkSysdate
SQL> selectSysdateFrom dual;
Sysdate ----------September 10-07
Therefore, on the Chinese platform, mon cannot be written in English as the month. Therefore, it
Oracle databases are currently used by most enterprises.
1. Oracle Certification
2. Default oracle users
After the Oracle database is successfully installed, three users are generated by default.
(1). sys User: Super Administrator with the
Select extract (year from execution_end_date) as year, extract (month from execution_end_date) as month,Department_id, count (form_no) CIP DataFrom cip_masterGroup by extract (year from execution_end_date), extract (month from execution_end_date),
If-then-else logic in decode is often used in logic programming for logical judgment. In decode syntax, this is actually the logic processing process. Its syntax is as follows:
Decode (value, if1, then1, if2, then2, if3, then3,... else)
Value
SQL optimization is complex and restricted by the environment. However, the minimum principle for writing SQL statements during development is as follows:
1. oracle uses the bottom-up sequence to parse the WHERE clause. According to this
Insert data using a subquery
Create Table emp2 (myid number (4), myname varchar2 (50), mydept number (5 ));
Insert into emp2 (myid, myname, mydept) Select empno, ename, deptno from EMP where deptno = 10;
Update Data Using subqueries
There are three levels of cache in obiee:
DB cache-> obiee server cache-> presentation cache (Web ie cache)
1) for the database cache, it is the problem of SQL parsing. You can change the SQL statement. For obiee, it is to change the request or
1. What is a transaction?
Transactions are used to ensure data consistency. They are composed of a group of related DML statements. The group's DML statements (data operation language, add, delete, modify, and no query) are either all succeeded, or
The index clustering factor is a key statistic that can improveboth the Oracle optimizer's performance, and the technician 'sunderstanding of the utility of an index.
It is used by Oracle's optimizer to help determine the costassociated with index
Oracle Database Process Overview:
Database buffer cache is mainly used to store data blocks in data files.
Data blocks in the database cache are the basic unit for information exchange between the cache and data files. Before Oracle Database 8 I,
1. Create a stored procedureCreate or replace procedure Test (var_name_1 in type, var_name_2 out type)-- Declare a variable (variable name and variable type)Begin-- Execution body of the stored procedureEnd test;
Print the input time informationE. g:
Installation preparation:Download filesL Oracle Database 10g Release 2 (10.2.0.1) SoftwareDecompress the fileCommand to decompress the file:Unzip 10201_database_linux32.zipThe decompressed folder may be "Database" or "DB/disk1"Hosts
2005/07/22
Event: I first checked the stored procedure and carefully read the PL/SQL code to find that there was no error, this made me very strange. At this time, I did not dare to directly use toad debugging on the user's system, so I asked the
[Oracle] managing Oracle9i services in Windows Author: builder.comWednesday, June 30 2004 pm
Install Oracle 9 in WindowsIMany services will be installed, and some of them are configured to start at Windows startup.
View the table structure:Desc table name;
Cancel duplicate columns in distinct.
Set timing on; show operation time
Insert into users (userid, username, userpass) Select * from users;Insert into student (XH, XM, sex, birthday, Sal, classid) Select *
String Functions
Lower (char) to lowercaseConvert upper (char) to uppercaseLength (char) returns the length of the string.Substr (char, m, n) truncates a string, the position starting from M (starting from 1), and the length of N.
Replace (char1,
Oracle has two functions: Lead and lag, both of which are used to calculate the offset analysis functions. The two functions share the same usage.
The Oracle official documentation explains:
LEADIs an analytic function. It provides access to more
This article describes the concepts and operations of partition tables from the following aspects: 1. table space and Partition Table concept 2. table Partition Function 3. advantages and disadvantages of Table Partitioning 4. table partition types
Using python to simulate Oracle sqlplus
The team plans to develop the database service platform and needs to use some server script development. To understand python, they have set a small requirement for simulating sqlplus and then implement it.
My
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