D2K - How to use single data block to query multiple tables

GeekInterview.com > Interview Questions > Oracle > D2K

Go To First | Previous Question | Next Question

D2K | Question 4 of 71

How to use single data block to query multiple tables

Total Answers and Comments: 12

Last Update: August 23, 2008

Sponsored Links

Best Rated Answer

—

Submitted by: abhishek agarwal

By using Post Query trigger.

Above answer was rated as good by the following members:
ajaybhg

Sorting Options

Page 1 of 2

« First

Last »

August 22, 2005 04:17:35

Naidu. Kondisetty

RE: How to use single data block to query multiple tables

You can do using CLUSTER CONCEPT.

Is this answer useful? Yes | No

September 01, 2005 18:41:42

Subhash

RE: How to use single data block to query multiple tables

By creating a View based on the tables and create the Block based on that view.

Is this answer useful? Yes | No

October 10, 2005 06:46:08

Rubai

RE: How to use single data block to query multiple tab...

FROM Clause query

Is this answer useful? Yes | No

April 08, 2006 01:57:06

dhiraj

RE: window date problem...

dear friend

I am try.But so success .so please help me.

run form .window title display but no date display.

thanks

by dhiraj.

Is this answer useful? Yes | No

June 29, 2007 18:37:46

Manoj Warrier

RE: How to use single data block to query multiple tab...

Use the from clause query in the property palette of the block and write the sql statement using joins and fetch the data from multiple tables
try it guys its pretty fast and effective as well

Is this answer useful? Yes | No

July 12, 2007 06:21:20

abhishek agarwal

RE: How to use single data block to query multiple tab...

By using Post Query trigger.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

August 08, 2007 01:03:52

Mathialagan

RE: How to use single data block to query multiple tab...

By using query_data_source_name property we can view multiple table records

Is this answer useful? Yes | No

November 17, 2007 01:37:49

devenar

Member Since: November 2007 Contribution: 3

RE: How to use single data block to query multiple tab...

Using SET_BLOCK_PROPERTY and property DML_DATA_TARGET_NAME. We can change the query source as well as change the DML source of the block at runtime.

Is this answer useful? Yes | No

November 17, 2007 01:55:06

devenar

Member Since: November 2007 Contribution: 3

RE: How to use single data block to query multiple tab...

QUERY_DATA_SOURCE_NAME Specifies the name of the block's query data source. Note: You cannot set a blocks’ QUERY_DATA_SOURCE_NAME when the block’s datasource is a procedure. - Use the SET_BLOCK_PROPERTY for this.
And DML Data target name is for changing the DML target. Cna ignore my last ans.

Is this answer useful? Yes | No

December 03, 2007 06:56:48

#10

joybanerjee

Member Since: November 2007 Contribution: 19

RE: How to use single data block to query multiple tables

1) first create a block using the table A (say). then in the Query Data Source name write the name of the other tables say B.
2)In the Where clause of the block write the join like
a.colname b.colnname.I the connecting coloumn between two tables)
3) set the query allowed property to YES
4)set key mode non updateable.

Is this answer useful? Yes | No

Page 1 of 2

« First

Last »

Go To Top

User Name		Remember Me?
Password

Question Bank