adspace
suppose u have been seven tables based on that u have to
create a report u don't have access to db. then how do u
find the relation between tables
Answer Posted / Lalit Chahal
Without database access, it is challenging to determine table relationships directly. One possible solution is to obtain metadata (like ER Diagrams) about the database schema from the database administrator or from available documentation, if any.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement