Blog - Our findings and learning
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. The media should be compatible with all the devices across
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 reports, analyzing the table structure and creating new data structures.
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 into database by using few methods, and using loadjava command
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 one can connect to remote database as authorized database user
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 schema is up to date with the statistics. Use the
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 the steps# create directorycreate directory dmpdir as ‘c:/temp’;select directory_name,directory_path from
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 a matter of how it is used. Kind of like
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 to trace out Errors/Exceptions from where it is raised i.e.
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 table column. Purpose of Histograms:By default the optimizer assumes a