![]() SELECT ROLE_ID INTO role3Id FROM ROLES WHERE ROLE_NAME = 'Test role 3' INSERT INTO USERS_ROLES(USER_ID, ROLE_ID) VALUES(user2Id, role2Id) SELECT USER_ID INTO user2Id FROM PB_USER WHERE USER_NAME = 'RoleDataManagerTests_Username' SELECT ROLE_ID INTO role2Id FROM ROLES WHERE ROLE_NAME = 'Test role 2' ![]() INSERT INTO USERS_ROLES(USER_ID, ROLE_ID) VALUES(user1Id, role1Id) SELECT USER_ID INTO user1Id FROM PB_USER WHERE USER_NAME = 'RoleDataManagerTests_Username' SELECT ROLE_ID INTO role1Id FROM ROLES WHERE ROLE_NAME = 'Test role 1' VALUES(PB_ROLE_ID_SEQ.nextval, 'Test role 3') VALUES(PB_ROLE_ID_SEQ.nextval, 'Test role 2') VALUES(PB_ROLE_ID_SEQ.nextval, 'Test role 1') VALUES(PB_USER_ID_SEQ.nextval, 'RoleDataManagerTests_Username', ') INSERT INTO PB_USER(USER_ID,USER_NAME, USER_EMAIL, USER_ACTIVEYN) The script just populates some dummy data: DECLARE I'm having a problem trying to run my sql script into oracle using sqlplus.
0 Comments
Leave a Reply. |