Views [dbo].[v$gla_data]
(local) > mdb > Views > dbo.v$gla_data
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created11:10:20 AM Wednesday, March 07, 2007
Last Modified11:10:20 AM Wednesday, March 07, 2007
Columns
Name
timestamp
num_val
text_val
object_name
scan_name
agent_name
SQL Script

CREATE VIEW "v$gla_data" AS
       SELECT "gla_hours"."timestamp", "gla_hours"."num_val", "gla_hours"."text_val", "gla_objects"."object_name", "gla_sdamaps"."scan_name", "gla_agents"."agent_name"
       FROM "gla_hours", "gla_objects", "gla_sdamaps", "gla_agents"
       WHERE gla_hours.obj_id = gla_objects.obj_id AND gla_objects.agent_id = gla_sdamaps.agent_id AND gla_objects.scan_index = gla_sdamaps.scan_index AND gla_sdamaps.agent_id = gla_agents.agent_id


GO
Uses
Created 03 June 2010 08:02
Copyright 2010 by CA Technologies, Inc. - All Rights Reserved