Home » SQL & PL/SQL » Client Tools » Writing QBE's that are longer than the field length
Writing QBE's that are longer than the field length [message #678839] Fri, 17 January 2020 02:32 Go to next message
Andy523
Messages: 2
Registered: January 2020
Junior Member
Hello,

I am trying to write a QBE using #IN('32553','353532') but with 100 different numbers
The field length does not allow me retrieve more than about 20 so I have to write multiple QBE's to extract the information

Is there any way that I can write a QBE that bypasses the field size restriction
Note: I do not have access to writing any SQL commands, only executing QBE's

Thank You
Andy
Re: Writing QBE's that are longer than the field length [message #678840 is a reply to message #678839] Fri, 17 January 2020 03:08 Go to previous messageGo to next message
cookiemonster
Messages: 13895
Registered: September 2008
Location: Rainy Manchester
Senior Member
What's QBE?
Re: Writing QBE's that are longer than the field length [message #678845 is a reply to message #678840] Fri, 17 January 2020 06:22 Go to previous messageGo to next message
Bill B
Messages: 1969
Registered: December 2004
Senior Member
I think he means Query By Example(QBE), meaning a tool to build up a select command

[Updated on: Fri, 17 January 2020 06:34]

Report message to a moderator

Re: Writing QBE's that are longer than the field length [message #678848 is a reply to message #678845] Fri, 17 January 2020 07:31 Go to previous messageGo to next message
cookiemonster
Messages: 13895
Registered: September 2008
Location: Rainy Manchester
Senior Member
If the so answer may well depend on the exact tool being used, which the OP hasn't mentioned yet.
Re: Writing QBE's that are longer than the field length [message #678893 is a reply to message #678848] Tue, 21 January 2020 03:18 Go to previous messageGo to next message
Andy523
Messages: 2
Registered: January 2020
Junior Member
Yes, I mean Query By Example
The tool that I am using is called "Oracle Applications"
Re: Writing QBE's that are longer than the field length [message #678894 is a reply to message #678893] Tue, 21 January 2020 05:10 Go to previous message
John Watson
Messages: 8426
Registered: January 2010
Location: Global Village
Senior Member
So you are using EBS. We do have an EBS forum, but it isn't very busy.

I cannot remember the detail of the EBS QBE, but if you have found that you cannot construct your query in it, then you have probably hit a limitation of the tool. If you have access to the database over SQL*Net or through APEX or with any other query facility, you should be able to write and run your query there.

Or if you really don't have any access other than through the EBS forms, perhaps you could write and run the query as a concurrent manager program.
Previous Topic: Can not bangla supported in oracle
Next Topic: Help with tnsname.ora
Goto Forum:
  


Current Time: Sun Nov 29 01:51:21 CST 2020