In lesson 8 I learned how to insert a row in a table. In inserting a null values you can use a two method the IMPLICIT and EXPLICIT. In Implicit method you should omit the column from the column list and the Explicit method you should specify the NULL values clause.
I also learned to copy a record from a table using a WHERE clause. And in this chapter I already know the uses of UPDATE, DELETE STATEMENT, TRUNCATE STATEMENT, COMMIT, ROLLBACK, and SAVE POINT.
In lesson 9 I learned how to use DDL statement to create and manage a table. And if your default date type is SYSDATE you will get the system date of your computer that you are using. And I learned how to delete a table permanently by using DROP statement.
In lesson10 I learned how to view a data. And I know that in this lesson that you can use view to retrieve a data.
No comments:
Post a Comment