我真的只需要SQL查询中表的列数,但不知何故,我无法获得正确的结果。有人知道我做错了什么吗? select count(*) from user_tab_columns where table_name='tablename' //works and gives me the number of columns
TABLE_NAME, (select count(*) from user_tab_columns where table_name=TABLE_NAME) as Test
from user_tab
我创建了一个叫做"view_employee“的视图,如下所示:SELECT employee.surname || ', ' || employee.name AS comp_name, employee.sex, sections.name AS section_name, employee_age我想使用视图将数据插入到表中,如下所示:
INSERT INTO vie