one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows in the table permanently and i want output in the above formatow should u write query?
13 19559Interchange the value of a column Gender in a table where values are Male and Female. So, where the value is Male, it should changed to Female and Female to Male.
4 17716What will be the output of this Query? select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual
6 17600I have a tablle like this. cust acc --------------- a 1 b 2|3 c 4|5|6 I Want below o/p: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 Please any one can you have any ideas share me. I have urgent requirement.
4 10499Post New Cap Gemini SQL PLSQL Interview Questions
What is concatenation and when should it be used?
How do I add more rows in excel?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
Explain the difference between singleton and prototype bean in spring?
What is the function of chain reordering?
What is the business purpose of field authorization object in equipment master and functional location master?
What do you mean by deployer in splunk?
What is difference between class and abstract class in c#?
What is sandbox solution?
What is Babel in React js?
How does maven look for a dependency or resource?
Define alv programming in abap?
Explain the available thread states in a high-level?
What are the types of excitation system?
What is meant by authorization? Did you ever work on it? : sap abap hr