|
-
Apr 3rd, 2006, 07:38 AM
#7
Re: creating tables in oracle 9i using vb 6.0
Are you always going to drop create alter the same table or user? If not you need to execute them from the program and build the SQL as needed. If you store the data partially on the server (in some table that holds a bunch of different SQL commands) you need to be able to set up Oracle replacement values (using the amper sign (&)) this can be a big problem for someone not very familar with Oracle. You may also need to use the execute immediate SQL statement if you modify the SQL using replacement variable and it is used inside a Stored Procedure (or ananonomus block).
Sometimes the Programmer
Sometimes the DBA
Mazz1
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|