Unanswered: SQL commands for Oracle just like Access?
This is my first post at this forum but I know I will be here very often. I am taking my first class on Oracle after many many database classes
I have spent the last week doing trial and error simply attempting to create a table in an Oracle db. I was told it is exactly the same as the sql commands in access, as far as creating a table and insert commands are concerned. This has not seemed to be the case at all (or there is some particular thing I am doing wrong)
So, my first question here is just this. Can you really create a table and insert data using the exact same SQL commands you would in Access?
Thank you and I look forward to learning much from this forum.
For the time being I found I what I was looking for. You can create basic tables the same way you would in Access with only slight differences.
And yes, you can do everything in Access via SQL commands, under the SQL pane which does not always show itself depending on what you are doing. A lot of Access use involves understanding VBA as well. But your right, for the most part, as a single use office too its a lot of point and click
I am taking my first class on Oracle after many many database classes. I have spent the last week doing trial and error simply attempting to create a table in an Oracle db.
I'd expect that, someone who has taken that many database classes, had already learnt that there's a book about a Spanish guy named Manual; you should read it. Because, trial and error way of learning is probably the worst one could choose.