Java & J2EE Technology Blog

Learning the Java, Design Patterns, Spring Framework in simple way with working examples.

Pages

  • HOME
  • JAVA
  • OOPS
  • DESIGN PATTERNS
  • SPRING FRAMEWORK
  • DATABASE
  • ECLIPSE
  • JSON
  • HIVE
  • TOMCAT
  • About Me

DATABASE


GENERAL SOLUTIONS

  1. How to unlock table in SQL
  2. Mass data update on table in SQL

ORACLE

  1. Oracle Tutorial
  2. Oracle System Queries

OPEN SOURCE / IN-MEMORY DATABASE

  1. Apache Derby Database
  2. HypherSQL Database (HSQLDB)
  3. H2 Database

ERRORS & SOLUTION

  1. ORA-01439: column to be modified must be empty to change datatype
  2. ORA-28001: the password has expired
  3. SQL Error: ORA-00997: illegal use of LONG datatype
  4. java.sql.SQLException: ORA-01658: unable to create INITIAL extent for segment in tablespace
Email This BlogThis! Share to X Share to Facebook Share to Pinterest

No comments :

Post a Comment

Home
Subscribe to: Posts ( Atom )

Featured Post

Builder Design Pattern Using Java 8

INTRODUCTION Builder design pattern is mainly focused on creating a complex object. Creation of complex object will be done by the sequ...

Popular Posts

  • Functional Interface in Java 8
    INTRODUCTION Functional Interfaces meant for performing a single task. In programming way, a Functional Interface will have only one me...
  • Adapter Design Pattern
    INTRODUCTION When we enter into a new country and we don't know the language which they speak, it is very tough to get the things do...
  • Mass data update on SQL table
    INTRODUCTION It is a tedious job to perform a mass update of a huge database by plain UPDATE statement since it will eat a lot of time...
  • insert values directly to hive tables
    INTRODUCTION Usually, we will be loading the data into hive table from HDFS file system while creating the table. This post will hel...

Blog Archive

  • ▼  2017 ( 12 )
    • ▼  May ( 1 )
      • Custom Functions using Saxon HE
    • ►  April ( 4 )
    • ►  March ( 7 )
  • ►  2016 ( 4 )
    • ►  August ( 3 )
    • ►  January ( 1 )
  • ►  2015 ( 27 )
    • ►  November ( 4 )
    • ►  October ( 7 )
    • ►  August ( 5 )
    • ►  July ( 2 )
    • ►  June ( 1 )
    • ►  March ( 1 )
    • ►  February ( 5 )
    • ►  January ( 2 )
  • ►  2014 ( 27 )
    • ►  September ( 5 )
    • ►  August ( 3 )
    • ►  July ( 12 )
    • ►  June ( 7 )

Pages

  • Privacy Policy
  • About Me
Powered by Blogger.