Can select statements be used on views in oracle?
What is rowid and rownum in oracle?
4. Using a set operator, display the creditor number of all creditors who have ever been paid.
What is the parameter mode that can be passed to a procedure?
How do I recompile a procedure in oracle?
What are the general rules on data consistency?
How to rename an index?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
emp numb is unique because that is primary key,,but what is foreign key .. explain very clear with example
Hi Guys,I have completed my B.com Commerc in the year 2005 and MBA finance in 2008(Correspondance).And I have 3+yrs exp in Accounting and Finance feild.I have worked for TCS for 1.8yrs as Project manage office as a enduser in oracle ERP module.Currently working as Project Adminstartor for CSC.I have joined in Oracle financial classes and I am through with that subject.So my concern is After learning oracle, am in dilemma that will i be eligible to get job in oracle or not?Please advice or Give me suggestions.To kick start my career as fresher in Oracle
Explain the use of owner option in exp command.
Can you tell me how to add new column in existing views?how?How is possible?
What are the differences between a sys and system user and what are the extra privileges available to the sys user?