Results 1 to 2 of 2

Thread: I want to join (scan) 1000 tables

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

    I want to join (scan) 1000 tables

    If i want to join (scan) 1000 tables to get the output then how to do this scenario in plsql or sql .this is interview question


  2. #2
    Junior Member
    Join Date
    Oct 2006
    Answers
    4

    Re: I want to join (scan) 1000 tables

    try to break the join into multiple set . and then using the concept of cursor prepare the reasonalble set of data to work and go ahead with the nested cursor. this will help you for the performation as well as it won't take the internal memory.


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