create table dept(
dept_no varchar2(15),
dept_name varchar2(30),
loc varchar2(30))
Table created.
insert into dept values ('10','president's','washington d.c')
ORA-00917: missing commaMore Details: https://docs.oracle.com/error-help/db/ora-00917
DECLARE
l_sql VARCHAR2(32767);
BEGIN
l_sql := 'INSERT INTO DEPT VALUES (';
L_sql := l_sql || '''50''';
l_sql := l_sql ||', ''president''s'', ''washington d.c'')';
dbms_output.put_line(l_sql);
EXECUTE IMMEDIATE l_sql;
END;
ORA-00917: missing comma ORA-06512: at line 8 ORA-06512: at "SYS.DBMS_SQL", line 1721More Details: https://docs.oracle.com/error-help/db/ora-00917
select * from v$version
BANNER | CON_ID | Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production | 0 | PL/SQL Release 12.2.0.1.0 - Production | 0 | CORE 12.2.0.1.0 Production | 0 | TNS for Linux: Version 12.2.0.1.0 - Production | 0 | NLSRTL Version 12.2.0.1.0 - Production | 0 |
---|