When the string is empty, it is judged by where null is used.
Example:
CREATE TABLE Test(Stuno Number (Ten) primary key,Stuname VARCHAR2 (50))INSERT into Test (Stuno) VALUES (10)INSERT into Test (stuno,stuname) VALUES (11, ')
SELECT * FROM test
To use Oracle 9i in your work, you often insert the date and time that the event occurred to one of the tables. Write a note specifically on Oracle's date and time display and how it is inserted.
Like the built-in data types such as NUMBER,VARCHAR2,
The character set problem for Oracle databases is not a big problem, but it is also a headache. This is because there are three reasons: first, the Oracle database in the installation of a good character set after the general can not change, the
oracle| Access Summary: This article describes how to use PHP's database access technology to implement the storage of Oracle LOB data objects.
Keywords: php;oracle; LOB; storage;
Introduction
PHP, or "Php:hypertext preprocessor", is a versatile
Oracle|unix|window
Ian Adam, SAIC Ltd
David Stien, SAIC Ltd
Translation: Fenng
Summary
Oracle is the leading database system on a well-known UNIX hardware platform. Oracle users and administrators are therefore familiar with the Oracle
A Server Management Recovery
Recovery Manager, Recovery Manager, Jianchen RMAN. The RMAN implementation has been server Management recovery (Managed RECOVERY:SMR). SMR is the ability of a database to perform the operations needed to ensure the
What this article contains: Use commands to manipulate import and export of Oracle, Postgres, MySQL, including logging on to dataNote: I am using the Center OS operating system in the company, so both Oracle and Postgres are used in Linux and not
Oracle database sessions have five states of active, INACTIVE, killed, CACHED, sniped. A inactive state session indicates that the session is inactive, idle, and waiting. For example, PL/SQL developer is connected to a database, and after executing
Many DBAs are still at Oracle 9i or 10g, due to the possibility of Oracle 11g price issues. This article will explain the installation of Oracle 11g under Windows 7, but also hope that you can see some of the new features of 11g.Recently uninstalled
The remote connection of Oracle database can be implemented in a variety of ways, this article mainly introduces four methods and considerations of remote connection, and through the examples to illustrate, then we begin to introduce.First case:If
ASH (Active Session history)Ash is based on v$session, sampling once per second, recording events waiting for an active session. Inactive sessions are not sampled, and sampling work is done by the newly introduced background process MMNL.The minimum
? Configure backup settings with Oracle Enterprise Manager? Enable automatic backup of control files? Configure the backup destination? Assign a channel to a tape target? Configure Backup Optimizations? Create a compressed backup? Create an
? List the purpose of creating a replica database? Select a method for replicating a database? Copy a database using Rman? Copy a database using Rman backup? Replicate a database based on a running instance
Using the replica database
?
Installing an Oracle VM VirtualBox virtual machine in XP The host system is: windowsxp SP3. Because a lot of people's system has certain problems, loaded on the time can not be Simplified Chinese version. I will take a screenshot of the Chinese and
In Oracle 11GR2, the login audit information for SYS users is logged by default in the Audit_file_dest directory, but the operation content is not audited.Enable auditing of SYS user action behaviorSql> alter system set AUDIT_SYS_OPERATIONS=TRUE
Oracle Developer is famous for its rapid data processing and development, and its exception handling mechanism is also relatively complete.
1. Advantages of exceptions
If no exception occursProgramCheck whether each command succeeds or fails,
I have compiled several blogs about migrating a single instance from 32-bit to 64-bit:
Oracleconverta 32-bit database to 64-bit database (32-bit to 64-bit) Description
Http://blog.csdn.net/tianlesoftware/article/details/7252742
Migration of a
Oracle PL/SQL practiceBasic InformationAuthor: (English) bilington (A.) and so on, Lu Tao [Translator's introduction]Press: People's post and telecommunications PressISBN: 9787115294852Mounting time:Published on: February 1, November 2012Start:
SQL Tune Report-sqltrpt. SQL, reportsqltrpt. SQL
ORACLE 10 Gb provides a script sqltrpt. SQL to query the most resource-consuming SQL statements. The output result is divided into two parts:
15 Most expensive SQL in the cursor cache
15 Most
Oracle SQL Performance 1. ORACLE optimizer:. RULE (based on Rules) B. COST (COST-based) c. CHOOSE (optional) sets the default optimizer. various declarations of the OPTIMIZER_MODE parameter in the ora file, such as RULE, COST, CHOOSE, ALL_ROWS,
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