Tag:staff

  • The father of XML leaves the company angrily because of dissatisfaction with Amazon’s measures to prevent and control the epidemic

    Time:2020-5-28

    Technical editor: Zong en from sifou newoffice SegmentFault has he reported the official account number: SegmentFault After 5 years and 5 months of Amazon’s happy work, the father of XML, vice president of Amazon, senior engineerTim BrayBecause Amazon left the company angrily due to its ineffective measures to prevent and control the epidemic. Tim Bray […]

  • Oracle to pay for workplace discrimination, 4100 female employees class action

    Time:2020-5-26

    On Thursday, the California High Court approved a historic Class Action Lawsuit: three female employees of Oracle, representing 4100 other female employees, will sue Oracle for employment discrimination in which female employees are paid less than male employees. On April 30, 2020, the high court of California approved a class action lawsuit. Allow Rong Jewitt, […]

  • 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”, […]

  • Oracle foundation – simple query exercise (2)

    Time:2020-5-21

    Practice based on the employees table of HR user in Oracle Database HR needs to be paid more than $12000 a month (last_ Name) and salary report, please complete the query statement select last_name, salary from employees where salary >12000; HR needs to identify high-income and low-income employee groups. Please show the name and salary […]

  • Database SQL query

    Time:2020-5-21

    1. Query all columns Select * from EMP; — * indicates all, and from EMP indicates query from EMP table. 2. Query specified column       select empno,ename from emp;Select 888 from EMP; — OK, the number of rows output is the number of rows in the EMP table, each row has only one […]

  • Oracle foundation – single line function exercise (1)

    Time:2020-5-16

    Oracle foundation – single line function exercise (1) Practice based on EMP table under Scott user in Oracle Database Query all employee information in department 30 select * from emp where deptno=30; List the names, numbers and department numbers of all clerks select ename,empno,deptno from emp where job=’CLERK’; Find out the information of employees whose […]

  • Oracle foundation – single line function exercise (2)

    Time:2020-5-15

    Oracle foundation – single line function exercise (2) Practice based on the employment table of HR user in Oracle Database Query system current date select sysdate from dual; Please check each employee’s name, salary and salary after 15.5% increase (TRUNC rounding) Select last_name,salary,trunc(salary*1.155) “new salary” from employees; Displays the employee’s name, original salary, and increased […]

  • The first day of K project anecdote

    Time:2020-5-15

    The first day of K project anecdote   Today is the first day of K project registration and the first day of work after the Spring Festival in 2020! Due to the impact of the pneumonia epidemic, I had a rest for nearly two months. Today, I can return to work smoothly. It’s really not […]

  • Oracle database Part 4

    Time:2020-5-3

    /* Grant permission to user Authorization can grant multiple permissions grant connect,resource to baidu Revoke permission revoke permission from user revoke dba from baidu Create user assigned tablespace — specify the user’s default tablespace Create table P (..) there is a default table space for table creation –Specify table space when creating a table Create […]

  • Advanced MySQL operation

    Time:2020-4-22

    #Part1 single table query#The complete syntax of SQL query statement”’ select .. from .. where .. group by .. having .. order by .. limit .. ”’ #1、 Use of where conditions“” “function: filter the data in the table” “” “””Syntax:1. Symbols of judgment:=Not equal to2. Key words of splicing conditions and or not3. Query […]

  • Sub query of MySQL

    Time:2020-4-19

    Meaning:The select statement appearing in other statements is called sub query or internal query, and the external query statement is called main query or external query. Classification:By subquery location: After select: Only scalar subqueries are supported Behind from Support table subquery Behind where or having scalar subquery Column query Row subquery After exists (related subqueries) […]

  • Oracle Foundation

    Time:2020-4-1

    Oracle am.2019/10/22 C:\app\Administrator\product C:\app\Administrator\oradata C:\app\Administrator\oradata\orcl20. CTL control document20. DBF data file20. Log log file JDK path C:\app\Administrator\product\11.1.0\db_1\jdk\bin Default storage path of database file C:\app\Administrator\product\11.1.0\db_1\database (mysql -u root -p)CMD DOS command line executionSqlplus user name / password sqlplus system/123 Connect to Oracle serverConn username / password as connection identity @ server connection string –Create tablespaceCreate tablespace […]