in oracle hrms.there are some mandetary field.how to change
mndatory field to non-mandetory field.exmp-in people enter
table sss num is mndatory field .how to change it non-
mandetory?
Answer Posted / balakrishnaraothota
select newtable as create col3,col2,col1 from oldtable
then rename the table
ex:if oldtable is table1 having c1,c2,c3 now we want
c3,c2,c1 then u need to use above query
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is advanced benefits module in Oracle HRMS?
Hi, I am Samrat Saha. I did BCA & MBA ( major HR & minor System). i m 2009 passout. i also did Oracle Apps Core HRMS & SCM( O2C Transaction & setup, OM setup, Po Setup, INV Setup) certification... I Had 9 month experience on HR domain.. now i want to switch in Oracle Apps, as Functionalist.. i need help to get a job.. my email: samrat.contact@gmail.com
What is the difference between both SECURED VIEWS and NON SECURED VIEWS?
Explain the tools used with oracle hrms.
What are the key flex fields present in Oracle HRMS?
How many types of payrolls are there?
Differentiate between system administrator and application developer responsibilities.
Tell me the name of important Key Flex-Fields (KFFs) in Oracle HRMS?
How do you declare bonus of an employee in Oracle HRMS Payroll?
how do you link a host type concurrent program to concurrent manager?
How can you make Employee Number generation Automated based on business rule etc?
How can we set up Global Payroll?
What is date tracking in hrms?
What are the steps involved in implementation of Oracle HRMS?
what are termination roles of an element?