Top Posters
Since Sunday
e
5
e
4
4
d
4
R
4
o
3
p
3
t
3
3
m
3
p
3
m
3
Home Q & A Board Science-Related Homework Help Computer Studies
New Topic  
Heff Heff
wrote...
Go to Answer
Posts: 1330
Rep: 3 0
6 years ago
If T3 is a table with three columns C1, C2 and C3, where C1 is integer data, C2 is character data, and C3 is date data, which of the following would be the proper statement to have Oracle Database enter the date 02/10/14 into a row in table T3 while making sure that it is formatted correctly as shown?
A) SET INTO T3 VALUES (101, 'Smith', '02/10/14');
B) SET INTO T3 VALUES (101, 'Smith', TO_DATE ('02/10/14', 'DD/MM/YY'));
C) INSERT INTO T3 VALUES (101, 'Smith', '02/10/2014');
D) INSERT INTO T3 VALUES (101, 'Smith', TO_DATE ('02/10/14', 'DD/MM/YY'));
E) Any of the above will work correctly.
Textbook 
Database Concepts

Database Concepts


Edition: 7th
Authors:
Read 106 times
2 Replies
Replies
Answer verified by a subject expert
ade9jaade9ja
wrote...
#1
Top Poster
Posts: 690
Rep: 4 0
6 years ago
Sign in or Sign up in seconds to unlock everything for free
More solutions for this book are available here
1

Related Topics

Heff Author
wrote...
#2
5 years ago
This board has been a life saver!
New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  969 People Browsing
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Live Chat
Related Images
  
 315
  
 341
  
 946
Your Opinion
What's your favorite math subject?
Votes: 314
Previous poll results: Should Ph.D.'s be addressed as doctors?