21⟩ Explain about the oracle disaster recovery scenarios?
USE DBNAME
go
EXEC sp_change_users_login 'Update_One', 'LoginUserid', 'LoginUserid'
Note: if you are using a different SQl login userid then this 'Login Userid' ,'NewloginUserid'
Oracle Scenarios
Home Oracle Oracle Scenarios
“Oracle Scenarios guideline for job interview preparation. Explore list of Oracle Scenarios frequently asked questions(FAQs) asked in number of Oracle Scenarios interviews. Post your comments as your suggestions, questions and answers on any Oracle Scenarios Interview Question or answer. Ask Oracle Scenarios Question, your question will be answered by our fellow friends.”
23 Oracle Scenarios Questions And Answers
22⟩ How we remove duplicate rows in table?
select * from employee a where rowid not in(Select min(rowid) from employee b where b.emp_id = a.emp_id)
