{"id":14260,"date":"2023-02-23T15:31:57","date_gmt":"2023-02-23T21:31:57","guid":{"rendered":"http:\/\/201.237.206.56\/Sitios\/ugit.siua.ac.cr\/?p=14260"},"modified":"2023-03-03T16:41:56","modified_gmt":"2023-03-03T22:41:56","slug":"prueba","status":"publish","type":"post","link":"https:\/\/sada.services\/?p=14260","title":{"rendered":"Prueba"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Script producci\u00f3n<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>-- ****************************************************************\n-- ****************************************************************\n-- ACTUALIZACI\u00d3N 07 Creacion: Tabla: EXCEPCION_CODIGO PPI-324 (esteban)\n-- ****************************************************************\n-- ****************************************************************\n-- NOTA: la tabla NO EXISTE en producci\u00f3n\n\n\n\n-- \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n-- PASO1: CREACI\u00d3N DE TABLA \n-- \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n\n CREATE TABLE \"PPI\".\"EXCEPCION_CODIGO\" \n   (\t\"ID_EXCEPCION_CODIGO\" \t\tNUMBER(19,0) NOT NULL ENABLE, \n\t\t\"EXCEPCION_PRESUPUESTARIA\" \tNUMBER(19,0) NOT NULL ENABLE, \n\t\t\"CODIGO_PRESUPUESTARIO\" \tNUMBER(19,0) NOT NULL ENABLE, \n\t\t\"USUARIO_CREACION\" \t\t\tNUMBER(19,0), \n\t\t\"FECHA_CREACION\" \t\t\tDATE, \n\t\t\"USUARIO_MODIFICACION\" \t\tNUMBER(19,0), \n\t\t\"FECHA_MODIFICACION\" \t\tDATE, \n\t\t\"CAMPO_CONFIGURABLE\" \t\tVARCHAR2(20 BYTE), \n\t\t\"VERSION\" \t\t\t\t\tVARCHAR2(20 BYTE), \n\t \tCONSTRAINT \"EXCEPCION_CODIGO_PK\" PRIMARY KEY (\"ID_EXCEPCION_CODIGO\")\n  \t\tUSING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS \n  \t\tTABLESPACE \"PPI\"  ENABLE, \n\t \tCONSTRAINT \"EXCEPCION_CODIGO_FK1\" FOREIGN KEY (\"EXCEPCION_PRESUPUESTARIA\")\n\t  \tREFERENCES \"PPI\".\"EXCEPCION_PRESUPUESTARIA\" (\"ID_EXCEPCION_PRESUPUESTARIA\") ENABLE, \n\t \tCONSTRAINT \"EXCEPCION_CODIGO_FK2\" FOREIGN KEY (\"CODIGO_PRESUPUESTARIO\")\n\t  \tREFERENCES \"EPF\".\"CODIGO_PRESUPUESTARIO\" (\"ID_CODIGO_PRESUPUESTARIO\") ENABLE\n   ) SEGMENT CREATION DEFERRED \n  \tPCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 \n \tNOCOMPRESS LOGGING\n  \tTABLESPACE \"PPI\" ;\n\n\n\n\n-- \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n-- PASO2: CREACI\u00d3N DE SECUENCIA\n-- \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\nCREATE SEQUENCE PPI.SQ_EXCEPCION_CODIGO\nSTART WITH 1\nINCREMENT BY 1\nMINVALUE 1\nNOCACHE \nNOCYCLE \nNOORDER; \n\n-- \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n-- PASO3: CREACI\u00d3N DE SINONIMOS\n-- \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\nCREATE PUBLIC SYNONYM EXCEPCION_CODIGO for PPI.EXCEPCION_CODIGO;\nCREATE PUBLIC SYNONYM SQ_EXCEPCION_CODIGO for PPI.SQ_EXCEPCION_CODIGO;\n\n-- \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n-- PASO4: CREACI\u00d3N DE GRANTS\n-- \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\nGRANT DELETE, INSERT, UPDATE, SELECT, REFERENCES ON PPI.EXCEPCION_CODIGO TO WWW_SIGESA;\nGRANT SELECT, ALTER ON PPI.SQ_EXCEPCION_CODIGO TO WWW_SIGESA;\nGRANT SELECT ON \"PPI\".\"EXCEPCION_CODIGO\" TO \"ANALISTA\", \"ANALISTA_SIGESA\";<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Script producci\u00f3n<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-14260","post","type-post","status-publish","format-standard","hentry","category-sin-categoria"],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":6}},"_links":{"self":[{"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts\/14260","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=14260"}],"version-history":[{"count":34,"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts\/14260\/revisions"}],"predecessor-version":[{"id":14300,"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts\/14260\/revisions\/14300"}],"wp:attachment":[{"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=14260"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=14260"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=14260"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}