Command in script to set schema oracle

[fkeuroglian]

Hi expert!

I have a case that i have if i want to access and do a query to a ORACLE DATABASE I have to asociate the schema to every sql select

for example:

I have to put before the table the schema or user as i show here:

SQL Select * from SCHEMA.TABLE

is there any way to do this alter in qlikview script and avoid put the schema or user before each table in the sql select?

ALTER SESSION SET CURRENT_SCHEMA = BTWEB;

thanks a lot

Fernando K.

[elyM]

Hi Fernando,

you can try to pass your Oracle instruction using reserved word SQL.

SQL ALTER SESSION SET CURRENT_SCHEMA = BTWEB;

Usually I can send all DML instruction using SQL prefix.

SQL UPDATE TABLE....;
SQL DELETE FROM TABLE...;

I have tested SQL ALTERSESSION on our Oracle instances and it work correctly.

Regards,

Ely