set current schema does not work on Live SQL

From: Luis Santos <lsantos_at_pobox.com>
Date: Fri, 29 Sep 2017 10:11:08 -0300
Message-ID: <CAPWdmV_RsviUS6TnkC2vbpoMh9EUQ-FduzYtdWKNSNaDsQrYAQ_at_mail.gmail.com>

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
  <https://livesql.oracle.com/apex/f?p=590:1:14869123796473:::1:P1_STATEMENT_ID:120061647077859397082066377389325833786>
  

   alter session set current_schema=scott

   Statement processed.

• Statement54
  <https://livesql.oracle.com/apex/f?p=590:1:14869123796473:::1:P1_STATEMENT_ID:120061647077860606007885992018500539962>
  

   SELECT empno,

          ename,
          job,
          sal FROM   emp ORDER BY sal

   ORA-00942: table or view does not exist

• Statement55
  <https://livesql.oracle.com/apex/f?p=590:1:14869123796473:::1:P1_STATEMENT_ID:120061647077869068488623294422723483194>
  

   SELECT empno,

          ename,
          job,
          sal FROM   scott.emp ORDER BY sal

   EMPNOENAMEJOBSAL
   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 5000Download CSV
<https://livesql.oracle.com/apex/f?p=590:6:14869123796473::LEVEL1:RP::&cs=3yHKDCeqflGt5zxBwzFqQQ3rDb1LU6GAv8DCoyrve9Zs60iITGgNa1sNOxFpMrgodPO7igTf9WG5Lnnys60zIAA#>
   14 rows selected.

*--*
*Att*

*Luis Santos*

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

Received on Fri Sep 29 2017 - 15:11:08 CEST