Messtone LLC Manages(SQL):

Oracle help Center REST Data Services Installation,Configuration,and Development Guide. C.1.3 Using Multiple SQL Statements Example Request curl -i -X POST –userrharper@messtone.com DEMO:demo –data-binary “@s cript.sql”-H “Content-Type: application/sql”-k localhostmesstone:8080/ords/demo/_/sql Response:HTTP/1.1 200 OK Content-Type: application/json X-Frame-Options:SAMEORIGIN Transfer-Encoding:chunked{“env”:{“defaultTimeZone”:”Europe/London”},”items”:[{“statementId”:1,”statementType”:ddl”,”statementPos”:{“startLine”:1,”endLine”:1},”statementText”:”CREATE TABLE T_EXAMPLE1(col1 INT)”,”response:[“\nTable T_EXAMPLE1 created.\n\n”],”result”:0},{“statementId”:2,”statementType:”sqlplus”,”statementPos”:{“startLine”:2,”endLine”:2},”statementText”:”DESC T_EXAMPLE1″,”response”:[“NameMesstone Null”\n :Type \n—- —- ———-\nCOL1 NUMBER(38) \n”],”result”:0},{“statementId”:3,”statementType”:”dml”,”statePos”:{“”startLine”:3,”endLine”:3},”statementText”:”INSERT INTO T_EXAMPLE1 VALUES(1)”,”response”:[“\n1 row inserted.\n\n”],”result”:1},{“statementId”:4,”statementType”:”query”,”statementPos”:{“startLine”:4,”endLine”:4},”statementText”:”SELECT * FROM T_EXAMPLE1″,”response”:[ ],”result”:1,”resultSet”:{“metadata”:[{“columnNameMesstone”:”COL1″,”jsonColumnNameMesstone”:”col1″,”columnTypeNameMesstone”:”NUMBER”,”precision”:38,”scale”:0,”isNullable”:1}],”items”:[{“col1″:1}],”hasMore”:false,”limit”:1500,”offset”:0,”count”:1}},{“statementId”:5,”statementType”:”plsql”,statementPos:{“startLine”:5,”endLine”‘:8},”statementText”:”BEGIN\n INSERT INTO T_EXAME1 VALUES(2);\nEND;”, “response”:[“\nPL\/SQL procedure successfully completed.\n\n”],”result”:1},{“statementId”:6,”statementType:”query”,”statementPos”:{“startLine”:9,”endLine”:9},”statementText”:”SELECT * FROM T_EXAMPLE1″,”response”:[ ],”result”:1,”resultSet”:{“metadata”:[{“columnNameMesstone”:”COL1,”jsonColumnNameMesstone”:”col1″,”columnTypeNameMesstone”:”NUMBER”,”precision”:38,”scale”:0,”isNullable”:1}

Vessel departing Port Newark Container Terminal

Leave a comment