Oracle

The following garbled behavior occurs because Oracle does not support the Chinese character setResolution Steps　　1. Open the registry to find the Oracle---"Key_oraclient11g_home---" NLS. LANG modifies the value to simplified Chinese_china. ZHS16GBK,

Select To_char (sysdate, ' Yyyy-mm-dd hh24:mi:ss ') from dual; --Show Current time2011-12-29 16:24:34Select Trunc (Sysdate, ' year ') from dual; -Interception to year (first day of this year)2011-1-1Select Trunc (sysdate, ' Q ') from dual;

1. Connect to a Linux server (enter the IP address of the server)SSH 10.199.94.227When the connection is successful, you will be prompted to enter the password.2. Switch to Operation Oracle databaseSu-oracleA successful switchover prompts an

Linux installed the database, after the installation can be used, today, the launch will not be able to use, prompted Oracle not available, and later find information, it is said that the Oracle service is not open. The problem can be solved in the

background: The production environment has Oracle server, there are several database users, need to back up the database user data through exp, need to patrol the results of database backup.Objective: to perform periodic backups via Linux

In OracleYou can use the InStr function to judge a string to determine whether it contains the specified character.Finds the specified character in a string, returning the position of the specified character that was found.Grammar:InStr

1. Querying the character set of the Oracle server sideSql> select userenv (' language ')  from dual; USERENV (' LANGUAGE ')----------------------------------------------------American_america. zhs16gbksql>  or

Tag: Group does not produce order by STS first syntax value OraSub-query:A definition is a query that is nested within a query.Subqueries can be present in many places, such as columns, tables, conditions, etc.Grammar:SELECT (sub-query)From

First, complete commandSu-//'/u01/app/oracle/oradata/mas/scaninvoice.dbf ' size 200M autoextend on next 100m '/u01/app/oracle/oradata/mas/scaninvoice_tmp.dbf ' size 50m autoextend on next 50m maxsize 20480m extent Management Local;create User

First, create a userOverview: In Oracle, to create a new user using the Create USER statement, you typically have DBA (database administrator) permissions to use.Create user username identified by password;Note: Oracle has a problem, the password

Numeric Functionsthe commonly used functions for handling numeric values are as follows : No. Function name meaning 1 Digital  round ( column  |  numbers [. ]) Returns the value

Create a new TXT fileThe contents are as follows@echo off sqlplus abc/[email protected] @c:\users\administrator\desktop\abc.sql exitWhen you are finished, change the file suffix to. bat, and the abc.sql is executed when you

SelectOper_time, Micropay, REFUND from ( Selecttrunc (oper_time) oper_time, class_name, sum (total_fee) Total_fee fromWx_pay_detail GROUP by Trunc (Oper_time), class_name) pivot (sum (total_fee) forClass_nameinch ('Micropay' as

A String type1 CONCAT (A, B) two field AB connections2 a| | B field connection, you can connect multiple3 Length (char \ varchar2) return string lengths4 LOWER All Letters lowercase5 UPPER All Letters capitalized6 Initcap uppercase, the remaining

Some databases are in use because some operations will lead to a temporary table space is too large, due to the working mechanism of temporary table space, the temporary table space will not be released after the job is completed.This problem can be

Sql_trace is a very good tracking tool provided by Oracle, primarily used to check the database for anomalies, and to track the activity of the database to find the problematic statement.First, overview:Sql_trace is a very powerful tool for Oracle.

Oracle Notes (iv) Simple queries, qualifying queries, sorting dataFirst, simple querySQL (structured query Language) Structured Query language is a database query and programming language for accessing data and querying, updating, and managing

Solution to ora-12899 errors in Oracle databases, oracleora-12899 ORACLE may cause various problems and errors, the ORA-12899 is a problem that occurred some time ago when I imported data to my local machine. but fortunately, this problem has been

Understand the principle of null in depth and the principle of null in Depth -- Null principle -- oracle always treats null and null strings ''with the same length as 0. For example, ''is null is true,'' = null is false, if a varchar2: = ''is

Common oracle database management system errors (2 ), Oracle databases always encounter the following problems for new users: I believe everyone has encountered such a problem. To be honest, I have encountered such a problem before, but I am sorry