Re: set current schema does not work on Live SQL

Thanks a lot for your kindly reply.

Did you got any other info from LiveSQL godfather? 😊

*--*
*Att*

*Luis Santos*

2017-09-29 10:20 GMT-03:00 Jeff Smith <jeff.d.smith_at_oracle.com>:

> I’m pretty sure this is locked down/not allowed. Not sure exactly why it
> doesn’t give an error message.
>
>
>
> I’ll be with the LiveSQL godfather this coming week for OOW, I’ll ask him
> then 😊
>
>
>
> *From:* Luis Santos [mailto:lsantos_at_pobox.com]
> *Sent:* Friday, September 29, 2017 9:11 AM
> *To:* ORACLE-L <oracle-l_at_freelists.org>
> *Subject:* set current schema does not work on Live SQL
>
>
>
> I´m trying to set the default schema on Live SQL (livesql.oracle.com) by
> issuing, for example:
>
>
>
> *alter session set current schema = HR;*
>
>
>
> The weird is that this command does not result on an error. So, it seems
> that is been accepted.
>
>
>
> But does not have any affect. I still should denominate the schema before
> a table name...
>
>
>
> Is there a way to define the default schema on Live SQL?
>
>
>
>
>
> · Statement53
>
> alter session set current_schema=scott
>
> Statement processed.
>
> · Statement54
>
> · SELECT empno,
>
> · ename,
>
> · job,
>
> · sal
>
> · FROM emp
>
> ORDER BY sal
>
> ORA-00942: table or view does not exist
>
> · Statement55
>
> · SELECT empno,
>
> · ename,
>
> · job,
>
> · sal
>
> · FROM scott.emp
>
> ORDER BY sal
>
> *EMPNO*
>
> *ENAME*
>
> *JOB*
>
> *SAL*
>
> 7369
>
> SMITH
>
> CLERK
>
> 800
>
> 7900
>
> JAMES
>
> CLERK
>
> 950
>
> 7876
>
> ADAMS
>
> CLERK
>
> 1100
>
> 7654
>
> MARTIN
>
> SALESMAN
>
> 1250
>
> 7521
>
> WARD
>
> SALESMAN
>
> 1250
>
> 7934
>
> MILLER
>
> CLERK
>
> 1300
>
> 7844
>
> TURNER
>
> SALESMAN
>
> 1500
>
> 7499
>
> ALLEN
>
> SALESMAN
>
> 1600
>
> 7782
>
> CLARK
>
> MANAGER
>
> 2450
>
> 7698
>
> BLAKE
>
> MANAGER
>
> 2850
>
> 7566
>
> JONES
>
> MANAGER
>
> 2975
>
> 7902
>
> FORD
>
> ANALYST
>
> 3000
>
> 7788
>
> SCOTT
>
> ANALYST
>
> 3000
>
> 7839
>
> KING
>
> PRESIDENT
>
> 5000
>
> Download CSV
> <https://livesql.oracle.com/apex/f?p=590:6:14869123796473::LEVEL1:RP::&cs=3yHKDCeqflGt5zxBwzFqQQ3rDb1LU6GAv8DCoyrve9Zs60iITGgNa1sNOxFpMrgodPO7igTf9WG5Lnnys60zIAA>
> 14 rows selected.
>
>
>
> *--*
>
> *Att*
>
> *Luis Santos*
>
> *[image: Image removed by sender.]*
>

--
http://www.freelists.org/webpage/oracle-l







(image/jpeg attachment: _WRD084.jpg)