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 11457Name Salary Abc 50000 Abc 50000 xyz 20000 find the max salary using aggregate function?
CTS,
2 10063difference between table level constraint and column level and advantages of table level constraint
4 14546I 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 18235I have a table .in the table 100 recored is there .we have get the single row with out using clause..
3 8434In 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 4666I 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 9085if 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 3420. 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 5807I 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 11027
Can I call a procedure inside a function?
what is a control file ? : Sql dba
when is the use of update_statistics command? : Sql dba
Is sql similar to python?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
how to escape special characters in sql statements? : Sql dba
How do you bind variables in pl sql?
tell me about various levels of constraint. : Sql dba
How do I partition a table in sql?
How long it takes to learn pl sql?
What is ttitle and btitle?
What is offset and limit in sql?
Is hadoop a nosql?
What is the requirement of self-join?
Can we create index on primary key?
