Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

1642

Is there an oracle sql query that aggregates multiple rows into one row?

542

How many categories of data types?

570

what are the advantages of running a database in archive log mode?

1729

What does a senior database administrator do?

287

if you ctreate table identity

1843

Is oracle the best database?

518

i have a repeating frame that prints on every page for a product code. But when on page ends the info associated with that product code is truncated and not overflowed to the next page.On the next page data with the new product code is displayed. I want the data for one product code to be continued on the next page if it does not fit on a single page. The values are as: repeating frame vertical = variable horizontal = variable page protect = 0 print object on = first page base printing on = enclosing object for the outermost frame which encloses the repeating frame: print object on = last page base printing on = anchoring object end of layout section = yes rest all the values are same as the repeating frame

2563

How to store only time; not date and time?

555

What is pragma autonomous transaction in oracle?

516

What is integrity and what is constraint??Explain with example

1695

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

541

How to do a full database export?

631

What is the order of defining local variables and sub procedures/functions?

597

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

1967