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'
Scenario testing is the real time testing techniques implemented on an application with the presence of certain applied conditions and environment.In this type of testing the behavior of the application or s/w is tracked and results are analyzed.And bugs are reported
SELECT TEXT FROM USER_SOURCE/ALL_SOURCE/DBA_SOURCE
WHERE NAME=<NAME OF THE PACKAGE> AND TYPE='PACKAGE';
HERE THE TYPE MAY BE PACKAGE,PROCEDURE,....
inner layer. execution carry on furthur without going to outer exception blocks.
Database modeling comprises: discovery, design, documentation, communication, DDL generation, re engineering
Webmaster 22nd of May 2012
Tell us what you feel about Oracle Scenarios Interview Questions and Answers
All comments will be published after review. No login or registration is required to post a comment on Oracle Scenarios Interview Questions and Answers We offer and invite you to submit your valuable comment now; Please be respectful of others when commenting. Insulting others, self-promotional comments, website promotional comments, marketing stuff, SEO Techniques, SMS-style content and off-topic comments will not be approved at this information portal.
So start sharing your thoughts regarding Oracle Scenarios Interview Questions and Answers
Thank you.
business listing (1 Comment) 2nd of March 2012
Pretty part of content. I just stumbled upon your site and in accession capital to claim that I acquire actually loved account your blog posts. Any way I will be subscribing to your feeds or even I achievement you access consistently fast.