摘要:
-- run 1_datatype_data.sql before running this script ALTER SESSION SET CURRENT_SCHEMA = SqlScriptDocumentation; drop procedure dynamic_sql_proc; CREATE PROCEDURE dynamic_sql_proc LANGUAGE SQLSCR... 阅读全文
摘要:
-- run 1_datatype_data.sql before running this script ALTER SESSION SET CURRENT_SCHEMA = SqlScriptDocumentation; drop procedure cursor_proc; CREATE PROCEDURE cursor_proc LANGUAGE SQLSCRIPT AS ... 阅读全文
摘要:
-- run 1_datatype_data.sql before running this script ALTER SESSION SET CURRENT_SCHEMA = SqlScriptDocumentation; drop procedure while_proc; CREATE PROCEDURE while_proc LANGUAGE SQLSCRIPT AS ... 阅读全文
摘要:
ALTER SESSION SET CURRENT_SCHEMA = SqlScriptDocumentation; DROP PROCEDURE addDiscount; CREATE PROCEDURE addDiscount( IN it_books tt_sales_books, OUT ot_books tt_sales_books) LANGUAGE SQLSCRI... 阅读全文
摘要:
DROP SCHEMA SqlScriptDocumentation CASCADE; CREATE SCHEMA SqlScriptDocumentation; ALTER SESSION SET CURRENT_SCHEMA = SqlScriptDocumentation; --test data CREATE COLUMN TABLE publishers( pub_id IN... 阅读全文
摘要:
SAP HANA中的用户是没有功能进行直接的拷贝的,但是我们可以通过建立存储过程调用,通过sql语句的方式进行拷贝: 存储过程定义如下,各位可根据自己的需求进行修改: CREATE PROCEDURE SYSTEM.COPY_USER (IN V_SOURCE_USER NVARCHAR(256), IN V_TARGET_USER NVARCHAR(256), IN V_TARGET_PWD ... 阅读全文