Manual Testing

[makk07]

Hi,

Anybody please let me know how to do manual testing of oracle 9i views created for crystal reports XI. I never did this before. Also I am new to oracle database.

At my job, crystal reports are created by using oracle 9i views.

Thanks!!

 

[SantaMufasa]

...how to do manual testing of oracle 9i views

I presume that by "testing" you mean you want to "see" what results from an Oracle VIEW.


The easiest method for such interaction with a VIEW is to connect to Oracle, via SQL*Plus, to a user account that has access to the VIEW you wish to test. (By "access", I mean you must connect as the OWNER of the VIEW or as another Oracle user that has, at least, SELECT privileges for that VIEW.)

Once connected appropriately to SQL*Plus, you can issue the following SQL*Plus and SQL commands. First, to see the logical columns of the VIEW:

(format)
SQL> describe <owner>.<view name>

(example)
SQL> desc test.emp_view
 Name                                      Null?    Type
 ----------------------------------------- -------- ------------
 LAST_NAME                                 NOT NULL VARCHAR2(25)
 SALARY                                             NUMBER(11,2)

In the examples, both above and below, the qualification of the "<owner>." is optional if connected as the owner of the VIEW.

Second, to query the VIEW, you can use the same SQL syntax as you would to query a TABLE:

(format)
SELECT <owner>.<view name>;

(example)
SQL> select * from test.emp_view;

LAST_NAME                     SALARY
------------------------- ----------
Velasquez                       2500
Ngao                            1450
Nagayama                        1400
...

Let us know if this resolves your need.





Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]