Purchase Solution

SQL Command Code

Not what you're looking for?

Ask Custom Question

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));

1. 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.

Purchase this Solution
Solution Summary

This solution contains step-by-step instructions on how to execute the SQL commands and also additional codes.

Solution Preview

Dear student,

To insert a row into the already created table, you need to use the Insert command.
The structure of the command is usually like this...Insert into TABLENAME values(...,...,...);
In the above statement insert, into and values are the keywords. That means these 3 words will always be used for every insertion operation. The TABLENAME ...

Purchase this Solution
Free BrainMass Quizzes
C++ Operators

This quiz tests a student's knowledge about C++ operators.

Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.

Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

C# variables and classes

This quiz contains questions about C# classes and variables.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

View More Free Quizzes
Related BrainMass Solutions

  • SQL Query: Student Information

    Query6 Write a SQL statement to display the First and Last Name of students who have the major of Biology or Math. Use the SQL command IN.

  • Oracle Sqlplus

    Use the SELECT object_name, original_name FROM recyclebin; command to confirm that the table is not in the recycle bin anymore. B. Constraints: 1. Write an SQL code to create the STUDENT table.

  • PL/SQL package

    If this option is selected, SQL*Menu uses menu command type 5 to invoke SQL*Plus without a new database login and without loading SQL*Plus into memory. Command type 5 invokes SQL*Plus significantly faster then command type 2 or 3.

  • SQL Query Statements

    Use the SQL command IN. Query7 Write a SQL statement to display the First and Last Name of students who have the Status greater than 1 and less than 10. Use the SQL command BETWEEN.

  • simple SQL program demonstrating the use of CREATE FUNCTION command in SQL

    115536 Creating a Function Command in SQL I need a simple SQL program demonstrating the use of CREATE FUNCTION command in SQL. A create table can be used to generate a simple record of items such as name, title, age.

  • Methods that can be used to graphically create SQL queries

    Especially advanced features such as OPENROWSET command to access nonhomogenous data sources, or query hints such as to direct JOIN order or to call for a MERGE JOIN can only be done in the written code.

  • SQL Command to Add MATH SCOPE to the STUDENT Table

    311681 SQL Command to Add MATH SCOPE to the STUDENT Table 1. Write the SQL command to add MATH SCOPE to the STUDENT table. 2. Write the SQL command to add SUBJECT to TUTOR.

  • ACCESS 2000

    To create the customers table use the below SQL code. Copy it into the SQL view of a new query to run it: To get into a query's "SQL view" in Access: 1.

  • Information about ADO.NET

    You can use the command to either .ExecuteNonQuery, which will action an SQL statement (such as a DELETE command) upon the data — or .ExecuteReader, which links straight in to the Data Reader object.

View More Related Solutions