You must have always wondered why there is a uname / pwd in Oracle called, Scott/Tiger.... Who is this scott ? Here is the answer to ur query.... So, who is Scott? Bruce Scott was one of the first employees at Oracle (then Software Development Laboratories). He co-founded Gupta Technology (now known as Centura Software) in 1984 with Umang Gupta, and later became CEO and founder of PointBase, Inc. Bruce was co-author and co-architect of Oracle V1, V2 and V3. The SCOTT schema (EMP and DEPT tables), with password TIGER, was created by him. Tiger was the name of his cat.
It's only there if you select it at install time. Having a user called scott is by no means compulsory.
nice.... been wondering this for quite long In college we enter Scott/Tiger/Infotech any idea why infotech...or is it set by our college?
nice.... been wondering this for quite long In college we enter Scott/Tiger/Infotech any idea why infotech...or is it set by our college?
Is it scott/tiger/infotech or scott/tiger@infotech? If @ then that's the database alias - you're connecting in a client/server configuration and infotech is defined in $ORACLE_HOME/network/admin/tnsnames.ora. Another way to do the same thing would be to set the environment variable TWO_TASK=infotech, then sqlplus scott/tiger would do the same thing. If scott/tiger/infotech, no idea, never seen that syntax before, unless the password is "tiger/infotech".
@xp its @ and what i asked was like scott tiger, is infotech come pre installed? if yes any reasons like above?
No, infotech will have been setup by your sys admin. Have a look at tnsnames.ora and you'll see how it's defined, not much of any interest in there though. The scott schema doesn't come pre-installed; you have to select it in the installer.
TWO_TASK is an environment variable. If you set TWO_TASK=foo, then "sqlplus scott/tiger" is equivalent to "sqlplus scott/tiger@foo". If TWO_TASK isn't set, then "sqlplus scott/tiger" will connect to the local database, and throw an error if there isn't one. That's all there is to it; it means you can do a TNS connection while thinking you're doing a local connection. You can think of it as a "default database alias" if you like, but probably best to think of it as what it is.
There isn't one. SQL is just a language; see http://en.wikipedia.org/wiki/SQL Often Microsoft SQL Server is abbreviated to just SQL; have you done the same?