What is materialized view in Oracle?
No Answer is Posted For this Question
Be the First to Post Answer
How to retrieve values from data fields in record variables?
How to fetch the row which has the max value for a column?
if i am using dml statement in function. then i am writing select statement what was the output
Explain oracle left join with an example?
What are the factors causing the reparsing of SQL statements in SGA?
How to install oracle odbc drivers?
Describe varray?
How a database is related to tablespaces?
Hi all, Can any one give answer for this question. Suppose im having employee table with fields, eno, ename, dept, address1, address2, address3. In address field employee can fill only address1 or address2 or address3... at a time he can fill three address fields. now i want all employee names who filled only one address field.. Plz its urjent can any one give querry.. Thanks in advance.
How to write an inner join with the where clause in oracle?
1.What is inline function in oracle and its purpose? 2.What is the equivalent operator for "different from pattern" in oracle? 3. If you define a variable in oracle, how it will be available? [a. Until database shut down b. Until table deleted c. until session get expired]
How to use select statement to count the number of rows in oracle?