Oracle Tables

[Paula]

Hello :

Can you create a table in an Oracle data base using sentences in your .NET code?

I explain:

example: sqlSentence = "CREATE TABLE tableName (...)"
command.commandtext = sqlSentence;
command.ExecuteNonQuery();

If you can, how can you set auto_increment data types?

Thanks

Paula

 

[Roy Fine]

Paula,

yes, you can create tables using SQL DDL commands.

Oracle does not have an auto increment data type as found in SqlSever.
Instead, with Oracle you would use a trigger and a sequence to achieve the
same results.

regards
roy fine