Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

View using Union Query

795014Aug 30 2011 — edited Aug 31 2011
All,
How to create a view using a union query in sql developer. I tried doing but when i check the syntax I got an error

"The SQL syntax is valid, however the query is invalid or uses functionality that is not supported.

Declarative query support does not currently include UNION, INTERSECT or MINUS"

Could some one help me out

Regards

Comments

807601
Not until you learn how to spell please. This is not a text message on your mobile.
807601
A Static method can be called with the class name with out creating an object,
Ex. <className>.<methodName>();
where as the non static method must be called by using an object, an object is an instance of a class.
Ex. <objName>.<methodName>();
807601
Angelina123 wrote:
Hi there,
I am new to java.Plz tell me the difference between static and dynamic methods.
Do you mean the difference between methods that are declared static and those that are not? The former are also sometimes called class methods and the latter instance methods.

When a method (or variable) is declared static it belongs to the whole class. If it's not declared static it belongs to each object (instance) of the class. When you call a static method you prefix the name with the class name. When you call an instance method you prefix the name with an object reference.

Most of your methods will be instance methods. Static methods are used for thing that concerns the whole class. One example is that it could keep track of how many objects that has been created. Another example is that it could be used to create objects of the class (a so called object factory).
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 28 2011
Added on Aug 30 2011
2 comments
488 views