oracle query to export data

Oracle query to export data to a text file separated by spaces

unload sqlfile=e:\temp\tables\unload_jobs.sql 

datafile=e:\temp\tables\jobs_part2.txt 

delimiter="," quote="chr(34)" 

header=y;

Export data from mysql database

Export the data from MySql database to a text file .

SELECT * INTO OUTFILE "G:\file.txt"
      FIELDS TERMINATED BY '\t'
      LINES TERMINATED BY '\n'
FROM test.country;

copy table values of one database to another database

consider you are having two databases

Eg:  db-sample   and db-sample1

These two databases have the same  table  Student


The database of db-sample with table Student has 1000   records  and the table of Student in db-sample1
needs all those records

we can use the following query

First  set db-sample database as default Schema

Query

insert into Student SELECT * FROM `db-sample`.Student

where

Student - It is the table name of the dabase db-sample1

Student - It is the table name of the dabase  db-sample

create a property file in java

       

            Properties prop = new Properties();
                   
            prop.setProperty("connectionurl", connectionurl);
            prop.setProperty("username", userName);
       
            prop.setProperty("password", passWord);
            prop.setProperty("driverClassName", driverClassName);
         
            //save properties to project root folder
            File file = new File(System.getProperty("user.dir") + File.separator +  "config.properties");
            prop.store(new FileOutputStream(file, false), null);

   This is used to create a property file with the above parameters
   connectionurl,username,password,driverClassName,.


   

create a new folder in java

 String desktopPath = System.getProperty("user.home") + File.separator + "Desktop" + File.separator + "NW Folder";

 File folder = new File(desktopPath);

if(!folder.exists())
{
      folder.mkdirs();
}

A new folder with name (NW Folder ) will be created if there is no folder in the given name specified.

Folder within folder also can be created with this .

To get the current directory in java

To get the location of Desktop
System.getProperty("user.home");

To get the location of the current working project directory
System.getProperty("user.dir");

Capitalize a given string in java

Use  WordUtils.CapitalizeFully("string  is first")
      to capitalize each word with capital letter.

Add the apache io  utils in your library