What is materialized view. What are different methods of refresh?
No Answer is Posted For this Question
Be the First to Post Answer
How will you make performance better for application including front end and back
How to trace the errors in pl/sql block code?
Why is %isopen always false for an implicit cursor?
Can we insert delete data in view?
Why is a primary key important?
Write a sql to print only character form the below string. @So&*CIE%$TE@GEN!@RAL
How do you determine the current isolation level? : Transact sql
What are the attributes of SQL*PLUS ?
2 Answers Dream Careers, Oracle,
How can you create Cursor with parametres ?
What is query execution plan in sql?
what is oracle database ? : Sql dba
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)