Newbie ORACL/.NET help again...
-
I now have several buttons on my Form, which process various Oracle select statements and even display the output in listboxes or labels. Can someone tell me if the items below are also possible in VB.NET? 1. Write a query to support using Join Statements that display data from Multiple Tables. (I was able to do a select statement from two tables and display the results in a textbox). 2. Write a query to support the project using Sub-queries. 3. Write a query to support the project using Reports and SQL statements. 4. Write code to support the project that creates and manages Tables, Tablespaces and Database Objects. (I tried editing the sample and by changing the "select department_name from departments where department_id = 10" to create table emp2 ( emp_First_Name VARCHAR2 (100) PRIMARY KEY, emp_Last_Name VARCHAR2 (100), emp_years DATE, emp_salary NUMBER (8,2) )" but this did not work and generated several syntax errors. 5. Create Users and Manage access to the Oracle Database. (Like add a user and the permissions for that user). 6. Code S-Q-L statements within P-L-/-S-Q-L, built-in S-Q-L functions, Cursors, subprograms, packages, triggers and error handling to support the project. ( I have found some examples on the net, but have not been able to make any work, like the ones in the samples from the link you provided). 7. Write code to employ Composite to support the project. (Is this possible?) 8. Employ and demonstrate Cursors. As you can all see, my basic issue is that I am trying to process various queries using buttons in VB.NET and then display the results in a text box. Any help with this, would be greatly appreciated. Thanks again Joseph!! vbsquire