Difference Between Select * from sys.dba_users and Select * from dba_users
By: Sugandh | 07 Oct 2014 11:27 am | 1615 times viewed | 1 Comments
Select * from sys.dba_users vs Select * from dba_users
What is the difference between Select * from sys.dba_users and Select * from dba_users?
please provide me the correct answer.
thanks in advance
Top 10 Highest Paid SAP Companies in IndiaThere are several reasons why only a handful of companies are rated among the top 10 or top 20. These reasons could be related to financial, work culture or even related to the learning opportunities being offered by organizations. Off late the companies are laying a lot of emphasis on the overall...
SAP to Boost Up the Oil and Gas SectorSAP as we all know is the market leader the of e-business software solutions in the world. By virtue of using mySAP.com e-business platform, all around the globe the businesses are improving their relationships with their esteemed partners as well as customers. The application allows them to...
SAP is Complex: Is there an Easier Way to Say This?Though the SAP software presents an extremely customer-friendly exterior, it remains enormously complex; wherein it needs millions of lines in code for effective functioning in a large enterprise. 'The lack of code quality is a pressing issue on SAP’s 100,000-plus...
How's Big Data Dealing with 'Big Brother' Data Privacy IssuesThere is a new buzzword in the world of Big Data, one that talks about the privacy issues related with the “big brother”. This is specifically true with regards to the processes linked with the accumulation, analysis and mining of Big Data. It’s fortunate that quite a few of these rumors, and...
SAP HR Configuration Step by Step ProcedureHR Configuration Steps:First Goto SAP Logon ScreenYou come to the SAP initial screen.Overview of Human Resource Structure Define Company Company Code Assign a Company-Code to a Company Personnel Areafor details follow the Screen Shot:Related: Outgoing Email Configuration Step By StepFirst Goto SAP...
Comparison Between Two Queries in Oracle?
Hello Oracle Experts,I have two tables one is TAB1 (1000 rows) and other one is TAB2 (10 rows) now select tab1.*,tab2.* from TAB1 ,TAB2 where (tab1.col=tab2.col);select tab1.*,tab2.* from TAB2 ,TAB1...
Difference between Parse Calls Vs Execution
Good Morning all ; I know difference between hard parse Vs Soft parse. Can anyone explain difference between parse calls Vs Execution as per my query result ? both showing numeric '8' -...
Difference Between NETCA & NETMGR.
Hello Everyone, What is difference between NETCA & NETMGR. Both Utilities work on oracle 10g and 11g. Then what is the differences ? Please share your valuable thoughts.
Oracle Character Set Convert
Background:now I have two oracle 11gR2 database in different machines,one is a product database,the characterset is ZHS16GBK ;the other one is a new database,the characterset is AL32UTF8?either the...
Oracle upgrade from 9i to 10g
Dear all, Currently we are using SAP R/3 4.7 on HP-UX with RDBMS oracle 9i. As we know, oracle 9i is out of support so now we want to upgarde it to oracle 10g. Can someone send me any docs...
Concerning About Oracle Cloud Control (OEM)
Hi All. I have a question concerning oracle Cloud Control (OEM). Here's the situation: I have a target database that I want to monitor with OEM. I want to use the logins and logouts of...
Oracle Query Performance
UPDATE F_ATTRIBUTES_PROCESSING FP SET TAC_003 = ( SELECT T.TAC_003 FROM (SELECT /*+ PARALLEL (D_ACCOUNT,8) */ D_ACCOUNT.ACCOUNT_NO, CASE WHEN T1.ACCOUNT_NO IS NULL AND D_ACCOUNT.STATUS !=10103 ...