How do you find current date and time in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
How to recover a dropped table in oracle?
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
What is a schema in oracle?
How data locks are respected in oracle?
What is enter substitution variable in oracle?
what is the syntax of CREATE command?
What are the Referential actions supported by FOREIGN KEY integrity constraint ?
What does COMMIT do ?
What is parameterized cursor in oracle?
what is null value?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
how do get database name at sql prompt?