Recent use of Oracle notes and a small number of regular expressions

User, table space, table:
A user typically gives a table space, and multiple users can manage a table space together
A table space will have more than one table
For control of permissions:
You can add a table between the people menu table and the file table in the database by making permission settings between the People menu and the files that need to be browsed.
Do a correspondence, according to the personnel to find the files can be browsed. To achieve security rights control.
In spring, AOP-oriented aspect programming can be done with secure control, plus the SPRINGMVC interceptor can achieve fine-grained security control effects.
Database: Uniqueness constraint _alternate key (replace key)

Internal connection: INNER JOIN
Left outer connection: outer JOIN
Right outer connection: outer JOJN
Full outer connection: outer JOIN
Cross join: There is no where statement, similar to two-sheet Cartesian product
Union: Union and union all have different
Intersection: Intersect
Poor: Minus

Select *  from(Select *  fromDm_mat_budgetwhereDept_code_=? andMat_budget_cat_id_=? andYear_=?) M Right outer Join(Select  Level  asMonth_ fromDUAL CONNECT by  Level <=  A) d onM.month_=D.month_Order  byD.month_ASC

-- Show 12 months Select  Level  as  from  by  Level <=  A

--connect the respective condition filter to achieve the requiredSelectO.mat_budget_id_, O.com_code_, O.com_name_, Ob.org_code_ Dept_code_, Ob.org_name_ dept_name_, O.MAT_BUDGET_CAT_ID_, O. Budget_, O.year_, O.month_, O.memo_, O.operator_code_, O.operator_name_, O.last_update_date_ fromomv_org@OMOb Left outer Join(Select *  fromDm_mat_budgetwhereCom_code_=? andMat_budget_cat_id_=? andYear_=? andMonth_ is NULL) O onO.dept_code_=Ob.org_code_whereOb. Parent_org_code_=?

In a multi-table federated display of the business table, when the page drop-down box refers to the data of another table, be aware of the relationship between key and value and the corresponding property of the current table. Most are displayed to the user kanji, not code values.
When fetching the data, use EXT.GETCMP (' Value_ ') when taking the key value of the input box. Getsubmitvalue (). Use EXT.GETCMP (' Value_ ') when taking the display value of the input box. Getrawvalue ().

Using regular expressions: \b matches a word boundary,
I. Definition of boundaries: Usually, a space, the first line of a paragraph, the end of a paragraph, a comma, a period, and other symbols as boundaries, it is worth noting that the delimiter "-" can also be used as a boundary.
Two. The relativity of the boundary: when you set a boundary for an ordinary character, such as "s", its boundary is such as a space, a delimiter, a comma, a period, and so on.
When you set a boundary on a boundary, such as a delimiter "-" or ",", the boundary is the normal character.

Welcome everyone to read, a lot of comments on the shortcomings!!

For the engineer's road to building blocks!!

Recent use of Oracle notes and a small number of regular expressions