Write down a code to add two rows of data to the table that, Ask an Expert

Engineering

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.

View complete question

Computer Engineering, Engineering

Category:- Computer Engineering
Reference No.:- M9208741

Have any Question?Write your Review or question?

Related Questions in Computer Engineering

Question 1 identify all the dfd data flow diagram elements

Question: 1. Identify all the DFD (data flow diagram) elements (Shostack, 2014, p.531.). 2. Identify all threat types to each element(Shostack, 2014, p.531.). 3. Identify threats (three or more), one each for data flow, ...

Give an example of a binary relation which is not

Give an example of a binary relation which is not transitive, and then give an example of a binary relation which is reflexive and transitive but not connected.

Question as you are reviewing the results of your various

Question : As you are reviewing the results of your various scans, what factors do you believe you would take into consideration when determining priority? The priority would be used to determine remediation efforts. So, ...

A is the event that your friend is sick today and b is the

A is the event that your friend is sick today and B is the event that you pass this test. These events are independent and Not mutually exclusive. Calculate the probability that your friend is sick today OR you pass this ...

Using the following dataa sex- 7 males 1 female height-

Using the following data, A.) (Sex)- 7 males, 1 female. (Height)- 72,67,72,64,66,68,68,70. (Left or right handed)- 7 right handed, 1 left handed. Let's assume our class is truly representative of the population at large. ...

30 of the cars in a dealer lot are red 21 are black and 22

30% of the cars in a dealer lot are red, 21% are black, and 22% are white. The remainder are some other unspecified color. Salespersons randomly shows three cars to three different customers. What is the probability the ...

Develop a hypothesis that could explain why a soap created

Develop a hypothesis that could explain why a soap created from the acid CH 3 CH 2 CH 2 CH 2 COOH has poorer cleaning properties than soap made from palmitic acid. Develop a hypothesis that could explain why a soap creat ...

Question 1 where to be careful when using cloud services2

Question: 1. Where to be careful when using cloud services? 2. What are those cloud essential characteristics in "The U.S. NIST Definition of Cloud Computing"? The response must be typed, single spaced, must be in times ...

How to design a java program that reads a sentence say s

How to design a Java program that reads a sentence, say s, consisting of lower-case words with .nextLine() method, identifies the words using .indexOf() and .substring() methods and saves them in String variables. Then t ...

Review the interactive session on pages 50 and 51 in

Review the Interactive Session on pages 50 and 51 in Management Information Systems: Managing the Digital Firm (11th ed.) of your text. It discusses Air Canada. Answer "Case Study Questions" 1 through 3 on page 51. 1. Ho ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Computer Engineering Expert