what are the mandortary parameters required for cuncurrent program definition in oracle apps R12?
1 2800src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
IBM,
1746Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
1436HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
1471Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
1395Post New Oracle General Questions
Why do you use stored procedures and state some of its disadvantages?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
How many anonymous blocks can be defined?
Can we use bind variables in oracle stored procedure?
What is an external table?
What is a snapshot in oracle database?
WHAT IS ecc 6.0
Is oracle an open source?
What is oracle rowcount?
State some uses of redo log files?
What is the difference between truncate & delete command?
What is Virtual Private Database in Oracle?
How many types of segments in Oracle?
How many types of synonyms in Oracle?
Explain the importance of .pll extension in oracle?