![]() ![]() We can only use the HTTPS URL by default for SQL Developer Web. Normal web services from the schema can now be referenced using the following base URLs. In this example we've used a schema alias of "hr". We could use any unique and legal URL mapping pattern for the schema, so it is not necessary to expose the schema name. ![]() INSERT INTO DEPT VALUES (40,'OPERATIONS','BOSTON') INSERT INTO DEPT VALUES (30,'SALES','CHICAGO') INSERT INTO DEPT VALUES (20,'RESEARCH','DALLAS') INSERT INTO DEPT VALUES (10,'ACCOUNTING','NEW YORK') We connect to the test user and create some test tables.ĭEPTNO NUMBER(2) CONSTRAINT PK_DEPT PRIMARY KEY,ĮMPNO NUMBER(4) CONSTRAINT PK_EMP PRIMARY KEY,ĭEPTNO NUMBER(2) CONSTRAINT FK_DEPTNO REFERENCES DEPT GRANT CREATE SESSION, CREATE TABLE, CREATE PROCEDURE TO testuser1 We need a new database user for our testing.ĬREATE USER testuser1 IDENTIFIED BY testuser1ĭEFAULT TABLESPACE users QUOTA UNLIMITED ON users If you want to do it, it is explained here, but please don't! SQL Developer Web will only work with HTTP if you enable HTTP access to REST Enabled SQL, which is a bad idea, as you will be transferring passwords across the network.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |