Category: PL/SQL

The NO_DATA_FOUND exception is a predefined exception in Oracle PL/SQL that occurs when a query that is expected to return data does not retrieve any rows. This exception is part of Oracle’s built-in exception handling mechanism and is raised automatically when: A SELECT INTO statement fails to fetch any rows. A function returning a value…(Continue Reading)

In the PL/SQL language the errors are called exceptions. Exceptions can be predefined exceptions (internal error) or user defined exceptions (named by user). Predefined PL/SQL Exceptions The predefined exceptions are internally defined exceptions that have predefined names like no_data_found, too_many_rows, others, invalid_number, zero_divide. The predefined PL/SQL exceptions are declared globally in the package STANDARD and…(Continue Reading)

The Rtrim function removes characters from the right-hand side of an expression. Rtrim syntax RTRIM( expression, [ trim_expression ] ) Rtrim example select rtrim(‘example ‘) from dual; Result: example select rtrim(‘000function000’, ‘0’) from dual; Result: 000function select rtrim(‘PHP123’, ‘123’) from dual; Result: PHP select rtrim(‘123PHP123123’, ‘123’) from dual; Result: 123PHP select rtrim(‘TestxyzXYZ’, ‘XYZ’) from dual;…(Continue Reading)

The Ltrim function removes characters from the left-hand side of an expression. Ltrim syntax LTRIM( expression, [ trim_expression ] ) Ltrim example select ltrim(‘ example’) from dual; Result: example select ltrim(‘000function’, ‘0’) from dual; Result: function select ltrim(‘123SQL’, ‘123’) from dual; Result: SQL select ltrim(‘123123SQL123’, ‘123’) from dual; Result: SQL123 select ltrim(‘XYZxyzTest’, ‘XYZ’) from dual;…(Continue Reading)

The RPAD function returns an right padded expression to a specified length with the specified characters. Rpad syntax RPAD( expression, length, [ pad_expression ] ) Rpad example select rpad(‘learn’, 5) from dual; Result: learn select rpad(‘learn’, 3) from dual; Result: lea select rpad(‘learn’, 6,’0′) from dual; Result: learn0 select rpad(‘learn’, 7,’0′) from dual; Result: learn00…(Continue Reading)