Oracle LENGTH function
The Oracle/PLSQL LENGTH function returns the length of the specified string….
FROM CLAUSE ALIASES, SUB-SELECTS IN
- 30 October 2022
- Database Performance ManagementMachine learning
What do SQL aliases mean?
A temporary name for a result set is given using SQL aliases in FROM clauses. A table or view name, sub-SELECT, and/or VALUE…
Oracle LOWER function
- 29 October 2022
- Database Performance ManagementTechnology Business
The Oracle/PLSQL LOWER function converts all characters in a specified string into lower case. If there are characters in the string that are not lett…
Oracle LTRIM function.
The Oracle/PLSQL LTRIM function removes all specified characters from the left side of the string….
Oracle REGEXP_REPLACE function.
- 27 October 2022
- Database Performance ManagementTechnology Business
The Oracle/PLSQL REGEXP_REPLACE function is an extension of the function REPLACE. This function, introduced in Oracle 10g, allows you to replace a seq…
The views expressed on this blog are those of the author and do not necessarily reflect the opinions of Enteros Inc. This blog may contain links to the content of third-party sites. By providing such links, Enteros Inc. does not adopt, guarantee, approve, or endorse the information, views, or products available on such sites.
Are you interested in writing for Enteros’ Blog? Please send us a pitch!