Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Shobin

    frm-30162 error?

    Hi,<br> <br> Let me guess you're using forms 5.0... i've also had that error at the beginning then i've installed a patch for developper 2.1 and that message didn't appear anymore.<br> <br> Good Luck<br> <br> Shobin<br>
  2. Shobin

    I'm using reports2.5 under O 7.3 When you run a report you get a scre

    Hello Tek1234,<br> <br> I'm also using reports2.5 under O7.3 for a while and i don't any way of bypassing that screen... i hope i'm mistaken.<br> <br> Shobin
  3. Shobin

    query on date field

    Hi Bookor,<br> <br> You should try TRUNC, TRUNC(date,'DD'); <br> <br> Good Luck<br> <br> Shobin
  4. Shobin

    Can you re-query a query ?

    If you use the Keyword DISTINCT on your select and don't put the field FullName, you'll have the ProjectID of both SomeNames.<br> <br> About requerying i don't know anything about it...<br> <br> Good Luck
  5. Shobin

    Custom sort in SQL?

    This suggestion it only works for one book at the time, but you can create a cursor to calculate the Position, and then instead of doing the Select substr... create view as Select substr...<br> <br> Declare <br> Position number(2);<br> <br> Begin<br> Select instr(title,' ') <br> into...
  6. Shobin

    Run a query # of times in a given month?

    Hi,<br> <br> I don't know if you expect only one field as result of your query, see if this helps you:<br> <br> Select count(*),ddate<br> from sorted<br> where to_char(ddate,'MMYYYY') = to_char(sysdate,'MMYYYY')<br> group by ddate;<br> <br> this returns something like this:<br> <br> COUNT(*)...
  7. Shobin

    Make query run # of times in the month??

    Hi,<br> <br> I don't know if you expect only one field as result of your query, see if this helps you:<br> <br> Select count(*),ddate<br> from sorted<br> where to_char(ddate,'MMYYYY') = to_char(sysdate,'MMYYYY')<br> group by ddate;<br> <br> this returns something like this:<br> <br> COUNT(*)...
  8. Shobin

    reports 2.5 performance

    If you add the system parameter MODE to your default parameter form, with the value CHARACTER, you'll have a ascii report. Be careful because some fields of the layout must be bigger or it'll appear **** on the field.
  9. Shobin

    How to get a query to output to a .dbf file???

    If you use the query on the Oracle Browser you can save the result into a csv file, select the export option and the type of file you which.
  10. Shobin

    Page break when detail reaches a certain number

    On Report 2.5 you have a boilerplate property called Minimum Widow Lines, if you put de minimum lines = 3 an page break occurs..<br> <br>
  11. Shobin

    reports 2.5 performance

    The only way i'm remembering to speed up your reports is convert them to ascii, instead of bipmap. But you can only do this if you have the source code, that i suppose you don't like you said in another post.<br> <br> Good Luck<br> <br>
  12. Shobin

    multiple ver of developer runtimes

    The best option is to convert the forms 4.5 and reports 2.5, it's very simple you only need to compile them using the forms builder (5.0) and report builder (3.0).
  13. Shobin

    Where are Oracle Apps library files located?

    I don´t know your application of Purchasing, but the pll's are usually on the directory of orant\forms45\plsqlib, orant\graphics\rob\pll, etc...
  14. Shobin

    Creating DBA Login.

    You don't need to create a dba login, you have two dba users:<br> sys,system<br> <br> They are automatically created and have the dba role. The password from sys is change_on_install , system is manager.<br>
  15. Shobin

    Calling a C program from PL/SQL

    You can use winrsh to call your C program.
  16. Shobin

    SQL Loader

    I don't have Perl installed, and it must be using SQLLDR...<br> thanks anyway...:)
  17. Shobin

    SQL Loader

    Well, i'm going to try to explain better... <br> I've a file that has a script which loads the data from the file to a table, one of the fields from my table must be updated with a certain date passed as parameter, this script is processed by SQL LOADER . Can i pass a parameter into this script?!
  18. Shobin

    SQL Loader

    Massage"?!!!!<br>
  19. Shobin

    SQL Loader

    I've a script where i want to pass a date as parameter, can i do that using SQL Loader? and How?!

Part and Inventory Search

Back
Top