How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
970Post New Oracle General Questions
How to assign values to data fields in record variables?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
What exactly do quotation marks around the table name do?
Explain the use of inctype option in exp command.
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
How to end the current transaction in oracle?
What privilege is needed for a user to query tables in another schema?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
How to define a procedure inside another procedure?
What is materialized view in Oracle?
What are the built-in functions used for sending Parameters to forms ?
What do you mean by cdb and pdb in oracle 12c?
What is the difference between a hot backup and a cold backup in oracle?
What are the differences between interval year to month and interval day to second?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?