Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
cancel
Showing results for 
Search instead for 
Did you mean: 

Regarding Database

sudhapage
Regular Advisor

Regarding Database

Hi all,

I am basically HPUX admin, now I have planned to do Oracle database cources for one project. But I don't have idea about Databases. I have some questions about databases, please share your knowledge with these questions.

1. I know oracle database will support number of platforms like unix, windows etc.. But my doubt is oracle commands will differ between different operating systems? or Just installation process only different?

2. What about SQL & PLSQL ? these also part of oracle? If yes it will support in UNIX Platforms?

Because usually I heard MS-SQL, so it will support only in windows? or SQL & Oracle are different?

Regards,
Sudhakaran.K
6 REPLIES
Peter Godron
Honored Contributor

Re: Regarding Database

Hi,
1. Oracle commands will be the same.
So "create table ..." for example will be the same. lsnrctl (Listener Control) will be same.
The installation is nomally done via the RunInstaller, which is near identical for Windows/HPUX.
2. SQL*Plus and PL/SQL are part of Oracle and source code is portable.

Probably best to look at:
http://en.wikipedia.org/wiki/Oracle_database
also
http://www.oracle.com/technology/documentation/database10g.html
and/or get a Oracle book.
Eric Antunes
Honored Contributor

Re: Regarding Database

Hi Sudhakaran,

What differs within each different platform is the way the binaries are compiled.

Best Regards,

Eric Antunes

Each and every day is a good day to learn.
Piergiacomo Perini
Trusted Contributor

Re: Regarding Database

Hi Sudhakaran,

yes , MS-SQL (Microsoft SQLServer) it's only based on windows
and
yes MS-SQL and Oracle are different.
And again, you can install Oracle on windows-server.

hth
regards
pg
spex
Honored Contributor

Re: Regarding Database

Hi Sudhakaran,

1. Yes, there are differences between Oracle on UNIX and Oracle on MS-Windows, although most of the commands are the same.

See "Oracle Database Windows/UNIX Differences":
http://www.stanford.edu/dept/itss/docs/oracle/10g/win.101/b10113/ap_unix.htm

2. PL/SQL is Oracle's extension to SQL. SQL & PL/SQL queries/programs will work across multiple OS platforms.

PCS
sudhapage
Regular Advisor

Re: Regarding Database

Thanks to all. I am going to join a oracle class for linux based platform. I hope there is no major differences between Linux and Unix platforms in oracle training.

Regards,
Sudhakaran.K

Re: Regarding Database

Sudhakaran,

I just attended the Oracle 10g: Administration Workshop I in Phoenix last week. They used Linux in the class and I saw no major differences with UNIX or Oracle. The major tools, oracle installer and Enterprise manager, are either java or web based, so the look and feel are the same on any platform. Good Luck.