Tag:Employee

  • Oracle Basics – simple query exercise (1)

    Time:2020-9-27

    Practice based on the EMP table under Scott user in Oracle database Query all tables under Scott user select * from tabs; Query all information in employee table select * from emp; Query employee number, name, job, salary. select empno,ename,job,sal from emp; Check the type of employee’s job. select distinct job from emp; Query employee […]

  • An example of converting a list into a map by custom grouping rules using java stream API

    Time:2020-9-13

    The complete test code is shown at the end of this paper. The test data is the four employee object instances in the list: Group by city of employees: The results were divided into three groups The first group of employees in Shanghai: The second group of employees in Chengdu: Count the number of employees […]

  • C ා MVC implementation configures roles for employees (full details + database)

    Time:2020-8-17

    databaseestablishUser table role table user role relationship table create table roles ( RId int identity, RName varchar(50), Remark varchar(50) ) create table UserRole ( Users_UId int, roles_Rid int ) create table Users ( UId int identity, UName varchar(50), UPwd varchar(50) ) The database creates a view view create view USER_SHOW AS select RName,RId,UName,UId from Users […]

  • [pl / SQL] basic exercises 1-8 (1)

    Time:2020-8-12

    1. Query the information of the employee whose third letter of ename is a (using two methods). analysis:Either fuzzy query, or accurately locate the location and then judge SELECT * FROM EMP WHERE ENAME LIKE ‘__A%’; SELECT * FROM EMP WHERE SUBSTR(ENAME,3,1) = ‘A’; 2. Inquire how many months the employees of department 10 and […]

  • Beginners to learn basic JSP syntax of HTML — Introduction (2)

    Time:2020-6-16

    JSP basic syntax JSP comments comment.jsp @ page language=”java” contentType=”text/html; charset=UTF-8″ pageEncoding=”UTF-8″%> Insert title here –Comment in JSP, client cannot see –% > //Single line comment in Java, client can’t see it /* Multiline comment in Java, client can’t see it */ %> View Code Scriptlet scriptlet_demo01.jsp @ page language=”java” contentType=”text/html; charset=UTF-8″ pageEncoding=”UTF-8″%> Insert title […]

  • Oracle foundation – query statement (1)

    Time:2020-5-25

    Oracle foundation – query statement (1) Syntax of query statement SELECT \* |{\[DISTINCT\] column|expression \[alias\], … } ​ FROM table ​ WHERE conditions ​ GROUP BY ​ ORDER BY column \[ASC | DESC\]; Tips: Case insensitive Can be written in multiple lines Keywords cannot be abbreviated or across multiple lines Usually each clause takes one […]

  • Oracle foundation – simple query exercise (1)

    Time:2020-5-22

    Practice based on EMP table under Scott user in Oracle Database Query all tables under Scott user select * from tabs; Query all information in employee table select * from emp; Query employee number, name, job, salary. select empno,ename,job,sal from emp; Query employee number, name, job, salary, list title in Chinese. Select empno “employee number”, […]

  • SQL Server Query (select, where, distinct, like query, in, is null, group by and having, order by, as)

    Time:2020-2-7

    Basic query: Example table Example table create table dept( deptno int primary key, dname nvarchar(30), loc nvarchar(30) ); create table emp( empno int primary key, ename nvarchar(30), job nvarchar(30), mrg int, hiredate datetime, sal numeric(10,2), comm numeric(10,2), deptno int foreign key references dept(deptno) ); insert into dept values (10,’ACCOUNTING’,’NEW YORK’); insert into dept values (20,’RESEARCH’,’DALLAS’); […]

  • Four simple queries of Oracle Database

    Time:2019-10-30

    IV. simple query The main feature of simple query is to display all data rows in a data table, and then use Select clause to control the required output columns. 4.1 basic grammar Example: query data in EMP table (all data query) SELECT * FROM emp; After getting all the data, you can find that […]

  • Six single line functions of Oracle Database

    Time:2019-10-20

    Vi. single line function 6.1 Understanding single line function The function is the same as the function of the method in Java language, which is to complete the function support of some specific operations, and there are a large number of single line functions in Oracle database. After mastering these functions, they can facilitate the […]

  • Oracle Database Seventh Multi-table Query

    Time:2019-10-13

    7. Multi-table query For queries, we have learned simple queries, limited queries and query ranking before, which belong to the standard statements of SQL. The main function of the single-line function in the previous chapter is to make up for the deficiencies of queries. From the beginning of multi-table query, it has formally entered the […]