what is the difference between to_char and to_date
functions?
Answer Posted / susan
To_char is to convert number or date(string format) to character format.
To_date is from character format to date,only fetches d data when dere s valid number..
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
Is inner join faster than left join?
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
What is rename in sql?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
Can we insert data into view?
what are the advantages of using stored procedures? : Sql dba
what is text? : Sql dba
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
What is rowid in sql?
What is data type in database?
When can we use the where clause and the having clause?
How does cross join work?
What are the advantages of pl sql over sql?
Which command is used to delete a trigger?
How to install oracle sql developer?