Give syntax for SQL and ORACLE joins.
No Answer is Posted For this Question
Be the First to Post Answer
Why we choose emp number as primarykey?
What is the difference between translate and replace?
select trunc(round(156.00,-1),-1) from dual;
What are joins, explain all types of joins?
What is oracle instant client?
We need to compare two successive records of a table based on a field. For example, if the table is CUSTOMER, and the filed is Account_ID, To compare Account_IDs of record1 and record2 of CUSTOMER table, what can be the query ?
How to install oracle odbc drivers?
what are actual and formal parameters?
How do we know whether an index is created on a table ???
What are the Referential actions supported by FOREIGN KEY integrity constraint ?
What is meant by an index?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.