how many outer joins are used in a single sql query? is there any limitations for using of outer joins?
2 9083In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL values so can i add NOT NULL CONSTRAINT on that column......... ok if it is not possible, can i add NOT NULL CONSTRAINT from 101 Record Onwards?
4 8029Do you know about aggregate functions? What is row num function? Can it be used all databases?
1 4445Post New Cap Gemini Oracle General Interview Questions
Oracle Data Integrator Interview Questions and answers?
What is the basic difference in wip calculation in product cost by order and product cost by period (repetitive manufacturing)?
how do you use commitment control in rpg program ?
What is the functional difference between row and column based storage? Where do we use row-based storage and column-based storage?
How to change a string in list ?
what should I refer for examination of BSNL-TTA. Please suggest me good reference...so that I can clear this exam.
Explain are there different threading models that can be used within corba servers?
What is data quality in sap.
What are various ways of hosting wcf services?
Explain microarrays?
What are expert systems in artificial intelligence?
How to Change the default project directory ?
What is basic authentication in web api?
How can a user move the existing db instances outside vpc into the vpc?
Mention what are the data components used by Hadoop?