What happens if the update subquery returns multiple rows?
How to count duplicated values in a column in oracle?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
How to drop a stored function?
Difference between primary key and unique key ?
77 Answers Accenture, B2B Software Technologies, Cognizant, HP Finsoft, IndiaNIC, Karomi Technology, Keane India Ltd, L&T, Onward eServices, R Systems, Shakti, Techtic Solutions,
Explain a synonym?
What is Trace File ?
We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.
how many triggers we can create on a table
11 Answers G2 Technology, TCS,
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
How to call a trigger inside a stored procedure?Give an example.
How do I call oracle stored procedures that take no parameters?
How to delete a user account in oracle?