SQL>ed Wrote file afiedt.buf 1 ALTER TABLE Emp ADD CONSTRAINT Dept_Dno_FK 2 FOREIGN KEY(Deptno) 3* REFERENCES Dept MODIFY(Deptno NOT NULL) SQL>/ REFERENCES Dept MODIFY(Deptno NOT NULL) * ERROR at line 3: ORA-02268: referenced table does not have a primary key SQL>alter table dept add constraint 2 SQL>ed Wrote file afiedt.buf 1* alter table dept add constraint pk_dno primary key(deptno) 2 / Table altered. SQL>ed Wrote file afiedt.buf 1* insert into o values(9,'priya'). Documents Similar To AdT in SQL. Skip carousel. Carousel previous carousel next. Wrote file afiedt.buf. 1 create table student ( 2 student_name varchar2(100), 3 constraint chk_student_name check ( student. SQL>insert into student values. Fibre Patch Panel Krone. SP2-0110: Cannot create save file 'afiedt.buf'. When i use ed command in sql command prompt a note pad is opening but it was saying 'cannot find the /.sql file'.

The integer data type does not use a length qualifier. Integer is equivalent to number(38,0). SQL>ed Wrote file afiedt.buf 1 create table PUBLISHERS ( 2 NAME varchar2(50) primary key, 3 address varchar2(50), 4 phone integer 5* ) SQL>/ Table created. If you want to limit the size, use a number SQL>ed Wrote file afiedt.buf 1 create table PUBLISHERS ( 2 NAME varchar2(50) primary key, 3 address varchar2(50), 4 phone number(10) 5* ) SQL>/ Table created. Since you are never going to do numeric operations on a phone number, however, while it is generally likely that you will perform string manipulation on it to format phone numbers for display, it would generally make sense to store a phone number as a character string rather than as a number.

You can add a CHECK constraint that ensures the format is correct. SQL>ed Wrote file afiedt.buf 1 create table PUBLISHERS ( 2 NAME varchar2(50) primary key, 3 address varchar2(50), 4 phone varchar2(10) 5* ) SQL>/ Table created. Pro Tools 8 Rock Hard Loops. Flughafenfeuerwehr Simulator 2013 Demo on this page.

Probably You want to insert values from record/variable, not cursor itself!