Is it possible to increase the line number in the DataSource From Clause ?
i have a very complex query and it works in SQL Navigator.i want to make this query as a portlet.But there is a problem,i use crosstab ,left join and right join in that query,i have to make all the body of the query in a parantyhes after the from clause. When i paste this part of the query in from clause ,not all the lines fit in it.I think there is a line quota,how can i increase this ?
Re: Is it possible to increase the line number in the DataSource From Clause ?
Erik, by the way how can i pass parameters to this view? i want to make 2 date field as a filter variable.When the user chooes these dates,the value of this parameters should pass into the query.But these date field parameters are not in the final select fields. i hope i can explain the situaiton. Thanks.