Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / kumar
Sequence is used for number generation.
We can create a sequence and cannot update a sequence
directly.
After creating a sequence we ca use functions nextval,
currval and setval to operate on the sequence.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain the use of online redo log files in oracle.
What are the differences between interval year to month and interval day to second?
What is the dynamic sql in oracle?
What is clustered table in Oracle?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
master table and child table performances and comparisons in Oracle ?
How to handle a single quote in oracle sql?
What is the difference between truncate & delete command?
Can we convert a date to char in oracle and if so, what would be the syntax?
Give the various rollback segment states.
How can we force the database to use the user specified rollback segment?
HI 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.
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
src 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'));
What is where clause in oracle?
