RE: set current schema does not work on Live SQL

From: Jeff Smith <jeff.d.smith_at_oracle.com>
Date: Fri, 29 Sep 2017 06:20:57 -0700 (PDT)
Message-ID: <a00b6879-6e5a-4ccf-9b0c-573c32599da7_at_default>





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 (HYPERLINK "http://livesql.oracle.com"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

HYPERLINK "https://livesql.oracle.com/apex/f?p=590:6:14869123796473::LEVEL1:RP::&cs=3yHKDCeqflGt5zxBwzFqQQ3rDb1LU6GAv8DCoyrve9Zs60iITGgNa1sNOxFpMrgodPO7igTf9WG5Lnnys60zIAA"Download CSV 14 rows selected.

 

--

Att

Luis Santos

--

http://www.freelists.org/webpage/oracle-l Received on Fri Sep 29 2017 - 15:20:57 CEST

Original text of this message