how to connect mysql database remotely in windows
Every developer needs to connect to database to access the data stored. The direct database access will make creating new […]
how to connect mysql database remotely in windows Read More »
loadjava: Loading Java Sources/Classes/Jars into oracle Database
Loading the Java Sources/Classes into Database is important thing in Java based application software. Java sources (jar/Classes) can be loaded
loadjava: Loading Java Sources/Classes/Jars into oracle Database Read More »
ORA-12154: TNS: could not resolve the connect identifier specified
WhatDatabase link is an option to connect to a remote database from another database. By using this database link option
ORA-12154: TNS: could not resolve the connect identifier specified Read More »
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 »
expdp : Exporting datadump in Oracle 11g
The export can be done in two ways from local machine from Server From Local MachineFor Windows operating system Follow
OLAP vs OLTP vs Datawarehouse Database
There is nothing about the database itself that “makes” it an OLAP, or a DW, or an OLTP.That is all
DBMS_UTILITY.FORMAT_ERROR_BACKTRACE in PLSQL
In Big/complex applications, it is essential to call Sub-programs (Procedures/Functions) from other sub-programs. In that case it will be difficult
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 »
ORA-06502: PL/SQL: numeric or value error
We may get this error, when we try to assign a value to a variable which is bigger than the