Answered Questions

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


    • Jul 11th, 2013

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

    • 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.