Display the number value in Words?
Answer / nishi
select sal, (to_char(to_date(sal,'j'), 'jsp')) from emp;
| Is This Answer Correct ? | 2 Yes | 0 No |
What do you mean by merge in oracle and how can we merge two tables?
How to delete multiple rows from a table in oracle?
How to connect to the server with user account: sys?
What is meant by a deadlock situation?
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
Display the records between two range?
What are the different types of databases?
How to find the duplicate rows count from employees table in oracle?
Explain the use of indexes option in imp command.
Is it possible to insert comments into sql statements return in the data model editor ?
Can we write insert statement in function in oracle?
What is Library Cache in Oracle?