Oracle Character Set viewingSelect userenv ('language') from dual;The following method can be used to modify Oracle10g and Xe:
Connect system as sysdba;Shutdown immediate;Startup Mount;Alter system enable restricted session;Alter system set
Use ultraedit32 to open the exported DMP file. The file content is displayed in hexadecimal notation. The second and third bytes of data record the character set of this file.
For example:
03 54
Convert it to a 10-digit system with a value of 8
Check what quota supported by your computer system is:
When the vehicle is rolling in: After regedit, the vehicle is loaded into the rolling table.
Find software under HKEY_LOCAL_MACHINE
Find oracle from software
In Oracle, find
SQL functions I. Character Functions
Character functions are the most common functions in Oracle,Character functions:. Lower (char): converts a string to lowercase.. Upper (char): converts a string to an upper-case format.. Length (char): returns
1. conversion functionsThe biggest relationship with the date operation is the two conversion functions: to_date (), to_char ()To_date () converts the character type to the date type in a certain format:Specific usage: to_date ('1970-11-27 ',
You can access a database on the. NET platform in the following ways:
1. oledb database access program,
2. ODBC Database Access Program,
3. proprietary database access programs. For example, when accessing SQL Server 2000, we generally like to use
1. ou: Oracle University2. Instructor name *** @ oracle.com
3. Oca. OCP. OCMOCM requires that OCP Be the first to pass two advanced courses, lab for 2 days4. course scheduleAm-AmPM-PM5. Q &Ekit Teaching MaterialsOther Oracle Application
1.
Date and character conversion function usage (to_date, to_char)
2.Select to_char (to_date (222, 'J'), 'jsp ') from dual
Display two hundred twenty-two
3.The day of the week.Select to_char (to_date ('1970-08-26 ', 'yyyy-mm-dd'), 'day') from
In the large and Medium-sized database management system at home and abroad, there are more users of Oracle as database management platform. Oracle is not only a database management capability or security is justifiable, but it is in the display of
Date field: SQL Server Date field format in the same character field format, that is, a single quotation mark on it, Oracle Date field format is different, it is very wordy, there are only two ways to deal with:
A: Add a single quotation mark to
One, SELECT1. Understanding | [] {} The meaning in the introduction of the command, as well as the data in the Basic Select query table, mainly using the Select command.SELECT *| {[DISTINCT] column|expression [alias],...} from table;In this way of
To_date format (in time: 2007-11-02 13:45:25 for example)
1. Date and character conversion function usage (TO_DATE,TO_CHAR)
Copy Code code as follows:
Select To_char (sysdate, ' Yyyy-mm-dd hh24:mi:ss ') as nowtime from dual;
In the development of Oracle databases, it is often a matter of time, so the date function of Oracle data is collected specifically. is for future investigation.
Add_months (d,n) Date d plus n months
Last_day (d) The date of the last day of the
I often see some friends ask questions about Oracle character sets, and I'd like to introduce them in an iterative way.
First iteration: Mastering the basic concepts of character sets.Some friends may think this is superfluous, but in fact it is
The reason and solution of Oracle Chinese character garbled problem
by Wangd
Reason:
The main reason for the occurrence of Chinese garbled characters is the character set is different.
In Oracle, we care about the character sets in three places:
1. Error Reason:The date type cannot contain the precision after the second.As Date: 2010-01-01 20:02:20.0
Workaround: Remove the precision after the date secondsAs a date: 2010-01-01 20:02:20
2, INSERT into TEST2 (C1, C2,C3) VALUES
Solution:
1. After the installation of Oracle, first to modify the character set.
To modify the character set, use the command-line line to log on to Oracle, and then use Sqlplus to connect to Oracle, at which point configuring the Oracle profile is
Java EE go on continue advanced!! (This post is personally thought to be helpful to beginners, please look carefully.) Due to time haste, please correct me if there is any mistake.
sql*plus FoundationIn the previous post, we mastered some basic
Problem
These two days just will plsql and Oracle configuration, but in plsql insert data, there is a problem, Plsql table can not display Chinese, Chinese can not save, unable to output, Chinese in the tables show the question mark, as shown:
To_date formatDay:DD Number 12DY abbreviated FriDay spelled out FridayDdspth spelled out, ordinal twelfthMonth:MM Number 03Mon abbreviated MarMonth spelled out MarchYear:YY two digits 98YYYY four digits 1998 24-hour format of the time range: 0:00:00-
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.