sql语句Oracle.docxVIP

SQL(结构化查询语言)语句-查询、增删改】事务处理、建立/删除各种结构（以表为主）、授权语句（DBA）select id,first_name,salary from s_empselect last_name,title,start_date from s_empselect id,first_name,salary*12 from s_empselect id,first_name,salary*12 income from s_empselect id,first_name|| ||last_name name from s_empselect id,first_name|| ||last_name emp name from s_empnumber varchar2 date算术运算如果有空值参与，结果是空值；文本型的有空值参与，效果等价于‘’。select id,first_name,salary,commission_pct from s_empselect id,first_name,salary*(1+commission_pct/100) incomefrom s_emp;函数nvl（）专门用于处理空值nvl（可能为空值的字段或表达式，如果为空替换值）select id,first_name,salary*(1+nvl(commission_pct,0)/100