
create table file1 ( file_id int , file_data text );
i'm unable to create this table and the error is invalid type text. plz help me.

Which database you are using?
If you are using Mysql database then this query works.
Here is the java code for creating a table.
import java.sql.*;
class CreateDatabaseTable
{
public static void main(String[] args)
{
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql", "root", "root");
Statement stmt=con.createStatement();
String table = "create table file ( file_id int , file_data text)";
stmt.executeUpdate(table);
System.out.println("Table is created successfully!");
}
catch(Exception e){
System.out.println(e);
}
}
}

actually i'm using oracle database. and i want to create a table with a field where i could save any uploaded file.plz help me.

Then use Blob data type.