DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: sql_context questions

  1. #1
    Join Date
    Nov 2000
    Posts
    71
    Can anyone help me in uderstanding what sql context is and using it?

    Thaks in advance

  2. #2
    Join Date
    Dec 2000
    Location
    Brazil / São Paulo
    Posts
    97
    What your really question ?
    I'm dont understand your doubt.
    Márcio de Souza Almeida
    DBA Oracle / SQLServer / PostgreSQL
    Rua Cupa, 139 Apto 85 A
    Penha - São Paulo - SP
    03640-000 - Brasil
    http://www.directory.com.br

  3. #3
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    Yes, a better explanation of the question would be useful.

    Where did you hear this term and in what, uh, context was it used? :)

    The only reference I can think of is SQL vs. PL/SQL context. If, for example, you have some PL/SQL code, a PL/SQL engine will be riunning it (you are in PL/SQL context). This engine could be the one on the server or could be a local engine that exists with some Oracle tools (Forms, etc.). In the middle of this PL/SQL code, you have a SQL statement. This statement will definitely go to the server and be run by the SQL engine there. You are now in SQL context. If, inside this SQL statement, you call a PL/SQL function, you will be switching out to PL/SQL context and running the PL/SQL function in a PL/SQL engine each time the function is called (possibly every row if the function is in the SELECT clause). Basically, this 'context-switching' is expensive and should be avoided, all other things being equal. Of course, if you absolutely need the PL/SQL function, then so be it, and you have to deal with the overhead.

    Is this what you were referring to?

    - Chris

Posting Permissions

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


Click Here to Expand Forum to Full Width