Image optimization in Servers
As you all aware that images place an important role in the current generation web but it also brings the […]
how to embed responsive youtube video for all devices
In the age of dynamic and interactive content, now or then we need to show playing media on web pages.
how to embed responsive youtube video for all devices Read More »
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