Oracle decode() 跟序列问题select decode(max(Id),null,(select ids.currval from dual),max(Id)) id from users这样提示此处不允许使用序号 要什么办法才能达到想要的效果呢？

题目
Oracle decode() 跟序列问题

select decode(max(Id),null,(select ids.currval from dual),max(Id)) id from users

这样提示此处不允许使用序号 要什么办法才能达到想要的效果呢？

相似考题

1.Examine the description of the EMPLOYEES table:EMP_ID NUMBER(4) NOT NULLLAST_NAME VARCHAR2(30) NOT NULLFIRST_NAME VARCHAR2(30)DEPT_ID NUMBER(2)JOB_CAT VARCHARD2(30)SALARY NUMBER(8,2)Which statement shows the maximum salary paid in each job category of each department? （）A. SELECT dept_id, job_cat, MAX(salary) FROM employees WHERE salary > MAX (salary);B. SELECT dept_id, job_cat, MAX(salary) FROM employees GROUP BY dept_id,job_cat;C. SELECT dept_id, job_cat, MAX(salary) FROM employees;D. SELECT dept_id, job_cat, MAX(salary) FROM employees GROUP BY dept_id;E. SELECT dept_id, job_cat, MAX(salary) FROM employees GROUP BY dept _ id job _ cat salary;

2.某企业的数据库系统中有如下所示的员工关系和仓库关系，每个仓库可有多名员工，但只有一名负责人。员工关系(employee)：仓库关系(warehouse)：则创建仓库表结构的SQL语句为(58)。A．CREATE TABLE (employee ID CHAR(2)NOTNULL UNIQUE， name CHAR(30)NOT NULL， address CHAR(40)， principal ID CHAR(3))；B．CREATE warehouse(warehouse ID CHAR(2)PRIMARY KEY， name CHAR(30)， address CHAR(40)， principal ID CHAR(3))；C．CREATE TABLE warehouse(warehouse ID CHAR(2)PRIMARY KEY， name CHAR(30)NOT NULL， address CHAR(40)， principal ID CHAR(3)， FOREIGN KEY(principal ID)REFERENCES employee(employee ID))；D．CREATE TABIE warehouse(warehouse ID CHAR(2)， name CHAR(30)NOT NULL， address CHAR(40)， principal ID CHAR(3)， PRIMARY REY(warehouse ID)， FOREIGN KEY(employee ID)REFERENCES employee(employee ID))；

3.在Oracle中,使用下列的语句产生序列:CREATE SEQUENCE id;Oracle服务器会预开辟内存并维持的序列值有()个。A.0B.10C.20D.100

4.Given:11.／／insertcodehere12.&eGiven：11.//insertcodehere12.privateNmin，max；13.publicNgetMin（）{returnmin；}14.publicNgetMax（）{returnmax；}15.publicvoidadd（Nadded）{16.if（min==null||added.doubleValue（）<min.doubleValue（））17.min=added；18.if（max==null||added.doubleValue（）>max.doubleValue（））19.max=added；20.}21.}Whichtwo，insertedatline11，willallowthecodetocompile？（）

更多“Oracle decode() 跟序列问题 selectdecode(max(Id),null,(selectids.currvalfromdual),max(Id))idfromusers这样提示此处不允许使用序号要什么办法才能达到想要的效果呢？”相关问题

  • 第1题：

    Which two of these are used in the selection of a root bridge in a network utilizing Spanning Tree  Protocol IEEE 802.1D？ （）

    • A、Designated Root Cost
    • B、bridge ID priority
    • C、max age
    • D、bridge ID MAC address
    • E、Designated Root Priority
    • F、forward delay

    正确答案:B,D

  • 第2题：

    Which are required initialization parameters in an Oracle Shared Server environment？（）

    • A、DISPATCHERS and SHARED_SERVERS
    • B、DISPATCHERS and MAX_DISPATCHERS
    • C、MAX_DISPATCHERS and MAX_SHARED_SERVERS
    • D、SHARED_SERVER_SESSIONS and DISPATCHERS

    正确答案:A

  • 第3题：

    在3DS MAX中反选的快捷键是：（）

    • A、Ctrl+A
    • B、Ctrl+D
    • C、Ctrl+I
    • D、Ctrl+C

    正确答案:C

  • 第4题：

    for（ int i = min； i 

    • A、 init i = min；while（ i < max ）{}
    • B、 int i = min；     do    system.out.println（i++）；    } while（ i< max ）；
    • C、 for （int i=min； i
    • D、 for （int i=； i++

    正确答案:B

  • 第5题：

    Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) JOB_CAT VARCHAR2(30) SALARY NUMBER(8,2) Which statement shows the department ID, minimum salary, and maximum salary paid in that department, only of the minimum salary is less then 5000 and the maximum salary is more than 15000?（）

    • A、SELECT dept_id, MIN(salary(, MAX(salary) FROM employees WHERE MIN(salary) <5000 AND MAX (salary) > 15000;
    • B、SELECT dept_id, MIN(salary), MAX(salary) FROM employees WHERE MIN(salary) < 5000 AND MAX(salary) > 15000 GROUP BY dept_id;
    • C、SELECT dept_id, MIN(salary), MAX(salary) FROM employees HAVING MIN(salary) <5000 AND MAX (salary) > 15000;
    • D、SELECT dept_id, MIN(salary), MAX(salary) FROM employees GROUP BY dept_id HAVING MIN (salary) < 5000 AND MAX(salary)
    • E、SELECT dept_id, MIN(salary), MAX(salary) FROM employees GROUP BY dept_id, salary HAVING MIN (salary) <5000 AND MAX (salary) > 15000;

    正确答案:D

  • 第6题：

    Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) DEPARTMENT_ID NUMBER SALARY NUMBER What is the correct syntax for an inline view? （）

    • A、SELECT a.last_name, a.salary, a.department_id, b.maxsal FROM employees a, (SELECT department_id, max(salary)maxsal FROM employees GROUP BY department_id) b WHERE a.department_id = b.department_id AND a.salary < b.maxsal;
    • B、SELECT a.last name, a.salary, a.department_id FROM employees a WHERE a.department_id IN (SELECT department_id FROM employees b GROUP BY department_id having salary = (SELECT max(salary) from employees))
    • C、SELECT a.last_name, a.salary, a.department_id FROM employees a WHERE a.salary = (SELECT max(salary) FROM employees b WHERE a.department _ id = b.department _ id);
    • D、SELECT a.last_name, a.salary, a.department_id FROM employees a WHERE (a.department_id, a.salary) IN (SELECT department_id, a.salary) IN (SELECT department_id max(salary) FROM employees b GROUP BY department_id ORDER BY department _ id);

    正确答案:A

  • 第7题：

    Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) JOB_CAT VARCHARD2(30) SALARY NUMBER(8,2) Which statement shows the maximum salary paid in each job category of each department?（）

    • A、SELECT dept_id, job_cat, MAX(salary) FROM employees WHERE salary > MAX (salary);
    • B、SELECT dept_id, job_cat, MAX(salary) FROM employees GROUP BY dept_id,job_cat;
    • C、SELECT dept_id, job_cat, MAX(salary) FROM employees;
    • D、SELECT dept_id, job_cat, MAX(salary) FROM employees GROUP BY dept_id;
    • E、SELECT dept_id, job_cat, MAX(salary) FROM employees GROUP BY dept _ id job _ cat salary;

    正确答案:B

  • 第8题：

    The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) Which statement finds the highest grade point average (GPA) per semester?（）

    • A、SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL;
    • B、SELECT (gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL;
    • C、SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL GROUP BY semester_end;
    • D、SELECT MAX(gpa) GROUP BY semester_end WHERE gpa IS NOT NULL FROM student_grades;
    • E、SELECT MAX(gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL;

    正确答案:C

  • 第9题：

    Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL EMP_NAME VARCHAR2(30) JOB_ID VARCHAR2(20) DEFAULT 'SA_REP' SAL NUMBER COMM_PCT NUMBER MGR_ID NUMBER DEPARTMENT_ID NUMBER You need to update the records of employees 103 and 115. The UPDATE statement you specify should update the rows with the values specified below: JOB_ID: Default value specified for this column definition. SAL: Maximum salary earned for the job ID SA_REP. COMM_PCT: Default value specified for this commission percentage column, if any. If no default value is specified for the column, the value should be NULL. DEPARTMENT_ID: Supplied by the user during run time through substitution variable. Which UPDATE statement meets the requirements?（）

    • A、UPDATE employees SET job_id = DEFAULT AND Sal = (SELECT MAX(sal) FROM employees WHERE job_id = 'SA_REP') AND comm_pct = DEFAULT AND department_id = &did WHERE employee _id IN (103,115);
    • B、UPDATE employees SET job_id = DEFAULT AND Sal = MAX(sal) AND comm_pct = DEFAULT OR NULL AND department_id = &did WHERE employee_id IN (103,115) AND job _ id = 'SA_ REP';
    • C、UPDATE employees SET job_id = DEFAULT, Sal = (SELECT MAX(sal) FROM employees WHERE job_id = 'SA_REP'), comm_pct = DEFAULT, department_id = &did WHERE employee_id IN (103,115);
    • D、UPDATE employees SET job_id = DEFAULT, Sal = MAX(sal), comm_pct = DEFAULT, department_id = &did WHERE employee_id IN (103,115) AND job _ id = 'SA_ REP';
    • E、UPDATE employees SET job_id = DEFAULT, Sal = (SELECT MAX(sal) FROM employees WHERE job_id = 'SA_REP') comm_pct = DEFAULT OR NULL, department_id = &did WHERE employee_id IN (103,115);

    正确答案:C

  • 第10题：

    单选题
    Which built-in returns a BOOLEAN value that indicated whether an objects internal ID is available?（）
    A

    GET_ID 

    B

    ID_NULL 

    C

    ID_FIND 

    D

    FIND_ID


    正确答案： A
    解析： 暂无解析

  • 第11题：

    单选题
    在Oracle中，使用下列的语句产生序列： CREATE SEQUENCE id； Oracle服务器会预开辟内存并维持的序列值有（）个。
    A

    0

    B

    10

    C

    20

    D

    100


    正确答案： A
    解析： 暂无解析

  • 第12题：

    单选题
    Examine the structure of the EMPLOYEES, DEPARTMENTS, and TAX tables. EMPLOYEES NOT NULL, Primary EMPLOYEE_ID NUMBER Key VARCHAR2 EMP_NAME (30) VARCHAR2 JOB_ID (20) SALARY NUMBER References MGR_ID NUMBER EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table DEPARTMENTS NOT NULL, DEPARTMENT_ID NUMBER Primary Key VARCHAR2 DEPARTMENT_NAME |30| References MGR_ID column MGR_ID NUMBER of the EMPLOYEES table TAX MIN_SALARY NUMBER MAX_SALARY NUMBER TAX_PERCENT NUMBER For which situation would you use a nonequijoin query?（）
    A

    To find the tax percentage for each of the employees.

    B

    To list the name, job id, and manager name for all the employees.

    C

    To find the name, salary, and department name of employees who are not working with Smith.

    D

    To find the number of employees working for the Administrative department and earning less then 4000.

    E

    To display name, salary, manager ID, and department name of all the employees, even if the employees do not have a department ID assigned.


    正确答案： C
    解析： 暂无解析

  • 第13题：

    Which two of these are used in the selection of a root bridge in a network utilizing Spanning Tree ProtocolIEEE 802.1 D？（）

    • A、Designated Root Cost
    • B、bridge ID priority
    • C、max age
    • D、bridge ID MAC address
    • E、Designated Root Priority
    • F、forward delay

    正确答案:B,D

  • 第14题：

    在3DS MAX中，设置视口背景的快捷键是（）

    • A、Ctrl+Z
    • B、Alt+A
    • C、Ctrl+I
    • D、Alt+B

    正确答案:D

  • 第15题：

    Atoll LTE模块支持哪几种调度算法（）

    • A、Proportional Fair
    • B、Proportional Demand
    • C、Max C/I
    • D、Fair Round Robin

    正确答案:A,B,C

  • 第16题：

    在Oracle中，使用下列的语句产生序列： CREATE SEQUENCE id； Oracle服务器会预开辟内存并维持的序列值有（）个。

    • A、0
    • B、10
    • C、20
    • D、100

    正确答案:C

  • 第17题：

    Examine the structures of the EMPLOYEES and TAX tables. EMPLOYEES EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2 (30) JOB_ID VARCHAR2 (20) SALARY NUMBER References MGR_ID NUMBER EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT _ID column of the DEPARTMENT table TAX MIN_SALARY NUMBER MAX_SALARY NUMBER TAX_PERCENT NUMBER Percentage tax for given salary range You need to find the percentage tax applicable for each employee. Which SQL statement would you use?（）

    • A、SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE e.salary BETWEEN t.min _ salary AND t.max_salary
    • B、SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE e.salary > t.min_salary, tax_percent
    • C、SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE MIN(e.salary) = t.min_salary AND MAX(e.salary) = t.max_salary
    • D、You cannot find the information because there is no common column between the two tables.

    正确答案:A

  • 第18题：

    Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL EMP_NAME VARCHAR2(30) JOB_ID VARCHAR2(20) DEFAULT 'SA_REP' SAL NUMBER COMM_PCT NUMBER MGR_ID NUMBER DEPARTMENT_ID NUMBER You need to update the records of employees 103 and 115. The UPDATE statement you specify should update the rows with the values specified below: JOB_ID: Default value specified for this column definition. SAL: Maximum salary earned for the job ID SA_REP. COMM_PCT: Default value specified for this commission percentage column, if any. If no default value is specified for the column, the value should be NULL. DEPARTMENT_ID: Supplied by the user during run time through substitution variable. Which UPDATE statement meets the requirements?（）

    • A、UPDATE employees SET job_id = DEFAULT AND Sal = (SELECT MAX(sal) FROM employees WHERE job_id = 'SA_REP') AND comm_pct = DEFAULT AND department_id = &did WHERE employee_id IN (103,115);
    • B、UPDATE employees SET job_id = DEFAULT AND Sal = MAX(sal) AND comm_pct = DEFAULT OR NULL AND department_id = &did WHERE employee_id IN (103,115) AND job_id = 'SA_REP';
    • C、UPDATE employeesC.UPDATE employees SET job_id = DEFAULT, Sal = (SELECT MAX(sal) FROM employees WHERE job_id = 'SA_REP'), comm_pct = DEFAULT, department_id = &did WHERE employee_id IN (103,115);
    • D、UPDATE employeesD.UPDATE employees SET job_id = DEFAULT, Sal = MAX(sal), comm_pct = DEFAULT, department_id = &did WHERE employee_id IN (103,115) AND job_id = 'SA_REP';
    • E、UPDATE employees SET job_id = DEFAULT, Sal = (SELECT MAX(sal) FROM employees WHERE job_id = 'SA_REP'), comm_pct = DEFAULT OR NULL, department_id = &did WHERE employee_id IN (103,115);

    正确答案:C

  • 第19题：

    Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL EMP_NAME VARCHAR2(30) JOB_ID VARCHAR2(20) SAL NUMBER MGR_ID NUMBER DEPARTMENT_ID NUMBER You want to create a SQL script file that contains an INSERT statement. When the script is run, the INSERT statement should insert a row with the specified values into the EMPLOYEES table. The INSERT statement should pass values to the table columns as specified below: EMPLOYEE_ID: Next value from the sequence EMP_ID_SEQ EMP_NAME and JOB_ID: As specified by the user during run time, throughsubstitution variables SAL: 2000 MGR_ID: No value DEPARTMENT_ID: Supplied by the user during run time through substitution variable. The INSERT statement should fail if the user supplies a value other than 20 or 50. Which INSERT statement meets the above requirements?（）

    • A、INSERT INTO employees VALUES (emp_id_seq.NEXTVAL, '&ename', '&jobid', 2000, NULL, &did);
    • B、INSERT INTO employees VALUES (emp_id_seq.NEXTVAL, '&ename', '&jobid', 2000, NULL, &did IN (20,50));
    • C、INSERT INTO (SELECT * FROM employees WHERE department_id IN (20,50)) VALUES (emp_id_seq.NEXTVAL, '&ename', '&jobid', 2000, NULL, &did);
    • D、INSERT INTO (SELECT * FROM employees WHERE department_id IN (20,50) WITH CHECK OPTION) VALUES (emp_id_seq.NEXTVAL, '&ename', '&jobid', 2000, NULL, &did);
    • E、INSERT INTO (SELECT * FROM employees WHERE (department_id = 20 AND department_id = 50) WITH CHECK OPTION ) VALUES (emp_id_seq.NEXTVAL, '&ename', '&jobid', 2000, NULL, &did);

    正确答案:D

  • 第20题：

    The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) Which statement finds the highest grade point average (GPA) per semester?（）

    • A、SELECT MAX (gpa) FROM student _ grades WHERE gpa IS NOT NULL;
    • B、SELECT (gpa) FROM student _ grades GROUP BY semester_end WHERE gpa IS NOT NULL;
    • C、SELECT MAX (gpa) FROM student _ grades WHERE gpa IS NOT NULL GROUP BY semester_end;
    • D、SELECT MAX (gpa) GROUP BY semester_end WHERE gpa IS NOT NULL FROM student _ grades;
    • E、SELECT MAX (gpa) FROM student _ grades GROUP BY semester_end WHERE gpa IS NOT NULL;

    正确答案:C

  • 第21题：

    Which built-in returns a BOOLEAN value that indicated whether an objects internal ID is available?（）

    • A、GET_ID 
    • B、ID_NULL 
    • C、ID_FIND 
    • D、FIND_ID

    正确答案:B

  • 第22题：

    单选题
    Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_ NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) JOB_CAT VARCHAR2(30) SALARY NUMBER(8,2) Which statement shows the department ID, minimum salary, and maximum salary paid in that department, only if the minimum salary is less than 5000 and maximum salary is more than 15000?（）
    A

    SELECT dept_id, MIN(salary), MAX(salary) FROM employees WHERE MIN(salary) < 5000 AND MAX(salary) > 15000;

    B

    SELECT dept_id, MIN(salary), MAX(salary) FROM employees WHERE MIN(salary) < 5000 AND MAX(salary) > 15000 GROUP BY dept_id;

    C

    SELECT dept_id, MIN(salary), MAX(salary) FROM employees HAVING MIN(salary) < 5000 AND MAX(salary) > 15000;

    D

    SELECT dept_id, MIN(salary), MAX(salary) FROM employees GROUP BY dept_id HAVING MIN(salary) < 5000 AND MAX(salary) > 15000;

    E

    SELECT dept_id, MIN(salary), MAX(salary) FROM employees GROUP BY dept_id, salary HAVING MIN(salary) < 5000 AND MAX(salary) > 15000;


    正确答案： E
    解析： 暂无解析

  • 第23题：

    单选题
    for（ int i = min； i 
    A

     init i = min；while（ i < max ）{}

    B

     int i = min；     do    system.out.println（i++）；    } while（ i< max ）；

    C

     for （int i=min； i

    D

     for （int i=； i++


    正确答案： A
    解析： 暂无解析

相关内容