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
--------- --------- --------- ---
Oracle in the database, null values are used to indicate a situation where the actual value is unknown or meaningless. In a table, if a column in a row has no value, it is called a null value (NULL). Columns of any data type can have null values if
Pl/sql is Oracle's extension of the standard database language, Oracle has integrated PL/SQL into Oracle servers and other tools, and more developers and DBAs have started using Pl/sql in recent years, and this article covers Pl/sql basic syntax,
Today, provincial technicians reflect database login exceptions.Query Oerr, found that this error is a general hint, may cause a database is not registered, local file configuration problems and so on. Because the usual connection and no problem, is
Beginners can from the query to the current PL/SQL content can be found in my notes here, I hope to help everyone, video resources in resources,My own full set of notes in notesThe SQL keywords that you can continue to use in PL $ are: UPDATE Delete
The SAP project no longer allows its own ERP system to support Oracle or other repositories since 2025. Dell says the SAP ERP system is paired with Oracle repositories, followed by DB2 SQL Server and IBM. With the increase in customer inquiries,
For the needs of market and enterprise Development, Oracle provides a relatively unified solution for enterprise-class real-time data solutions, Oracle data integration. The following article is mainly about the specific description of its solution,
First install ha-instant Client-v11.2.0.3.0-x86.rar:Ftp://hhdown:[email Protected]/download/ha-instant%20client-v11.2.0.3.0-x86.rarFtp://hhdown:[email Protected]/download/ha-instant%20client-v11.2.0.3.0-x64.rarThen perform the installation of ODBC a
Data Guard is a remote replication technology for Oracle, it has physical and logical points, but in general, it needs a separate system in a remote location, two sets of hardware configurations can be different systems, but the software structure
-----Resolving IP AddressesSql> Select Utl_inaddr.get_host_address (' google.com ') from dual;Utl_inaddr. Get_host_address (' google.com ')--------------------------------------------------------------------------------122.229.30.202-----Get the
Background:Colleagues mistakenly delete online data, so they need to recover data from the backup. Real estate leakage of the rain, the ship late and the wind, the first two days of backup disk bad block, now only rman full of. bak files, no control
Install the Oracle client on ASP.. net. DLL, which I have encountered before. Just reinstall the client and I am using a 2000 Professional System ). Later, I went to the Oracle official website to find a solution and downloaded Oracle Developer
The table size has two meanings. One is the number of physical spaces allocated to a table, regardless of whether the space is used or not. You can query the number of bytes as follows:
Select segment_name, bytesFrom user_segmentsWhere
1 Virtual Machine hard drive should not be set to the default 8g as big as possible
2. It is not difficult to install oracle. Is not familiar with Linux Command operations
3. When installing the Linux system, remember to set the resolution
+ "','" + Mytechnical + "', to_date ('" + mybirthday + "', 'yyyy-MM-DD'), '" + myemail + "', '"+ mytelephone
To_date ('','') does not need to be added to an SQL statement, but the preceding format must be used to obtain the variable.
1. Use Oracle
How to modify the Database Name (db_name) and Instance name (Instance_name or Service_name)
Nid is a tool provided by Oracle starting from 9iR2. It can be used to change the database name without the need to recreate the control file or other
Oracle Study Note: Users and Basic Security, using lenote
1. view the default user account
1 SQL> select username from dba_users;
2. lock all users and set their password to expired
1 SQL> select ‘alter user ‘|| username || ‘ password expire account
In general, if we perform the alter operation, the drop operation is not triggered. However, in some special cases, the alter package operation can see the drop operation in recursive SQL.We have a trigger in this environment, once there is a drop
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