I 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 12604Name Salary Abc 50000 Abc 50000 xyz 20000 find the max salary using aggregate function?
CTS,
2 10707difference between table level constraint and column level and advantages of table level constraint
4 15769I have 2 packages A and B. Now package A references Package B and Package B references Package A. How do you compile such inter-dependent objects in PL/SQL
5 19541I have a table .in the table 100 recored is there .we have get the single row with out using clause..
3 9416In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join.
GE,
2 5432I have 2 table A and B. In A 1 lakh record is present. In b 20 thousand data is present. To get the unique data from table A and B which join we should prefer left inner join or right outer join. Please answer.
GE,
4 10114if table named a is there and 4 records are there then how to swap (1 and 3) and (2 and 4) records at a time
1 3882. have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement. CUST ACC a dv b fg b bh c mk c cl c so result:- A B c dv fg mk bh cl so
3 6473I Defined SP1, Sp2 (sp=StoreProcedures)In Package Specification but I Implemented Sp1, sp2, sp3, sp4, sp5 then What type of Error You will find????
3 11803
Is join an inner join?
What does pl sql developer do?
What is $$ in sql?
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
Explain ddl statements in pl/sql?
Write the command to remove all players named sachin from the players table.
What is user defined functions?
Why primary key is required?
How to pipe multiline string to isql?
What is cte?
What is Histogram?
Which join is like inner join?
Show the two pl/sql cursor exceptions.
What is error ora-12154: tns:could not resolve the connect identifier specified?
What is database white box testing and black box testing?