kalo menggunakan schema lain, pada from nya ditambahkan schema.table nya
contohnya: select from schema.table where

Regards, 

Toyo

--- On Thu, 8/12/10, [email protected] <[email protected]> 
wrote:

From: [email protected] <[email protected]>
Subject: [indo-oracle] Tanya
To: [email protected]
Date: Thursday, August 12, 2010, 1:39 AM

permisi pak/bu, nubie ingin numpang nanya:

Saya mempunyai mslah sbb:

view yg saya execute (cm select where doank) di 1 skema berjalan lancar, namun 
di skema lain (structure view sm persis) berjalan tdk lancar, butuh wkt hingga 
1 jam. Padahal query nya sama persis, SELECT WHERE. Knp ya pak/bu ?

Mohon pencerahannya pak/bu :)

Sent from my BlackBaron®
powered by Sinyal Kuat INDOSESAT

------------------------------------

--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [email protected]
Website: http://indooracle.wordpress.com
http://www.facebook.com/group.php?gid=51973053515
-----------------------------------------------

Bergabung dengan Indonesia Thin Client User Groups, 
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.blogspot.comYahoo! Groups Links






      

[Non-text portions of this message have been removed]

Kirim email ke