tag:blogger.com,1999:blog-7692908296639028212.post3621002887214594725..comments2022-04-11T19:59:33.004-07:00Comments on MSSQLDeveloperSaran: Emp and Dept table script for SQL Server Unknownnoreply@blogger.comBlogger2125tag:blogger.com,1999:blog-7692908296639028212.post-69868199361904790062020-08-28T22:46:17.862-07:002020-08-28T22:46:17.862-07:00SQL> ED
Wrote file afiedt.buf
1 CREATE TABL...SQL> ED<br />Wrote file afiedt.buf<br /><br /> 1 CREATE TABLE EMP<br /> 2 (EMPNO INT PRIMARY KEY,<br /> 3 ENAME VARCHAR(20),<br /> 4 JOB VARCHAR(20),<br /> 5 MGR INT,<br /> 6 HIREDATE DATE,<br /> 7 SAL MONEY,<br /> 8 COMM MONEY,<br /> 9* DEPTNO INT FOREIGN KEY REFERENCES DEPT(DEPTNO) )<br />SQL> /<br />DEPTNO INT FOREIGN KEY REFERENCES DEPT(DEPTNO) )<br /> *<br />ERROR at line 9:<br />ORA-00907: missing right parenthesisAmit Kumarhttps://www.blogger.com/profile/14332919434999546762noreply@blogger.comtag:blogger.com,1999:blog-7692908296639028212.post-10662764197674211802016-04-21T01:41:07.815-07:002016-04-21T01:41:07.815-07:00Thank you very muchThank you very muchcupid royethttps://www.blogger.com/profile/17015536275633326622noreply@blogger.com