Home » SQL & PL/SQL » SQL & PL/SQL » Are some SQL commands the same in Oracle as Access
Are some SQL commands the same in Oracle as Access [message #439356] Fri, 15 January 2010 17:02 Go to next message
dbmeany
Messages: 11
Registered: January 2010
Junior Member
Hi,

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.
Re: Are some SQL commands the same in Oracle as Access [message #439357 is a reply to message #439356] Fri, 15 January 2010 17:37 Go to previous messageGo to next message
BlackSwan
Messages: 25041
Registered: January 2009
Location: SoCal
Senior Member
>Can you really create a table and insert data using the exact same SQL commands you would in Access?

SQL language is an ANSI/ISO standard.
The dialects are similar or equal between ACCESS & Oracle.

get familiar with http://tahiti.oracle.com
Re: Are some SQL commands the same in Oracle as Access [message #439358 is a reply to message #439357] Fri, 15 January 2010 17:45 Go to previous messageGo to next message
dbmeany
Messages: 11
Registered: January 2010
Junior Member
Thanks I'm downloading SQL reference pdf and another. I will post back when i have a more articulate way of asking what I want to ask that directly relates to this topic
Re: Are some SQL commands the same in Oracle as Access [message #439359 is a reply to message #439358] Fri, 15 January 2010 17:49 Go to previous messageGo to next message
BlackSwan
Messages: 25041
Registered: January 2009
Location: SoCal
Senior Member
in the future please read & heed Posting Guidelines in URL below

http://www.orafaq.com/forum/t/88153/0/
Re: Are some SQL commands the same in Oracle as Access [message #439360 is a reply to message #439358] Fri, 15 January 2010 18:04 Go to previous messageGo to next message
BlackSwan
Messages: 25041
Registered: January 2009
Location: SoCal
Senior Member
I making a new post to help ensure you see the following.

There is one BIG difference between ACCESS & Oracle.

Oracle defaults to UPPERCASE for object names & Access does not.

You should take time to read Concepts Manual because Oracle internally behaves differently than other RDBMS with regard to locking, concurrency, & consistency.
Re: Are some SQL commands the same in Oracle as Access [message #439362 is a reply to message #439360] Fri, 15 January 2010 19:31 Go to previous messageGo to next message
dbmeany
Messages: 11
Registered: January 2010
Junior Member
Thanks again. That is a big help!
Re: Are some SQL commands the same in Oracle as Access [message #471085 is a reply to message #439362] Thu, 12 August 2010 04:24 Go to previous messageGo to next message
noorbasha786
Messages: 5
Registered: August 2010
Location: hyderabad
Junior Member

hi am the new user. am learning oracle
can u help me?
please send any sql progranes
i do practice.
Re: Are some SQL commands the same in Oracle as Access [message #471087 is a reply to message #471085] Thu, 12 August 2010 04:36 Go to previous message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Many examples in Oracle documentation:
Database SQL Reference
PL/SQL User's Guide and Reference
Application Developer's Guide - Fundamentals

Regards
Michel
Previous Topic: help required to write query
Next Topic: How I can inser all rows values fetched by cursor
Goto Forum:
  


Current Time: Tue Dec 06 12:25:03 CST 2016

Total time taken to generate the page: 0.14527 seconds