oracle11g - Is it possible to query off a Sybase table and join with an Oracle dimension table? -


is possible?

select s.*, o.* sybaseserver.database.schema.table s  left join oracleserver.schema.table o on s.syabseid = o.oracleid

you can install oracle transparent gateway allow oracle query use db link towards sybase ase server.


Comments

Post a Comment

Popular posts from this blog

string - Using python and postgres, variables within execute function? -

i had question regarding usage of variables inside python function accesses postgresql server. example, following: def delete(): cur.execute( """delete potluck name = var_1;""" however, if wanted update function take in variables var_1, how so? for example, want function in form: def delete(var_1): cur.execute( """delete potluck name = %s;""", (var_1)) however, typing didn't work. in addition, how in case when: def delete(name, var_1): cur.execute( """delete potluck %s = %s;""", (name, var_1)) where don't want "name" have quotation marks when inserted string? any appreciated! to pass identifiers use psycopg2.extensions.asis from psycopg2.extensions import asis def update(table_name, var_1, var_2): cur.execute(""" update %s set %s = 'y' %s = 'john'; ...
Read more

android - How to get the Uri path from a ImageView? -

i trying create wallpaper application. images come internet. before of set background, need crop image. , this, using api named androidimagecropper. api need of uri object execute crop. how can uri imageview? because image internet. image not on drawable folder. confusing. maybe guys can me. public class mainactivity extends appcompatactivity { private networkimageview imageview; private uri mcropimageuri; public static final string url_photo = "http://cdn.wonderfulengineering.com/wp-content/uploads/2016/02/iron-man-wallpaper-42-610x1084.jpg"; @override protected void oncreate(bundle savedinstancestate) { super.oncreate(savedinstancestate); setcontentview(r.layout.activity_main); imageview = (networkimageview) findviewbyid(r.id.image_view); // singleton volley api, load image internet imageloader loader = mysingleton.getinstance(this).getimageloader(); loader.get(url_photo, imageloader.getimagelistener(imageview, r.drawable.temp_picture, ...
Read more