RE: set current schema does not work on Live SQL
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