What are the advantages of using VARCHAR2 as the data type for a column that holds...

Question

Question

What are the advantages of using VARCHAR2 as the data type for a column that holds dates?

engineering Computer-Science

Answer 1

Answer #1

It takes less computational task as we dont have any conversions
No Need to worry about the formats of the date type as it is varchar2 it will treat it as string only
We can stores

Answer 2

Similar Homework Help Questions

Name problems that could arise or disadvantages of using VARCHAR2 as the data type for a column that holds dates. What are the advantages of using VARCHAR2 as the data type for a column that holds dat...

Name problems that could arise or disadvantages of using VARCHAR2 as the data type for a column that holds dates. What are the advantages of using VARCHAR2 as the data type for a column that holds dates?
What are the advantages of using a numerical data type for a column that holds telephone...

What are the advantages of using a numerical data type for a column that holds telephone numbers?
Lesson 10Create the DEPARTMENT tables based on the following: Column Name ID Name Data Type Number...

Lesson 10Create the DEPARTMENT tables based on the following: Column Name ID Name Data Type Number Varchar2 Length 7 25 Populate the DEPARTMENT table with data from the DEPT table. Include only columns that you need. Create the EMPLOYEE table based on the following table chart: Column Name ID LAST_NAME FIRST_NAME DEPT_ID Data Type Number Varchar2 Varchar2 Number Length 7 25 25 7 Modify the EMPLOYEE table to allow for longer employee last names. Confirm your modification. Confirm that both the...

What are the advantages and disadvantages of thin-layer chromatography, adsorption column chromatography, and gas chromatography techniques?...

What are the advantages and disadvantages of thin-layer chromatography, adsorption column chromatography, and gas chromatography techniques? (advantages and disadvantages for each type)
Primary vs Archival Data: What are the advantages and disadvantages of using achival vs. primary data?...

Primary vs Archival Data: What are the advantages and disadvantages of using achival vs. primary data? Provide at least 3 advantages and 3 disavantages of using objective survey data (primary) and secondary data.
What are the advantages of using blended cement over Type I ordinary portland cement?

What are the advantages of using blended cement over Type I ordinary portland cement?

Using the following tables write a sql command: List the full name and the total number...

Using the following tables write a sql command: List the full name and the total number of transactions handled by the full time employee. Rank your results in descending order on the total number of transactions. Table: MEMBERS Column Data Type Length Precision Scale Nullable MEMBERID NUMBER 4 0 No MFIRST VARCHAR2 25 No MLAST VARCHAR2 25 No STREET VARCHAR2 64 No CITY VARCHAR2 25 . No STATE VARCHAR2 2 . No ZIPCODE NUMBER 0 No CREDITLIMIT NUMBER 7 2...
What are the advantages and disadvantages of using an Internet site as means of collecting data...

What are the advantages and disadvantages of using an Internet site as means of collecting data for psychological research
Linked list is a type of data structure. Each item of the list holds a data...

Linked list is a type of data structure. Each item of the list holds a data and a pointer to the next item. Head is a pointer that points to the first element. Tail is the last element of the list, which points to "NULL". Linked list can be implemented using structures, consisting of some data types and a pointer. Write a program that creates the linked list given in the following figure and prints out the data in order....

What are the advantages and disadvantages of using crowdsourced social media data during a disaster response?

What are the advantages and disadvantages of using crowdsourced social media data during a disaster response?