Oracle Tables


P

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
 
Ad

Advertisements

R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top