Describe the types of sub query?

1060

Is a rollback possible to any savepoint?

1159

Explain the use of record length option in exp command.

1126

What is redo log?

1116

Please explain oracle left join with an example?

1095

What is the difference between sharding and replication?

1139

What are group functions in oracle?

1099

What is the minimum client footprint required to connect c# to an oracle database?

1166

What is an index associated with a constraint?

1094

Differentiate between function and procedure in oracle.

1157

How to create a new table by selecting rows from another table?

1151

Which is better Oracle or MS SQL? Why?

5040

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?

2506

How to define an external table with a text file?

1129

How to write a query with a right outer join in oracle?

1225