Purpose of Query
The query returns the line start, column start, line end and column end of an object
Applicable CAST Version
Release | Yes/No |
---|---|
8.3.x | |
8.2.x | |
8.1.x | |
8.0.x | |
Applicable RDBMS
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS2 | |
Query for CSS
SELECT SP.line_start, SP.col_start, SP.line_end, SP.col_end FROM dss_source_positions SP JOIN dss_code_sources CS ON CS.source_id = SP.source_id JOIN objfulnam k ON k.idobj = SP.object_id AND k.fullname = 'name of the objects'
Query result example
20;6;20;19
Query result interpretation
The query returns the line start, column start, line end and column end
Query for Oracle
SELECT SP.line_start, SP.col_start, SP.line_end, SP.col_end FROM dss_source_positions SP JOIN dss_code_sources CS ON CS.source_id = SP.source_id JOIN objfulnam k ON k.idobj = SP.object_id AND k.fullname = 'name of the objects'
Query result example
20;6;20;19
Query result interpretation
The query returns the line start, column start, line end and column end
Query for SQL server
SELECT SP.line_start, SP.col_start, SP.line_end, SP.col_end FROM dss_source_positions SP JOIN dss_code_sources CS ON CS.source_id = SP.source_id JOIN objfulnam k ON k.idobj = SP.object_id AND k.fullname = 'name of the objects'
Query result example
20;6;20;19
Query result interpretation
The query returns the line start, column start, line end and column end
Notes/comments
Related Pages