Filed under Database

mysql not starting in xampp error on port 3306

Nice to be back with another solution for a common (not so) problem which google takes some time to find a proper solution.   As mentioned in the title of the post, this thing happens when i was installing xampp server on my office computer.   After successfully installing the xampp server, i was trying … Continue reading

Load Huge Data block into Oracle database

  You can use sqlloader to insert or update huge amount of data into an oracle database. All you need is to create a control file and data file according to that. example control file is shown below (load.ctl) load data infile ‘b00000004.dat’ badfile ‘b00110000.bad’ discardfile ‘b00110000.dsc’ INSERT INTO TABLE CHANA_TEST FIELDS TERMINATED BY “,” … Continue reading