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 Chriss Miller 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: *

  • Users: oradba101
  • Content: Threads
  • Order by date
  1. oradba101

    Save As issue

    Greetings, I am using Crystal 10. If I have a report open and I want to save as a report with a different name, the name in the window bar in the top left hand corner still has the name of the original report. I know that if I select File->Summary Info from the menu bar then I can save it...
  2. oradba101

    Replace first occurence of string from the right

    Greetings, I need to be able to replace street names with their abbreviations. For example, 123 Maine Street would become 123 Main St If I use the REPLACE function it replaces all occurrences. For example, 123 Lanes Lane would become 123 Lns Ln Any help would be greatly appreciated...
  3. oradba101

    Oracle APEX forum

    Greetings, For the inquiry for the Oracle APEX forum there is currently one available called "Oracle: WebDB". Perhaps it could be renamed to Oracle: APEX? Regards, William Chadbourne Programmer/Analyst
  4. oradba101

    MEDIAN function

    Greetings, Does anyone have a function that calculates median values? Regards, William Chadbourne Programmer/Analyst
  5. oradba101

    Passing multiple values to a parameter

    Greetings, I need to be able to pass multiple values to a parameter. Is there any way to do this? Regards, William Chadbourne Programmer/Analyst
  6. oradba101

    defibg x-axis ranges

    Greetings, I am using Crystal XI. Is it possible to define your own ranges in the x-axis of a chart? Regards, William Chadbourne Programmer/Analyst
  7. oradba101

    WITH clause

    Greetings, I an using a WITH clause within an SQL-SELECT statement. Is it possible to nest WITH clauses within the same query? Regards, William Chadbourne Programmer/Analyst
  8. oradba101

    Returning Null

    I am using Crystal XI. I have a formula that returns 0 if there isn't any value. How would I get it to return NULL? Regards, William Chadbourne Programmer/Analyst
  9. oradba101

    Trying to calculate

    Greetings, I am using Crystal XI. The issue is rather complex and if I do not provide enough details please let me know. The first calcualtion is the minimum and the maximum values of a numeric field with three decimal places. The field is called ppbv. The secong is a parameter based upon...
  10. oradba101

    Changing chart options via user-inputted parameter

    Greetings, I am using Crystal Reports XI. Ia it possible to change chart options from an inputted parameter? Regards, William Chadbourne Oracle DBA
  11. oradba101

    DBMS_ERRLOG

    This package is available with Release 2 but I was wondering if anyone has a package or procedure that works the same way for Release 1. Regards, William Chadbourne Oracle DBA
  12. oradba101

    User to kill their own session

    Good morning, Is there anyway a user can have the ability to kill their own sessions? If it is possible how is this set up? Regards, William Chadbourne Oracle DBA
  13. oradba101

    Pivot and/or crosstab?

    Good morning, I have a table that records all electronic signatures. The structure looks like this: trt_plan_id client_id page_name seq emp_id ----------- --------- --------- --- ------ 121706 1111 test 1 9999 121706 1111 test 2 8888 121706...
  14. oradba101

    Inserting columns in a table

    Good morning, all I need to insert some columns at a certain position in a table. If I add the columns they are always put at the end of the table whereas I need to be able to select where thay need to be added. Any help would certainly be appreciated. Regards, William Chadbourne Oracle DBA
  15. oradba101

    SQL*Loader user priveleges

    Good morning, all Without assigning the DBA role, what are the minimum privileges needed for a user to use sql*loader. The scenario is that I would like another user to be able to load data into another user's schema but do not want this user to have anything other than the minimal...
  16. oradba101

    Finding numbers in a varchar2 column

    Good morning, all I have a column that is supposed to be used to put in a staff person's name. On occasion, the people doing the data entry will put in the staff person's id which consists of a 4-digit number. I would like to be able to identify these columns. Regards, William...
  17. oradba101

    partitioning table

    Good morning, I have an accounts receivable table that I want to partition into months, quarter, and fiscal year. How would I go about doing this? Regards, William Chadbourne Oracle DBA
  18. oradba101

    installation log

    Hi, all I am using SuSE10 and was wondering some type of installation log is generated during installation. If so, what is it called and where is it located? Regards, William Chadbourne Oracle DBA
  19. oradba101

    Where is my listener.ora file

    Good afternoon, all Have an interesting one. I have been running Oracle10gR2 for quite a few months now. I have no problems connecting to it whatsoever nor have not had any issues to speak of. To get to the point I do not have a listener.ora or tnsnames.ora anywhere on the server (with the...
  20. oradba101

    Using / to connect

    Good morning, Is there anyway to disable the forward slash / when connecting to Oracle. I would prefer to have to type in the username and password. I am running Oracle on SuSE Linux. Regards, William Chadbourne Oracle DBA

Part and Inventory Search

Back
Top