oracle 数据库查询 查询1988年出生的学生(tt_student)表,显示学号,姓名,出生年月(注意:此题不能用出生日期字段来计算,用年龄来计算) 怎么写 个位大神们!! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select student_id, name, born_date from tt_studentwhere to_char(sysdate, 'yyyy') - to_char(born_date, 'yyyy') = 30 select student_id, name, born_date from tt_studentwhere to_date(sysdate, 'yyyy') - to_date(born_date, 'yyyy') = 30 楼上的,日期不能用to_date select student_id, name, born_date from tt_studentwhere to_char(sysdate, 'yyyy') - to_char(born_date, 'yyyy') = 30 select student_id, name, born_datefrom tt_studentwhere to_char(sysdate, 'yyyy') - to_char(born_date, 'yyyy') = 30 select student_id, name, born_date from tt_studentwhere to_char(sysdate, 'yyyy') - to_char(born_date, 'yyyy') = 30 select student_id, name, born_date from tt_student where to_char(sysdate, 'yyyy') - to_char(born_date, 'yyyy') = (to_char(sysdate, 'yyyy') - 1998) 如果在不知道是30岁 的情况下呢select student_id, name, born_date from tt_student where to_char(sysdate, 'yyyy') - to_char(born_date, 'yyyy') = (to_char(sysdate, 'yyyy') - 1988) oracle 10g 导出报错问题 触发器语法错误求助 请高手解答下,谢谢了 authorware连接Oracle问题 如何导出一个oracle数据库的所有用户的Sql脚本 如何获取出错的SQL语句?? 关于存储过程的问题高手赐教 登录SQL*PLUS???? 请教高手,挺难的一个题目! 如何最优取最近一条记录 表及表结构完全相同的两个实例数据如何合并为一个 克隆 跑脚本 报ora-17629:ora-01017
from tt_student
where to_char(sysdate, 'yyyy') - to_char(born_date, 'yyyy') = 30
from tt_student
where to_date(sysdate, 'yyyy') - to_date(born_date, 'yyyy') = 30
from tt_student
where to_char(sysdate, 'yyyy') - to_char(born_date, 'yyyy') = 30
from tt_student
where to_char(sysdate, 'yyyy') - to_char(born_date, 'yyyy') = 30
from tt_student
where to_char(sysdate, 'yyyy') - to_char(born_date, 'yyyy') = 30
from tt_student
where to_char(sysdate, 'yyyy') - to_char(born_date, 'yyyy') =
(to_char(sysdate, 'yyyy') - 1998)
select student_id, name, born_date
from tt_student
where to_char(sysdate, 'yyyy') - to_char(born_date, 'yyyy') =
(to_char(sysdate, 'yyyy') - 1988)