I am creating tables on oracle database using the JDBC driver i implemented.
I am gettign the sql exception error from the create sequece sql string.
Here is my sql to create table.
strSQL = "create table mytable ( " +
"mytable_id number not null, " + <====I want to increment this auto...
"subject varchar2(25) null, " +
"title varchar2(25) null, " +
Statement stmt = ...
strSQL ="create sequece mytable_id " +
"increment 1 start 1 ";
stmt.executeUpdate(strSQL.ToString()); <==== I am getting the error from here I believe.
In my insert sql, i am using myTable_id.nectVal().
I also have a drop method which drops the tables.
When I drop the table, do i need to drop the sequece?
How do I do that?
Because when I create tables and create sequece and then drop only tables and try to recreate tables, I get an error saying the table or view already exist or something..
Sorry I don't have exact message.