Database - Introduction to Database - Discussion

International Business Machines.

What is the full from of IBM?

We can also write an queries in SQL, then what is the difference between SQL and ORACLE?

Yes, in Oracle for creating database you should write more code. But not that much difficult.

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.

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.

@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.

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

@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..

@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 ! :).