get tables and their number of rows in Oracle Database Schema
Simplest way is to use the data dictionaries provided by Oracle. And you can depend on the results if the […]
get tables and their number of rows in Oracle Database Schema Read More »
Finding characters in a string (VARCHAR-VARCHAR2) column
Compile the following Function in Oracle Database by copying it and Pressing F5 or F9 create or replace function test_num
Finding characters in a string (VARCHAR-VARCHAR2) column Read More »
Function to display reverse string of the given string in PL/SQL
CREATE OR REPLACE FUNCTION rev_str_f(str VARCHAR2) RETURN VARCHAR2ISv_str VARCHAR2(10); –you can specify your own sizev_str_rev VARCHAR2(10); –specify same size as
Function to display reverse string of the given string in PL/SQL Read More »