in materialized view the structure will create immediately
or not?
Answers were Sorted based on User's Feedback
Answer / his highness abdullah
mm...yeah the structure will be created
| Is This Answer Correct ? | 2 Yes | 1 No |
How to create an array in pl/sql?
when a procedure /package is getting invalidated?
how can we write a column values horizontal by using sql stmt; ex: select name from table_name;(actual output) a b c d require output is a b c d
5 Answers Honeywell, Interact,
How to get each name only once from an employee table?
How long will it take to learn pl sql?
What are different types of sql commands?
Differentiate between syntax and runtime errors.
check whether all the emp numbers are indeed unique.
What is pl sql record in oracle?
How can I get the number of records affected by a stored procedure?
suppose I have two table one Emp and other is dpt. Emp table has a field ,dept id,name ,sal and dpt table has a field dept id,dept name. Now I want to find out the emplyee list whose sal is between 2000-3000 from dept x.
7 Answers Geometric Software, IBM,
What are sql objects?
Oracle (3253)
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)