Database - Introduction to Database - Discussion

@Sridhar.

Oracle data base management system uses command line user interface which is very difficult to deal with. You will get to know the difficulty once you use the same. For instance, you will not be able to go back once you have pressed the enter key (to go to new line). Hence editing is very difficult once you have written and executed the query. You have to use one extra editor for this purpose. But all other DBMSs provide a pretty good user interface with all the advanced functionality.

Hope you got at least some idea. Now you start working with Oracle to know much :).

Thanks.

I think implementation and powerful tool which allow you to restrict and limit the access. And it is implemented all three level conceptual, representation and logical. About CMD line I think query in all DBMS is done by command line over console. Actually it is very traditional. Using blank and black console with one blinking cursor. Actually computer go this way.

@Rahul :

Oracle also supports GUI interface for many operations on database. e.g 10g, 11g.

@all :

Oracle as compared to other databases provides less flexibility in many operations, like creating automatic query by graphically joining tables, using multiple tables, creating tables etc..

I have used both MSSQL server and Oracle.

Security of Oracle is complex but very good.

Security of MSSQL server.

Creation of Database in MSSQL server is very compared to Oracle.

Create table space, profile, taking backup and restore backup is not simple in oracle as in MSSQL server.

I don't it is difficult to use. I have worked in oracle 8i as well as 10g. In 8i it is difficult to use. But not in 10g. 10g provided interactive GUI which is quite easy to use. And but obviously 12c the latest version would be more better. Thanks.

The easiest one is Microsoft access where anyone can create a database.

Hardest one is oracle. For creating a database in oracle you have to write lot of code.

@all.

Well, I think so, except oracle all other uses some kind of GUI which is user friendly more than firing queries in the ORACLE. :) That's it ! :).

Oracle is CUI based. So you need write command for every operation. Where MS access is much easier. But for JDBC I will prefer Oracle DBMS.

Oracle is DBMS software (developed by oracle corporation) used to create database allow to write query, procedure, triggers etc.

Can anybody explain me properly that why The DBMS that is most difficult to use in Oracle Corporation's Oracle?