difference between replace and translate in oracle
difference between replace and translate in oracle
Want to know difference between replace and translate in oracle? we have a huge selection of difference between replace and translate in oracle information on alibabacloud.com
One, replace functionThe function of the Replace function is to replace the specified string in the source target with the corresponding character, for example:(1) Replace the JI in the "Jisuanji" string with 1;sql> Select replace (' Jisuanji ', '
Translate is a function to replace a characterGrammar:Translate (char, FROM_STR,TO_STR)where char is the string to be processed.From_str is a set of character sets to be replaced in order, note that the character set is not a string.To_str is the
This article will introduce some interesting functions that trisi often uses in daily life, or which are rarely used. There are two types of introduction:
Famous functions-frequently used functions
Non-famous functions-although rarely used, they are
Feel that some netizens always put forward some very basic questions, for example, there is no function to achieve such functions ah, what is the function of Ah, what the format is, and so on, but also feel their understanding of the lack of Oracle
This article is not ready to introduce all of the Oracle functions, in the current situation, I do not have this time, need to learn too much, to spend most of the time on learning to use the technical aspects:), so if you are ready to learn all the
This article will introduce some of the functions that are often used in everyday life, or that are very interesting, though they are rarely used. It is divided into two kinds of introductions, namely:
Famous letters-functions that are often
This article is not ready to introduce all of the Oracle functions, in the current situation, I do not have this time, need to learn too much, to spend most of the time on learning to use the technical aspects:), so if you are ready to learn all the
Explain Oracle functions and subprograms, and explain oracle function instances SubroutineI,Subroutine Overview
The PL/SQL naming block is defined in the Declaration part of the PL/SQL block. The user calls it a subroutine.
Generally speaking: The
1.create user username identified by password;//build username and password Oracle
2.grant CONNECT,RESOURCE,DBA to username;//authorize Grant CONNECT,RESOURCE,DBA,SYSDBA to username;
3.connect username/password//Enter.
4.select
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.