by Dexter | Dec 5, 2020 | Oracle SQL
INITCAP is a case manipulation function which converts the first character of string to uppercase and other letters into lowercase. Here’s the syntax for Oracle INITCAP function INITCAP ( column-name/ expression) INITCAP is a special function that works with...
by Dexter | Dec 5, 2020 | Oracle SQL
UPPER is a case manipulation function that converts that converts text into uppercase. Text in this case is usually a column name or expression. Here’s the syntax for Oracle UPPER function: UPPER ( column-name | expression ); UPPER functions works with string...
by Dexter | Dec 5, 2020 | Oracle SQL
LOWER is a case manipulation function which converts all the text into lowercase. Here, text could be a column name or expression. Here’s the syntax for Oracle LOWER function: LOWER ( column-name/expression) Since LOWER is a string function, it only works with...
by Dexter | Dec 5, 2020 | Oracle SQL
DESC stands for describe and is a simple command to describe the contents of a table or a view. If we wish to see the column names or constraints in a table or a view, DESC command simply describes what’s inside. The syntax of DESC command is as follows: DESC (...
by Dexter | Dec 5, 2020 | Oracle SQL
Column Alias and Table Alias are used in Oracle for better readability of queries and for better understanding of the data displayed, just by looking at the columns. While working with relational databases we often find that the column names are given using some...
by Dexter | Dec 5, 2020 | Oracle SQL
The entries in a table are not arranged in any particular order. Suppose, we want to see the data in the table arranged in ascending or descending order based on column, then we can use ORDER BY Clause. Syntax: The syntax of ORDER BY clause is as follows: SELECT...