codd 7th

codd 7th - Codds Seventh Rule Swapnil Ishitha Sree Kanth...

Info iconThis preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
07/15/11 AST JUNE 2004 1 Codd’s Seventh Rule Swapnil Ishitha Sree Kanth Ravi Kanth Swapna Sri Devi
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
07/15/11 AST JUNE 2004 2 DEFINITON “High-level insert, update and delete” The capability of handling a base relation or a derived relation as a single operand applies not only to the retrieval of data but also to the insertion, update and deletion of data.
Background image of page 2
07/15/11 AST JUNE 2004 3 Contd…. Multiple rows and multiple tables Rows are treated as a SET’s SET operations UNION INTERSECTION JOIN
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
07/15/11 AST JUNE 2004 4 CODE FOR IMPLEMENTING SET OPERATIONS IN Java
Background image of page 4
07/15/11 AST JUNE 2004 5 INSERT INSERT INTO tablename (column1,column2…,colunmN) VALUES( exp1,exp2,…. .,expN); INSERT INTO tab1 (col1,col2….coln) Select col1,col2…coln from tab2 [condition];
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
07/15/11 AST JUNE 2004 6 Contd…. INSERT INTO emp VALUES(7566,’TIGER’,’ANALYST’,7233, 2000,500,’26-JUL-04’,40); INSERT EMPNO ENAME JOB MGR SAL COMM HIREDATE DEPTNO 7566 TIGER ANALYST 7233 2000 500 26-JUL-04 40
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 15

codd 7th - Codds Seventh Rule Swapnil Ishitha Sree Kanth...

This preview shows document pages 1 - 7. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online