Database
文章平均质量分 68
假装80后
一个不念过去,不畏将来的程序员
展开
-
转载: SQL面试题
<br />转载自: http://blog.csdn.net/Leon110/archive/2009/07/20/4362436.aspx<br /> <br /> <br /> <br /> <br />题目1 <br />问题描述:<br />为管理岗位业务培训信息,建立3个表:<br />S (S#,SN,SD,SA) S#,SN,SD,SA 分别代表学号、学员姓名、所属单位、学员年龄<br />C (C#,CN ) C#,CN 分别代表课程编号、课程名称<br />SC ( S#,C转载 2010-06-07 15:59:00 · 762 阅读 · 0 评论 -
DB2 Passing transition tables from trigger to stored procedure
欢迎使用Markdown编辑器写博客本Markdown编辑器使用StackEdit修改而来,用它写博客,将会带来全新的体验哦:Markdown和扩展Markdown简洁的语法代码块高亮图片链接和图片上传LaTex数学公式UML序列图和流程图离线写博客导入导出Markdown文件丰富的快捷键快捷键加粗 Ctrl + B 斜体 Ctrl + I 引用 Ctrl原创 2016-11-04 22:38:33 · 500 阅读 · 0 评论 -
Oracle/DB2 null key index
(Index key is null means all fields in an index are null.)In DB2 only one NULL key may exist in a unique index.When table and index are created asCREATE TABLE TAB ( A DECIMAL(6原创 2016-10-16 12:59:06 · 1177 阅读 · 0 评论 -
SQL Function for DB2 and ORA
SQL Function in DB2 9(UDF=user defined function)DB2 9 and earlier, your could only has RETURN statement in your UDF logic. (This is a too limited design)• RETURN can’t contain a SELECT sta原创 2016-11-12 09:15:07 · 398 阅读 · 0 评论 -
JDBC query table definition
JDBC retrieve table columns information public void describeTable(String tableName) { try { PreparedStatement pstmt = conn .prepareStatement("select * from原创 2016-11-19 14:31:22 · 453 阅读 · 0 评论 -
DB2 C language external scalar user-defined function
Sample step of define a C language external scalar user-defined function.1. Define function implementation using C language$ cat mymd5.c#include #include #include #include #include #i原创 2016-11-26 08:32:00 · 486 阅读 · 0 评论 -
DB2 how to drop overloaded functions
When you try to drop an overloaded function/procedure, DB2 will report a SQL0476N error code.For example: if function MY_TOCHAR is overloaded withCREATE FUNCTION MY_TOCHAR(P DATE) RETURNS VARCHA原创 2016-11-26 08:36:48 · 1028 阅读 · 0 评论