How to create a new table in oracle?

1145

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?

2451

How to use group functions in the select clause using oracle?

1063

How to define an explicit cursor in oracle?

1026

How do I find the database name in oracle?

1030

What do you understand by the term 'normalization'? Explain the various modes of normalization?

552

What are set operators?

1076

What is the quickest way to fetch the data from a table?

1054

Query to retrieve record for a many to many relationship ?

2508

How to convert character types to numeric types?

1114

what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?

1009

What is oracle forms system.currentblock?

1

What is ora-1555 snapshot too old error? Explain in detail?

676

How can you tell if an index on particular table is used or not used in 9i?

560

How to convert characters to numbers in oracle?

1055