USER CLIENT TOOLS

USER CLIENT TOOLS

October 03, 2014
  • Tools used to connect to an oracle database, Most popular tools are
      1. SQL DEVELOPER
      2. SQL * PLUS
  • SQL Developer provide more functionality than SQL*Plus because SQL developer is a graphical terminal, whereas SQL*Plus is a character mode device.
  •   iSQL*plustool was introduced with release 9iand dropped with release 11g.




    SQL DEVELOPER:

    • SQL Developer is a tool for connecting oracle DB & issuing Ad-Hoc SQL commands.

    • It is a graphical tool with wizard for commonly needed actions.

    • It is written in java & require java runtime environment to run.

    • It is available on all platforms.

    • Developer: -SQL Developer provides powerful editors for working with SQL, PL/SQL, Stored Java Procedures, and XML. Run queries, generate execution plans, export data to the desired format (XML, Excel, HTML, PDF, etc.), execute, debug, test, and document your database programs, and much more with SQL Developer.

    • DBA:- SQL Developer isn't just for developers! Since version 3.0, the DBA Panel (available under the View menu) has provided database administrators a set of interfaces for their most critical tasks. SQL Developer will continue to add and enhance features for the DBA. Today,  SQL Developer's DBA panel provides support for. RMAN, DATA PUMP, AUDITING & RESOURCE MANAGER.

    • For more details refer this link: SQL Developer

       

      SQL * PLUS: 

      • It is a client server tool for connecting to a DB & issuing Ad-Hoc SQL commands. It can also for creating PL/SQL code. 
         
      • It is available for all platform, SQL * Plus is written in C language. 
       
      • SQL * Plus establish a session against an instance and database over oracle net protocols. 
       
      • SQL * Plus on windows:  
       
      • There are two versions for windows 
      1. Character version – sqlplus.exe (executable file) 
      2. Graphical version – sqlplusw.exe (executable file) 

      •  Location of executable file D:\oracle\app\product\11.1.0\db_2\BIN\sqlplus.exe
       
      • Followed by logon string enter manually  
          •  system/oracle@orcl    
          • sqlplus/nolog 
          • user: scott 
          • password: tiger

             


     

About

This is dummy text. It is not meant to be read. Accordingly, it is difficult to figure out when to end it. But then, this is dummy text. It is not meant to be read. Period.

Next
« Prev Post
Previous
Next Post »
Subscribe to: Post Comments (Atom)