Results 1 to 15 of 15
  1. #1
    Join Date
    May 2012
    Posts
    13

    Unanswered: where i can enter query in oracle ????

    Hi guys ,

    i have installed oracle 11g Release 2 in my system and i created database in oracle now i really dont no where i can enter query for oracle


    where i can enter query for make table and other things in oracle, please guide me


    waiting for Reply.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Code:
    bcm@bcm-laptop:~$ sqlplus scott/tiger
    
    SQL*Plus: Release 11.2.0.1.0 Production on Fri Jun 1 09:42:37 2012
    
    Copyright (c) 1982, 2009, Oracle.  All rights reserved.
    
    
    Connected to:
    Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options
    
    09:42:37 SQL> select table_name from user_tables;
    
    TABLE_NAME
    ------------------------------
    DEPT
    EMP
    BONUS
    SALGRADE
    STAFF
    XTERN_EMPL_RPT3
    
    6 rows selected.
    
    09:42:48 SQL>
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    May 2012
    Posts
    13
    dude what application i need to use enter this query i know how to make table i already made in SQL 2000/05/08 but i m new to oracle plz tell me which application i should use to enter this query

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    sqlplus as shown in top line of my response

    What is your Operating System name & version?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    May 2012
    Posts
    13
    i am using window 7 ultimate 32 bit
    can u explain the way how i connect and use this query analyzer ?????


    here any chatting option available ????



    Thanks

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    open Command Window & issue following OS command

    sqlplus

    Code:
    bcm@bcm-laptop:~$ sqlplus -help
    
    SQL*Plus: Release 11.2.0.1.0 Production
    
    Copyright (c) 1982, 2009, Oracle.  All rights reserved.
    
    Use SQL*Plus to execute SQL, PL/SQL and SQL*Plus statements.
    
    Usage 1: sqlplus -H | -V
    
        -H		   Displays the SQL*Plus version and the
    		   usage help.
        -V		   Displays the SQL*Plus version.
    
    Usage 2: sqlplus [ [<option>] [{logon | /nolog}] [<start>] ]
    
      <option> is: [-C <version>] [-L] [-M "<options>"] [-R <level>] [-S]
    
        -C <version>   Sets the compatibility of affected commands to the
    		   version specified by <version>.  The version has
    		   the form "x.y[.z]".	For example, -C 10.2.0
        -L		   Attempts to log on just once, instead of
    		   reprompting on error.
        -M "<options>" Sets automatic HTML markup of output.  The options
    		   have the form:
    		   HTML [ON|OFF] [HEAD text] [BODY text] [TABLE text]
    		   [ENTMAP {ON|OFF}] [SPOOL {ON|OFF}] [PRE[FORMAT] {ON|OFF}]
        -R <level>	   Sets restricted mode to disable SQL*Plus commands
    		   that interact with the file system.	The level can
    		   be 1, 2 or 3.  The most restrictive is -R 3 which
    		   disables all user commands interacting with the
    		   file system.
        -S		   Sets silent mode which suppresses the display of
    		   the SQL*Plus banner, prompts, and echoing of
    		   commands.
    
      <logon> is: {<username>[/<password>][@<connect_identifier>] | / }
    	      [AS {SYSDBA | SYSOPER | SYSASM}] [EDITION=value]
    
        Specifies the database account username, password and connect
        identifier for the database connection.  Without a connect
        identifier, SQL*Plus connects to the default database.
    
        The AS SYSDBA, AS SYSOPER and AS SYSASM  options are database
        administration privileges.
    
        <connect_identifier> can be in the form of Net Service Name
        or Easy Connect.
    
          @[<net_service_name> | [//]Host[:Port]/<service_name>]
    
    	<net_service_name> is a simple name for a service that resolves
    	to a connect descriptor.
    
    	Example: Connect to database using Net Service Name and the
    		 database net service name is ORCL.
    
    	   sqlplus myusername/mypassword@ORCL
    
    	Host specifies the host name or IP address of the database
    	server computer.
    
    	Port specifies the listening port on the database server.
    
    	<service_name> specifies the service name of the database you
    	want to access.
    
    	Example: Connect to database using Easy Connect and the
    		 Service name is ORCL.
    
    	   sqlplus myusername/mypassword@Host/ORCL
    
        The /NOLOG option starts SQL*Plus without connecting to a
        database.
    
        The EDITION specifies the value for Session Edition.
    
    
      <start> is: @<URL>|<filename>[.<ext>] [<parameter> ...]
    
        Runs the specified SQL*Plus script from a web server (URL) or the
        local file system (filename.ext) with specified parameters that
        will be assigned to substitution variables in the script.
    
    When SQL*Plus starts, and after CONNECT commands, the site profile
    (e.g. $ORACLE_HOME/sqlplus/admin/glogin.sql) and the user profile
    (e.g. login.sql in the working directory) are run.  The files may
    contain SQL*Plus commands.
    
    Refer to the SQL*Plus User's Guide and Reference for more information.
    bcm@bcm-laptop:~$
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  7. #7
    Join Date
    May 2012
    Posts
    13
    still not getting


    what exact command i use in cmd ?????

  8. #8
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    for the THIRD & final time!

    open Command Window & type the line below

    sqlplus
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  9. #9
    Join Date
    May 2012
    Posts
    13
    ok ok dude dont get angry i ll try this


    thanks for helping me.....

  10. #10
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    when all else fails Read The Fine Manual

    Contents
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  11. #11
    Join Date
    May 2012
    Posts
    13
    hey dude,

    do u have anything to read for me that helps me to learn oracle ??????

  12. #12
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  13. #13
    Join Date
    May 2012
    Posts
    13
    Dude I tried this "sqlpluse" but its not working maybe something missing maybe any connectivity
    Please guide me


    Thanks

  14. #14
    Join Date
    May 2012
    Posts
    13
    Error comes
    ORA-28000: the account is locked

  15. #15
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Quote Originally Posted by tdalvi View Post
    i have installed oracle 11g Release 2 in my system and i created database in oracle now i really dont no where i can enter query for oracle
    Apart from SQL*Plus, Oracle 11 comes with SQL Developer. It should be in the Oracle folder of the Windows Start menu.

    Detailed information about how to use it is available in the manual:
    http://docs.oracle.com/cd/E11882_01/...e12152/toc.htm

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •