• Home »

Question.1  How to create user account? Answer: Using T_code SUO1 we create the user accounts. Question.2   what are the various steps for crating the User? Answer: Address Data, Logon Data, Defaults, Parameters, Profiles, Activity groups, Users.         Question.3 What are the Different types of users? Answer: External..

Question.40   Display the name,job of the employees and display Executive if   the job is Clerk , RM if the job is Manager else display the job. Answer: SELECT ename,job, DECODE(job, ‘CLERK’, ‘EXECUTIVE’, ‘MANAGER’, ‘RM’, job) FROM emp; Question.41  To display employee name, department name and department   number for all employees…

Emp Table: EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO 7369 SMITH CLERK 7902 17-Dec-95 800 20 7499 ASHA SALESMAN 7698 20-Feb-95 1600 300 30 7521 WASIM SALESMAN 7698 22-Feb-95 1250 500 30 7566 RAJA MANAGER 7839 02-Apr-95 2975 20 7654 MARIA SALESMAN 7698 28-Sep-95 1250 1400 30 7698 BILL..