Yawen's Study Notes

原创 【项目管理】投资回报率 ROI(Return on Investment)

FormulaROI = Net profit / total investment X 100%投资回报率 = 利润 / 总量 x 100%一段时间内，在某一数值下，收入与投入的比例（通过投资返回的价值）。数值越高证明该投入越有价值管理人员必须通过投资和现有财产获得利润Can be used in conjunction with ROR(rate of return) ->...

原创 【PL/SQL】 Oracle procedure: Hello world

set serveroutput on/* practice 9 *//* 1 */create or replace procedure greet ISbegin dbms_output.put_line('hello world'); dbms_output.put_line('today is : ' || to_char(sysdate, 'dd-MON-y...

原创 【PL/SQL】CURSOR

set pagesize 120set serveroutput ondeclarec_id employees.employee_id%type;c_ln employees.last_name%type;c_s employees.salary%type;cursor cc isselect employee_id, last_name, salaryfrom employee...

原创 【PL/SQL】ME IN PROCEDURE Analysis & Example | oracle数据库: 用procedure合并数据的案例分析GE

set pagesize 120;/* procedure practice */--display original table create table tempid ASselect employee_id, last_name, salary from employeeswhere employee_id > 100 and employee_id < 110;...

原创 PL/SQL】DELETE IN PROCEDURE Analysis & Example | oracle数据库: 用procedure删除数据的案例分析

/* procedure practice */--display original table select * from regions;drop sequence s_regions;--ceshi procedurecreate or replace procedure add_ceshi( p_id regions.region_id%type, p_name...

原创 【PL/SQL】 ROLLBACK WHEN EXECUTE A PROCEDURE Analysis & Output | oracle数据库: 回滚案例的输出与分析

/* procedure practice */--display original table select * from regions;--ceshi procedurecreate or replace procedure add_ceshi( p_id regions.region_id%type, p_name regions.region_name%type...

原创 【PL/SQL】 UPDATE IN PROCEDURE Analysis & Example | oracle数据库: 用procedure修改数据的案例分析

/* procedure practice */--display original table select * from regions;--ceshi procedurecreate or replace procedure add_ceshi( p_id regions.region_id%type, p_name regions.region_name%type...

原创 【PL/SQL】 INSERT IN PROCEDURE Analysis & Example | oracle数据库: 用procedure插入数据的案例分析

/* procedure practice */--display original table select * from regions;--test sequence before declare the proceduredrop sequence s_regions;create sequence s_regions start with 12 increme...

原创 【PL/SQL】ORACLE学习心路历程

原创 【AVL】平衡二叉树

AVL-height balanced BST-Each node must maintain the height of its subtree—Insertion AlgorithmRegular steps +BST-this new node has the height of 1- work out way back up to the root- calculate ba...

原创 Conditionals/ loops/ case selectors(case expressions) UC

Conditionals/ loops/ case selectors(case expressions)IF condition THENStatement;ELSEIF condition THENStatement;ELSEStatement;END IF;IF statement only reflect to true(false || null)case select...

原创 【PL/SQL】Composite Data Type II

Composite Data Types-can hold multiple data-have logical connection-record:-Must contain one or more component( field/ column )-similar to structure-attribute &ROWTYPE:-declare a variable a...

原创 【PL/SQL】Cursor

Explicit cursor functions:-Can perform row-by-row processing beyond the first row returned by a query-Keep track of the row that is currently being processed-Enable the programmer to manually contr...

原创 【PL/SQL】Composite Data Type

Scalar data type only holds one valueComposite Data TypesCan hold multiple values (unlike scalar types)Are of two types:–  PL/SQL recordsused to treat related but dissimilar data as a logica...

原创 【PL/SQL】Control structure example

Loop example1)SELECT NVL(ROUND(salary/1000), 0) INTO v_salFROM emp WHERE employee_id = v_empno;FOR i IN 1…v_salLOOPv_asterisk := v_asterisk ||’*’;END LOOP;UPDATE emp SET stars = v_asteriskW...

原创 【PL/SQL】Control structure

IF:IF condition THEN statements;[ELSIF condition THEN statements;][ELSE statements;]END IF;Case expressionappraisal := CASE v_gradeappraisal := CASECASE v_mngidFor:Do not reference the coun...

原创 【PL/SQL】Insert/ update/ delete/ merge

Insert:BEGININSERT INTO employees(employee_id, first_name, last_name, email, hire_date, job_id, salary)VALUES(employees_seq.NEXTVAL, ‘Ruth’, ‘Cores’, ‘RCORES’,CURRENT_DATE, ‘AD_ASST’, 4000);END; ...

原创 【PL/SQL】expression & common function

Lexical units:-Are building blocks of any PL/SQL block-Are sequences of characters including letters, numerals, tabs, spaces, returns, and symbols-Can be classified as:Identifiers: v_fname, c_perc...

原创 【PL/SQL】常见print out格式

DisplayDBMS_OUTPUT.PUT_LINE()Set serveroutput onprocedure allows you to write data to flat file or to direct your PL/SQL output to a screen.PRINTset autoprint onBind VariableHeadingset heading...

原创 【PL/SQL】类型和变量 | Data Type & Variables

Block type:Anonymous:declare??Subprograms are complementary to anonymous blocks.Procedure:procedure name isFunction: function name return datatype isvariable：Temporary storage of dataManipulati...

原创 【PL/SQL】PL/SQL和SQL的区别

PL/SQL:-Procedural Language extension to SQL-Oracle Corporation’s standard data access language for relational databases-Seamlessly integrates procedural constructs with SQL-Block structure to exc...

原创 【SSAS】SQL Server Analysis services | 【数据分析 (一) 】名词解释

Words DefinitionSSDT:SQL Server Data ToolsSSAS:SQL Server Analysis servicesAnalysis Services projectA project based on an Analysis Services multidimensional model template。SolutionIncludes ...

原创 table/ sort/ tree

HashTableAbstract datatypefaster data retrieval,encrypt and decrypt digital signaturesa technique that is used to uniquely identify a specific object from a group of similar objects.A hash table ...

原创 【C++ 算法笔记】 Sort的六种方法 【二】Quick Sort

IMPORTANTTHIS IS NOTE I MADE WHEN STUDY C++ ALGORITHMTHIS NOTE WOULD ONLY HELP U SPEND LESS TIME ON UNDERSTNDING THE ALGORITHM AND CODE IMPLEMENTATIONALL WORDS IN " " ARE DIRECTLY REFERENCEALL COD...

原创 【C++ 算法笔记】 Sort的六种方法 【二】Merge Sort

IMPORTANTTHIS IS NOTE I MADE WHEN STUDY C++ ALGORITHMTHIS NOTE WOULD ONLY HELP U SPEND LESS TIME ON UNDERSTNDING THE ALGORITHM AND CODE IMPLEMENTATIONALL WORDS IN " " ARE DIRECTLY REFERENCEALL COD...

原创 【C++算法笔记】Sort的六种方法 【一】

IMPORTANTTHIS IS NOTE I MADE WHEN STUDY C++ ALGORITHMTHIS NOTE WOULD ONLY HELP U SPEND LESS TIME ON UNDERSTNDING THE ALGORITHM AND CODE IMPLEMENTATIONALL WORDS IN " " ARE DIRECTLY REFERENCEALL COD...

原创 再见rpgle

笔记整理过的部分已经全部po出来了。。。如果有哪位仁兄在挣扎这玩意的请私戳我，我的资料都给你。。。过去的四个月里，我打开IBM网站的次数比我打开微信的次数都还多。。。不过再见！再碰rpgle或者clle这种年纪比我爹还大的东西我就是煞笔！再见！（前提是过。。。这种东西简直反人类，二十年前的程序员真是辛苦了。。。...

原创 IBM [CLLE] 所有command一网打尽系列 [持续更新]

IBM 官方手册 clle obj 相关指令

原创 IBM [RPGLE] Declaration under Free Format

File:DCL-FData:DCL-DSDCL-SDCL-CDCL-Pi procedure interface(actual parameter)DCL-PR prototypeCTL-OPT Control optionAvoid H spaceEXT/EXTNAME(‘…’) Externally described data structure*N unname...

原创 IBM [RPGLE] Words specification under free format

File description(F)File name |file type(I) | I(INPUT)file designataion§ |end of field(E) | E(Externally described)file addition(A) |sequence(S) |File formate(F) |Record length® |Limited proce...

原创 IBM Logic file和 Physical file 的异同

The following keywords are valid only for simple and multiple format logical files: PFILE REFACCPTHThe following keywords are valid only for join logical files:JDFTVALJDUPSEQJFILEJFL...

原创 IBM function key &^ datatype

F1 frequently used as a help keyF3 exitF4 prompting a command presemting a screen that showing how to useF5 freshF9 retried previous commandF12 cancel.ptSource code*pgm.rpgleCompiled program...

原创 IBM Iseries Terminology

SLS: single level storageObejecrs are referenced, stored and retrieved by name, without regard to their physical locationDatabase systemBuilt inDb2 USB for i series does not have a data breakage...

原创 IBM DB2 部分指令

WRKSBMJOB work with submitted JoWRKACTJOBWrRKOBJWRKOBJPDMCRTSRCPQ create source physical fileCHGCURDIR: change current directoryDMPDNSJRNF: Dumps dns journal file to human readable formCRTLI...

原创 oracle notes(uc)

Datafile: [.ora/.dbf]Physical exist. Physical storage unit. Stored inside tablespace.A datafile cannot delete, once added into a tablespace. (delete the tablespace who belongs to)Relation:One data...

原创 JAVA Diff between TCP&UDP （UC）

TCP (Transmission control protocol)Connection based protocolProvide reliable flow of data between two computersUDP(User Datagram Protocol)Send independent packets of data(datagram)Send message fr...

原创 JAVAThread Synchronization | 线程的同步 (UC)

同步的好处ThesynchronizationismainlyusedtoPrevent thread interference.Prevent consistency problem.种类TherearetwotypesofsynchronizationProcess Synchronization.Thread Synchronization.Thread...

原创 Algorithm Notes: Red Black Tree | 算法学习 红黑树

Red Black Tree | 红黑树BSTEvery node must have a colour of either red or blackMust maintain 4 colouring rulesEvery node is red of blackRoot node is always blackRed node must have black childrenT...

原创 一个小目标QAQ

这是一个小目flag标Java 系列一共二十五篇树莓派还有六个半cmd 还要挣扎一下oracle完全没动。。。emulator？哦 我都忘了这么一看简直绝望。。。容我挣扎一下吧。。。.....突然想起还有trees和大数据…天要亡我！...

原创 Java socket Client-Servers对话框实现（GUI）

就这么一点东西花了我俩小时。。。嘤！注释晚点补上需要用到eclipse里面的window builder插件（market里面大概率会卡，最后官网URL下载首先我们需要一个GUI panel：package clientserver;public class GUI { static window w; static window2 w2; static server ss;...