oracle

2009-7-7 16:8
Oracle Bone Script Essay - "Familiarity" Original Text and Interpretation http://budai.me/space.php?uid=373&do=blog&id=479 Oracle Bone Script Essay O......
2009-5-26 11:6
Oracle OCP DBA certification is the most popular one among all Oracle certifications.
2009-5-17 21:50
What surprised the industry circles is that shortly after the breakdown of negotiations with IBM Corporation, Oracle Corporation acquired Sun Microsystems for ......
2009-5-4 20:14
China Oracle Network is a professional ORACLE technology platform, providing technical information related to Oracle, covering Oracle installation, Oracle down......
2009-4-29 11:4
North Street is currently studying the installation of Oracle on HP-UX. The installation process requires using Xmanager's graphical emulation terminal. Howeve......
2009-4-24 12:46
As an independent company, Sun has a 27-year history in Silicon Valley, but there is no doubt that the deal with Oracle will change the existing pattern of the......
2009-4-22 18:19
Larry Ellison has been eager to build Oracle into the world's largest IT company. If this deal goes through smoothly, Sun will become Oracle's 52nd acquisition......
2009-4-22 16:19
Sun Chairman and co-founder Scott McNealy, and even CEO Jonathan Schwartz can finally breathe a sigh of relief. Sun's stock price crashed after IBM abandoned i......
2009-4-21 15:12
SUN was finally sold, but the buyer was not IBM, but Oracle Corporation, one of IBM's biggest competitors and the world's largest database software.
2009-4-21 14:3
Oracle Corporation and Sun Microsystems Inc suddenly announced on Monday morning that the two parties had reached an agreement, under which Oracle would acquir......
2009-4-21 13:41
After the acquisition of Sun, Oracle's cooperation with HP and Dell will be broken, and it will pose a threat to its rivals such as IBM.
2009-4-21 13:24
In-Depth Report: Oracle Buys Sun At first glance, this acquisition may seem a bit strange. Oracle is a software company. Sun is more often seen as a hardware ......
2009-4-21 10:3
The SUN, which was the subject of intense public debate, was ultimately acquired by Oracle. Please see the details below: At 19:40 on April 20th, it was repor......
2009-4-20 21:59
At 19:40 on the evening of April 20th, news emerged that Oracle Corporation, one of IBM's biggest competitors and the world’s largest database software company......
2009-4-20 21:46
According to foreign media reports, Oracle announced today that it will acquire Sun for $9.5 per share, and the total value of this deal will exceed $7 billion......
2009-4-20 21:25
Oracle announced today that it will acquire Sun for $9.50 per share in a deal valued at more than $7 billion.
2009-4-9 13:54
Recently, Beijie has been studying Oracle and summarized several common issues regarding Oracle backup. First of all, backing up an Oracle database not only in......
2009-3-5 8:48
Introduction: Today, I read the proposal by Mr. Pan Qinglin, a member of the National Committee of the Chinese People's Political Consultative Conference, rega......
A simple comparison reference of some commands between Oracle and MySQL: | Functionality | Oracle Command | MySQL Command | |--------------|----------------|----------------| | Create Database | `CREATE DATABASE database_name;`
*(Note: In Oracle, creating a database is usually done through the Database Configuration Assistant (DBCA) or complex scripts.)* | `CREATE DATABASE database_name;` | | Create User | `CREATE USER username IDENTIFIED BY password;` | `CREATE USER 'username'@'host' IDENTIFIED BY 'password';` | | Grant Privileges | `GRANT privilege ON object TO username;`
`GRANT CONNECT, RESOURCE TO username;` | `GRANT privileges ON database.* TO 'username'@'host';` | | Show Tables | `SELECT table_name FROM user_tables;` | `SHOW TABLES;` | | Delete Table | `DROP TABLE table_name;` | `DROP TABLE table_name;` | | Describe Table | `DESCRIBE table_name;`
or
`SELECT column_name, data_type FROM user_tab_columns WHERE table_name = 'TABLE_NAME';` | `DESCRIBE table_name;`
or
`SHOW COLUMNS FROM table_name;` | | Current Date | `SYSDATE` | `CURDATE()` | | String Concatenation | Use the operator `||`, e.g., `column1 || column2` | Use the function `CONCAT()`, e.g., `CONCAT(column1, column2)` | | Pagination Query | `SELECT * FROM (SELECT * FROM table ORDER BY id OFFSET m ROWS FETCH NEXT n ROWS ONLY);`
*(Available in Oracle 12c and later versions)* | `SELECT * FROM table ORDER BY id LIMIT n OFFSET m;` | Please note that there may be differences depending on the specific version of Oracle or MySQL being used.
2009-2-25 15:56
Oracle MySQL Comparison of Versions: Personal Oracle7 Release 7.3.4.0.0, MySQL 3.22.34-shareware-debug Startup Screen (Click to enlarge) Default Instal......
2009-2-20 12:5
Initialization of related parameters `job_queue_processes`: ```sql ALTER SYSTEM SET job_queue_processes = 39 SCOPE=SPFILE; ``` // The maximum value cannot exc......
2008-11-30 17:47
A while ago, Bei Jie wanted to learn how to install Oracle on an HP mini-machine. Since everyone had been working on Informix testing before, I wasn’t sure abo......
2008-6-4 18:33
Oracle has always actively supervised its Oracle wiki site, but something mentioned in a recent blog post has made people realize that when introducing Wiki, i......
2008-5-5 21:10
Levels of RAID in Oracle Database Applications: ◆ RAID 0 - No Redundancy: This level maintains data without redundancy, thus offering the best write performan......
2008-5-5 21:5
Oracle Database supports two types of clustering: index clustering and hash clustering. This article will provide a detailed introduction to the use of these t......
2007-12-14 13:14
Specific implementation steps for automatic backup of Oracle databases
2007-7-14 22:23
In a standard case of "money to burn", Oracle sent out a large number of free cardboard laptops to people, ...
2007-5-30 16:6
涉及Windows, Bash, Oracle, and SQL Server,
2007-2-1 10:56
Oracle JDBC Driver
2006-11-6 2:9
Take a tour of the headquarters of Microsoft, Oracle, and Sun.
2006-3-4 2:26
From Jis世Net. Oracle Corp this Wednesday announced a new software which "traverses" the enterprise network, thus entering the search market that has always bee......