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
Explain 1st, 2nd, 3rd normalization form of data base
"primary key=unique+null" is equal,reson?not,reason?
How do we represent comments in oracle?
What is the difference between formal parameters and actual parameters?
select * from emp what happened internally when we write this query in the sql prompt?
Why cursor variables are easier to use than cursors?
What is different types of joins?
What is the data pump export utility?
What is a materialised view?
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.
What are the type of Synonyms?
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