Answered Questions

  • Oct 10 2005
    06:51 AM
    24044
    19

    When we give SELECT * FROM EMP; How does oracle respond:
    • SaratKumar

    Rahul

    • Jul 11th, 2013

    It retrieve or fetch all data from Emp table,and show all data of table like Emp as result.

    vaasukk@yahoo.com

    • Dec 13th, 2012

    First it will check the syntax and semantics in library cache, after that it will create execution plan. Already data in the buffer cache it will directly return to the client. If not it write the fetched to the dB buffer cache after that it will send server. Server sends to the client.