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 69

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