Can we convert a date to char in oracle and if so, what would be the syntax?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Oracle General Interview Questions

Explain 1st, 2nd, 3rd normalization form of data base

3 Answers   KH, Thermotech,


"primary key=unique+null" is equal,reson?not,reason?

5 Answers  


How do we represent comments in oracle?

0 Answers  


What is the difference between formal parameters and actual parameters?

0 Answers  


select * from emp what happened internally when we write this query in the sql prompt?

5 Answers  






Why cursor variables are easier to use than cursors?

0 Answers  


What is different types of joins?

0 Answers  


What is the data pump export utility?

0 Answers  


What is a materialised view?

5 Answers  


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.

1 Answers   MasterCard,


What are the type of Synonyms?

1 Answers  


If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X

2 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)