Results 1 to 6 of 6

Thread: SELECT query processing

  1. #1
    Junior Member
    Join Date
    Dec 2006
    Answers
    1

    Smile SELECT query processing

    How exactly SELECT query is processed internally after initial startup of Database?


  2. #2
    Contributing Member
    Join Date
    Apr 2007
    Answers
    46

    Re: SELECT query processing

    HI,

    As soon as u enter any SQL query, internally three processes occur:-
    1.in first process the syntax error is checked.
    2. second process is called parsing,in this oracle check whether the table is existing or not then column are checked n all.Also variable's value are assigned in this step only.
    3.In third step execution of the query will occur and result is represented.


  3. #3
    Contributing Member
    Join Date
    Jul 2006
    Answers
    50

    Re: SELECT query processing

    Only when a DDL statement gets accessed each time of its accessing the data dictionary is made referenced to. Once a database gets started on a database server a memory area called as System Global Area also called as SGA in short gets allocated. Then one or more Oracle processes get started. After starting of the instance the database gets mounted by the instance for querying and further processing on the database. Also after starting of the instance the listener opens and establishes a communication pathway and this is through which users connect to database for further processing of select statement.


  4. #4
    Expert Member
    Join Date
    Jun 2006
    Answers
    410

    Re: SELECT query processing

    Hope this link will be useful to u

    http://www.adp-gmbh.ch/ora/concepts/sql_stmt.html#parse


  5. #5
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Re: SELECT query processing

    its better to follw the provided link or any good matrial for the topic.


  6. #6
    Junior Member
    Join Date
    Jun 2007
    Answers
    18

    Re: SELECT query processing

    parse binds executes fetch
    this is the sequence of execution of any statement


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact