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 »
Histograms in Oracle for Table Columns
Histogram:A histogram is a special type of column statistic that provides more detailed information about the data distribution in a
ORA-30926: unable to get a stable set of rows in the source tables
We will get this when we are trying to update a row in a table, for which there will be
ORA-30926: unable to get a stable set of rows in the source tables Read More »
Difference between REPLACE and TRANSLATE in SQL?
Replace will replace the character or string with the given character/string for every occurrence of the character/string.Translate will replace the
Difference between REPLACE and TRANSLATE in SQL? Read More »