Select * from V $ nls_parameters;
SQL> alter session set nls_date_language = 'simplified Chinese ';
Session altered
SQL> select to_char (sysdate, 'yyyy-mon-day') from dual;
To_char (sysdate, 'yyyy-MON-DAY'
------------------------------
Http://qdlover.yeah.net
An Oracle + PhP query example
I didn't need PHP anymore, but a lot of friends asked me, so I made an example. For details about the function, please refer to the manual.
In fact, Oracle functions are similar to others, but
paging test
// How to split the result into pages, like 'limit' in MySQL?// ================================================ ==================================// Tutorial by Neil Craig (neilc@netactive.co.za)// Date: 2001-06-05// With
It is very important to develop a database application and select a good database. This article compares three types of databases: SQL Server, Oracle, and DB2. It provides some reference for you to select a database.
Openness
SQL ServerIt can
Single-record functions in SQL
1. ASCII
Returns the decimal number corresponding to the specified character;
SQL> select ASCII ('A') A, ASCII ('A') A, ASCII ('0') zero, ASCII ('') space from dual;
A A zero space
------------------------------------
First, create a stored procedure get_clob:
T_name: name of the table to be queried; f_name: name of the field to be queried; u_id: Primary Key of the table, query condition; l_pos: Start position of the truncation; l_amount: truncation
The ORACLE tutorial is: Oracle 9i allows you to easily obtain DDL statements for table creation and index creation. We all know that before 9i, It is very troublesome to obtain statements for creating tables and indexes. We usually use export with
The ORACLE Tutorial we are reading is: Experience in Oracle Database System 6.
1. having clause usage
The having clause controls the row groups determined by the group by clause. The having clause conditions allow only constants, clustering
The ORACLE tutorial is about space management of Oracle databases. In Oracle databases, DBAs can observe tables or views to understand the usage of the current space and make possible adjustments.
I. Free Space for tablespace
By observing the free
The ORACLE tutorial is: Oracle constraints management script.
As an Oracle database administrator, you may encounter such a database management requirement to stop or open the constraints and triggers for all tables under the current user (mode.
The ORACLE tutorial is: query the intersection of two data tables in Oracle.
Oracle relational database management system is a popular relational database system in the world. It is an extremely powerful, flexible, and complex system. It is said
The ORACLE tutorial is: quickly delete duplicate records in oracle. When I was doing a project, a colleague accidentally duplicate all the data in a table while importing data. That is to say, all the records in this table have a record. This table
The ORACLE tutorial is: Oracle Database Security Policy Analysis (3 ).
Data security policy:
Data Generation considerations should be based on the importance of data. If data is not important, the data security policy can be relaxed. However, if
The ORACLE tutorial is backup and recovery of the Oracle database. ---- When we use a database, we always hope that the content of the database is reliable and correct. However, due to computer system faults (including machine faults, media faults,
Recently, many people in the group have discussed oracle Security Issues. Today I have found some materials to learn more.
Obtain the attributes of the current Oracle SESSION (useful for determining the SQL Injection environment)
The SYS_CONTEXT
Conversion of date and time in c shell perl php: seconds and human readable date scalar localtime and seconds since '00: 00: 00 1970-01-01 UTC'
Scalar localtime 26-byte string and seconds since '00: 00: 00 1970-01-01 UTC'
(The number of seconds
Recently, due to insufficient hard disk space in the unit database, I checked many articles and tested them. I learned some experiences for your reference.
First, I saw an article on the internet, how to Shrink Undo tablespaces and release space
The ORACLE tutorial is: Comparison between Oracle and SQL Server in enterprise applications. My company not only owns Oracle databases but also SQL Server databases, so I often encounter two problems that people ask me.
The first is usually "can
Oracle Database Backup:
-- Keep the backup record of the last week;==== Body:===== Start ======================Copy codeThe Code is as follows:Echo sets the backup file storage folder...Set "tbuf = E: \ Cway \ backup"
Echo sets the backup file
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