difference between oracle and SQL (2 Viewers)

adnanhome

Registered User.
Local time
Today, 05:51
Joined
Nov 12, 2008
Messages
16
Hello, I am new to SQL , I want to know what is difference between oracle query and SQL query, function or structure are same or different.

I have created database in Access using 20 different queries. I want to convert in SQL . It looks very hard for me. Any experience will guide me how write in professional ways.

Should I take 1 by 1 query and convert into sql and then join each query. what is the best way.

in my access database I used make table query and append query. Is it possible how to create make table query and append query in sql.
 

plog

Banishment Pending
Local time
Today, 07:51
Joined
May 11, 2011
Messages
11,613
Wherever you go, databases use SQL for queries: https://en.wikipedia.org/wiki/SQL#:~:targetText=SQL (/ˌɛsˌ,stream management system (RDSMS).

If you know SQL one place you will be fine everywhere. This includes SELECT and action queries (e.g. INSERT, APPEND, DELETE). The different databases do have slight differences in the native functions (e.g. Now()=Access, getdate()=SQL Server, SYSDATE = Oracle), so that's usually where you will spend your time converting.

Writing functions/procedures use completely different languages, so any custom functions you have would have to be rewritten to whatever database you are moving.

To move queries between systems I would copy in the working SQL from the old system into a query window of the new system and see if it runs. If not, it will help you debug the query to get it working on the new system.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 05:51
Joined
Oct 29, 2018
Messages
21,358
Hi adnanhome. Just to make sure, are you asking what is the difference between Oracle and SQL Server?
 

The_Doc_Man

Immoderate Moderator
Staff member
Local time
Today, 07:51
Joined
Feb 28, 2001
Messages
27,001
So far as I know, they both use ANSI standard SQL 92 (though that doesn't help much.) There is a catch to using ANSI SQL in that they EXPRESSLY allow vendors to design actions and features that exceed the standard. And they also wrote that standard in a way that the names of some class of DB elements is less important than their function. So a SELECT query is an ORACLE VIEW (sometimes) whereas it is just a query in SQL Server.

Both ORACLE and SQL SERVER have ODBC connectivity options. Both have "native" front-end interface designers. Both can manage a lot of data. I know ORACLE's procedural language is a variant of PL/1 that perhaps isn't quite as strongly typed as the true compiler language. I think it is called PL/SQL. Can't tell you much about SQL SERVER and its procedural language.
 

adnanhome

Registered User.
Local time
Today, 05:51
Joined
Nov 12, 2008
Messages
16
Thank you very much all of you guys. In my access database it gives me final result that result there are some calculation. I want to covert into SQL query so that I could use it for reporting in PowerBi. I have using some external table on local machine. Can I insert those data in my sql query ?
 
Last edited:

theDBguy

I’m here to help
Staff member
Local time
Today, 05:51
Joined
Oct 29, 2018
Messages
21,358
Thank you very much all of you guys. In my access database it gives me final result that result there are some calculation. I want to covert into SQL query so that I could use it for reporting in PowerBi. I have using some external table on local machine. Can I insert those data in my sql query ?
Hmm, I am wondering what Oracle has to do with this...
 

Users who are viewing this thread

Top Bottom