Hi. I have created a visual basic system that is connected to an oracle database.
(I connected through data>Add New Data source>New Connection>Oracle Database etc etc)
I am using the system to create new oracle users with passwords etc.
I have a form called frmAdd and text boxes txtUser and txtPassword
The user of the system will input into txtUser the username they wish to create (eg user1) and then their password (eg password)
they will then click the cmdAdd button.
I wish to send the following command to the oracle databse when they click the button
Create user (txtUser.text)
Default Tablespace users
identified by (txtPassword.text)
There are a lot of other commansd I need to do but I'm sure I can manage it myself after I get help with this one.
Could someone tell me how to go about this please. As it's for a university assignment that needs to be handed in next week.