To determine the length of a given string, use the Oracle LENGTH() function. The length includes all trailing blanks if the string's data type is CHAR. This function returns null when a string is empty. Bytes, not characters, are what ...
Discy Latest Articles
Oracle INSTR() Function
In Oracle, INSTR() function searches for a string in a string and returns the number of the first occurrence. Below are the syntax and examples of Oracle INSTR() function: Oracle INSTR() Syntax INSTR( x , find_string [, start ] [, ...
Oracle INITCAP() Function
In Oracle, INITCAP() function converts the first letter of each word to uppercase. Below are the syntax and examples of Oracle INITCAP() function: Oracle INITCAP() Syntax initcap(string) Oracle INITCAP() Function Examples: Example-1: Get the employee name from the EMP table ...
Oracle Concat
In Oracle, to join or concatenate two strings we use the CONCAT function. The following is the syntax of the Oracle Concat function: Oracle Concat Syntax concat(a, b) Here it will join the string a and b and will return ...
Oracle CHR Function
In Oracle, the CHR function returns the character of an ASCII value supplied as a parameter. The following are the syntax and examples: Oracle CHR Function Syntax CHR(ascii_value) Oracle SQL Query Example to Get CHR Value of an ASCII Value ...
Oracle ASCII Function
In Oracle, the ASCII function returns the ASCII value for the character supplied as a parameter. The following is the syntax of the Oracle ASCII function: Oracle ASCII Function Syntax ascii(single_char_value) Oracle SQL Query to Find ASCII Value of a ...
A Guide To Writing Technical Specs | How to Write a Technical Specification
Technical specifications are how you communicate your product’s functionalities to the outside world. The way you write your technical specifications will determine how comprehensible they are and, therefore, how effective they are. You can write a technical specification in different ...
What is the difference between constraints and triggers in Oracle?
In this tutorial, First, we would be discussing what is constraints and their types, and secondly, about the Oracle triggers and the usages before we could see the major difference between constraints and triggers. CONSTRAINTS: In Oracle, the constraints are ...
Oracle PL/SQL Download BLOB File to Disk
Here is an example of Oracle PL/SQL stored procedure to download BLOB file to disk. Oracle PL/SQL Stored Procedure Example to Download BLOB as File The following PL/SQL procedure takes three arguments. First, Oracle Directory object name, second, file name, ...
Oracle Convert External File to BLOB
Here is an example of the Oracle PL/SQL program to convert an external file to BLOB. Oracle PL/SQL Function Example to Convert an External File to BLOB In Oracle, you can reference an external file using the BFILENAME() function by ...