
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.
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.