Whether any commands are used for months calculation? If so, what are they?
No Answer is Posted For this Question
Be the First to Post Answer
What do you mean by redo log file mirroring?
Difference between sub query and nested query ?
19 Answers Keane India Ltd, TCS,
What are the different types of trigger and explain its various uses and functions?
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
How will you write a query to get a 5th rank student from a table student_report?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3 Answer:select length(trim('ram charan singh')) - length (replace (trim ( 'ram charan singh'),' ','')) +1 from dual The above query working properly when space between the words is only one &similar But ,If the space between the words is nonuniform. Ex:'ram charan singh is good' ans:5 i am not getting this answer using above query.
What is an oracle cursor variable?
What is object data modeling?
i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?
What is oracle host variable?
Explain an integrity constrains?