Displaying 1 result from an estimated 1 matches for "test_artcl_inst".
2007 Nov 07
1
Dealing with schema in RODBC
Is there a way to get a table in a certain schema? The Oracle database I am
using has a table by the same name in two different schemas. This creates
problems in sqlUpdate because to sqlUpdate there are duplicate columns. The
following is part of the output of sqlColumns:
sqlColumns(eids, "TEST_ARTCL_INST")[,1:4]
TABLE_CAT TABLE_SCHEM TABLE_NAME COLUMN_NAME
1 EIDS TEST_ARTCL_INST CHANNEL_ID
2 EIDS TEST_ARTCL_INST ARTICLE_TEST_ID
3 EIDS TEST_ARTCL_INST CHANNEL_OLD_ID
4 EIDS TEST_ARTCL_INST...