Write the SQL statement with the TO_CHART function

SELECT TO_CHAR (SYSDATE,'YYYY') from books;




2.     Write the SQL statement with the TO_NUMBER function.




3.     Write the SQL statement with the TO_DATE function.




4.     Write the SQL statement that integrates an implicit character to Date Conversion.







5.     Write the SQL statemen to convert Numbers to Characters using the TO_CHAR function.







6.     Write the SQL statement to convert Dates to Characters using the TO_CHAR function.




7.     Write the SQL statement to convert Characters to Dates using the TO_DATE function.




8.     Write the SQL statement to converting Characters to Numbers using the TO_NUMBER function.




9.     Write the SQL statement using a Nested Function.




10. Write the SQL statement using the NVL function.