Note down a code to add two rows of data to the table

Assignment Help Computer Engineering

Reference no: EM1333371

CREATE TABLE contacts
(Con_id NUMBER(4),
Company_name VARCHAR2(30) not null,
E_mail VARCHAR2(30),
Last_date DATE DEFAULT SYSDATE,
Con_cnt NUMBER(3) CHECK (Con_cnt > 0),
PRIMARY KEY (Con_id));

Write a code to add two rows of data to the table that was created using the command above. Ensure the default option on the LAST_DATE column is used in the second row added. Also, issue a command to permanently save the data to the table.

Reference no: EM1333371

Questions Cloud

Developmental theory in action : Using the developmental theory/model as the most effective change theory/model for the home schooling family and life in the large family.

Maintaining an annotated bibliography : Discuss briefly the advantages and disadvantages of maintaining an annotated bibliography of research data.

Alternative to achieve net income objective : Determine which alternative Almo should select to achieve its net income objective. Show your calculations.

Civil rights movement : How the civil rights movement has contributed to anti-discrimination efforts and the establishment of hate crime legislation and policy.

Note down a code to add two rows of data to the table : Write down a code to add two rows of data to the table that was created using the command above. Ensure the default option on the LAST_DATE column is used in the second row added. Also, issue a command to permanently save the data to the table.

Factors which affecting portfolio returns : As a manager of a large, broadly diversified portfolio of stocks and bonds you realized that changes in certain microeconomic variables might directly affect the performance of your portfolio.

Review of the literature : During your review of the literature, you find that many others have studied your topic, will this tend to bolster your confidence that your topic is worth studying?

Triangular arbitrage profit : Suppose you're a trader with Deutsche Bank. From the quote screen on your computer terminal, you notice that Dresdner Bank is quoting ?0.7627/$1.00 and Credit Suisse is offering SF1.1806/$1.00.

Computing monthly breakeven sales : Determine the monthly breakeven sales in dollars before adding nachos.

User Account

All Pages