How to select some rows from a table in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
Explain the difference between replace() and translate() functions in oracle?
How to create a new user account in oracle?
What is an oracle wallet?
what is the difference between functional dependecy and multilevel dependency?
Can 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?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
What is truncate oracle?
According to oracle specification VIEW is a object. OBJECT that means anything stored in the oracle database that has the physical existence.why VIEW doesn't take memory in oracle database, but it is treated as a object ?Please explain ?
what is main def between plsql/table and array?
Is there any function in oracle similar like group_concat of mysql?
Two triggers one is before insert and other is after insert are firing on a table.If 10 times you insert in a table.Then how many times before trigger and how many types after trigger will fire in pl/sql.