Can we convert a date to char in oracle and if so, what would be the syntax?
Answer / Vitesh Kumar
"Yes, you can convert a date to character in Oracle using the TO_CHAR function. Here is an example:nnSELECT TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') FROM dual;"
| Is This Answer Correct ? | 0 Yes | 0 No |
What is a deadlock in SQL? How can you prevent it?
What is coalesce function?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
i have a table with 1 lac of data.i want to insert this data into another table. i want every 5000 of data insert use a commit.using counter and if error is comming in the 5000 of data it rollback.
Define oracle database
What are the ansi data types supported in oracle?
can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ?
Write a syntax for update query in oracle?
Can you drop an index associated with a unique or primary key constraint?
which is best insttute for teradata,sybase,mysql,oracle in hyderabad
Can cursor variables be stored in PL/SQL tables.If yes how. If not why?
How do you ensure database security?