naming - Selection of table (or view) in oracle, that I cannot find in TOAD -


i reverse-engineering application administers oracle database. new me (application + database) there statement there somewhere, is:

select * xxx@yyy (xxx word, yyy word)

if go database toad can't find 'xxx@yyy' table nor view. if copy paste statement in toad's editor, results if table exists.

  • i know '@' symbol allowed naming oracle object. possible means else here though?
  • how can find table (or view)? possible information through statement such schema 'xxx@yyy' belong or weather table or view, can track it?
  • the database consists of many schemas. there default one. possible xxx@yyy may belong schema, rather default?

please me find table.

identifier behind @ database link. way access objects on remote oracle server. more info on http://docs.oracle.com/cd/e11882_01/server.112/e26088/statements_5005.htm#sqlrf01205


Comments

Post a Comment

Popular posts from this blog

c# - Operator '==' incompatible with operand types 'Guid' and 'Guid' using DynamicExpression.ParseLambda<T, bool> -

i'm using dynamic linq library , there source code , basic docu , nuget version pm> install-package dynamiclinq i'm trying construct clause involves guids i have tried string "id == @0" . parameter array object[] value ( guid xxxx ) var whereclausesb = buildlogicalkeywhereclause2(entity, logicalkey); //build string var parms = buildparamarray(entity, logicalkey); // object[] var wherelambda = ofsi.bos.core.dynamicexpression.parselambda<t, bool>(whereclausesb.tostring(),parms); //parse an exception thrown in dynamicexpression.parselambda operator '==' incompatible operand types 'guid' , 'guid' i have tried guid , string.(fail) i tried , "id = @0" (fail). string == string works, int32==int32 not guid == guid not any ideas? try using equals method instead of == operator in string: "id.equals(@0)"
Read more