troubleshooting Question

SQL Query in XML

Avatar of interbus
interbus asked on
Oracle Database
2 Comments1 Solution351 ViewsLast Modified:
I write a SQL Query in XML as follow

I read this defenision from XML file to connect with database.

I need to display column alias name not column name

How I can using where condition in SQL Query like >=, <=, <, >
<sql-report
       connection-name="StudentDb"
       description="Student Details"
       statement="SELECT FLD_STUDENT_ID, FLD_STUDENT_NAME, 
                          FLD_AGE, FLD_CLASS, FLD_ADDRESS, FLD_PHONE_NO
	     FROM TBL_STUDENT ORDER BY FLD_STUDENT DESC">
 
          <sql-parameter
            parameter-type="fat-field-value"
            value="STUDENT_ID"/>
 
        </sql-report>
 
        <sql-query
          connection-name="STUDENT"
          description="STUDENT DETAILS"
          table="TBL_STUDENT">
          <sql-query-column
            column-alias="STUDENT ID"
            column-data-type="number"
            column-name="FLD_STUDENT_ID"/>
          <sql-query-column
            column-alias="STUDENT NAME"
            column-data-type="string"
            column-name="FLD_STUDENT_NAME"/>
          <sql-query-column
            column-alias="AGE"
            column-data-type="number"
            column-name="FLD_AGE"/>
          <sql-relate-column
            column-data-type="number"
            column-name="FLD_REGION_ID"
            field-name="STUDENT_ID"/>
        </sql-query>
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros