tag:blogger.com,1999:blog-2857359783252521873.post676692302619396204..comments2024-02-14T03:16:26.174-05:00Comments on Oracle: oracle alter session set current_schemaOracle DBAhttp://www.blogger.com/profile/13853786528521753164noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-2857359783252521873.post-55003788819984727832016-03-15T07:29:11.253-04:002016-03-15T07:29:11.253-04:00Hi Good information.
Oracle training
MS Dynamics...Hi Good information.<br /><br /><a href="http://http://sitctraining.com/" rel="nofollow">Oracle training</a><br /><br /><a href="http://http://microsoftdynamics.co.in/" rel="nofollow">MS Dynamics training</a>Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2857359783252521873.post-66951805977657315732013-05-20T07:04:14.236-04:002013-05-20T07:04:14.236-04:00I have tried its work when I have to do in SQL but...I have tried its work when I have to do in SQL but in pl/SQL block it doesn't work it only run a command in last user.<br />CREATE OR REPLACE PROCEDURE conn<br />AS<br />USER_REC VARCHAR2(10);<br />V_USER VARCHAR2(30);<br />COUN INTEGER;<br />str varchar2(100);<br />str1 varchar2(30);<br />str2 varchar2(30);<br />str3 varchar2(20);<br /><br /> CURSOR USER_NAME IS SELECT USERNAME FROM ALL_USERS where username = 'TEST';<br /> <br />BEGIN<br /> <br /> select count(*) into COUN FROM ALL_USERS where username like 'TEST%';<br /> <br /> FOR USER_REC IN USER_NAME<br /> LOOP<br /> <br /> IF COUN > 0 then<br /> --str='ALTER SESSION SET CURRENT_SCHEMA='||USER_REC.USERNAME;<br /> V_USER:=USER_REC.USERNAME;<br /> EXECUTE IMMEDIATE 'ALTER SESSION SET CURRENT_SCHEMA='||USER_REC.USERNAME;<br /> select sys_context('USERENV','SESSION_USER') current_user,sys_context('USERENV','SESSION_SCHEMA') current_schema into str1,str2 from dual;<br /> dbms_output.put_line('users : ' || str1);<br /> dbms_output.put_line('schema : ' || str2);<br /> end if;<br /> <br /> END LOOP; <br />END;<br />/Prashanthttps://www.blogger.com/profile/12802535907014556255noreply@blogger.com