Search results for query: *

Using system views, can the table be identified within user written views and functions? Example: I have functions that access a table. Can I query the database to identify all the functions the table is in? Thank you.

I need to execute a view statement to do the following: Table A Loan_Number Loan Officer Table B Loan_Number Borrower_Name Table A Values Loan Number: 123 Loan Officer: FRANK Table B Values Loan Number: 123 Borrower Name: SMITH Loan Number: 123 Borrower Name: JONES Query Output Needed...

I want to produce a GroupWise address book (.NAB) file. Using export, I can produce the data in the format needed. The problem I have is I need to generate ONE header record before the detail records. The header is used when the address book is populated into GroupWise.(The header contains...

I have a one-to-many relationship between tableA and tableB. I need to write a sql statement to select data from the parent tableA and, on a single field, combine data from the child tableB. Example: TableA has property information TableB has contact information for the property My...

Is it possible to execute a stored procedure within a view? Thank you.

I'm new to the use of temporary tables. I'm trying to create a temporary table using the following procedure: create or replace procedure P_X1 execute immediate "CREATE GLOBAL TEMPORARY TABLE X_TABLE ( x_year NUMBER(4), x_MONTH VARCHAR2(9)) ON COMMIT PERSERVE ROWS"; END P_X1; I'm...

I have 5 records, each with a different expiration date: 20010601 20020520 20030316 20041230 20051007 I have to find the one record where the comparenumber is the highest value without exceeding the comparenumber Example: Comparenumber (from another table) = 2050206 I need to select only...

I'm using DreamWeaver MX to write a date field to an Oracle 9i database. The date is not the system date. The only way I can enter the date is in the format: dd-mmm-yy. How can I change the format in DreamWeaver to enter the date as mm/dd/yyyy? Thank you.

Hello - GroupWise Version: 6.5 I've set up proxy access to send emails in my name. Is it possible for me to receive notification of a failed email due to a bad address - without the proxy creating a rule? The failure notice is received by the proxy only. Thank you

Selected data was not able to be accessed from the Oracle 9i database. No errors were reported. A compiled AcuCobol program (last compiled in 9/2003) and Crystal 8.5 did not find the data. A dump (BUT NO RELOAD) of the data was executed. Following the dump, the missing data was found by the...

In Oracle 9i is there way to encrypt the command line password? Thank you.

The Oracle login name and password are in plain text. Can the password be encrypted? Thank you.

I can append a report to a command line with CRW.EXE. It does open. Are there other line commands to have the report execute, pass parameters, and finally to exit Crystal after the report ends? Version: Crystal Reports 8.5 Thank you

I can create a custom connection string for Oracle 9i and connect to Oracle using the drivers on the local machine. When I select the option to use the drivers on the testing server, the connection hangs. Thank you.

I'm producing a Crystal report (8.5) (on a Win2000 platform) using an Oracle 9i view. The view selects data from 13 tables and contains 40 fields. If I select a small number of fields for the Crystal report, the report executes fine. If I select all or most of the fields, Crystal hangs. (A...

I'm producing a Crystal report (8.5) (on a Win2000 platform) using an Oracle 9i view. The view selects data from 13 tables and contains 40 fields. If I select a small number of fields for the Crystal report, the report executes fine. If I select all or most of the fields, Crystal hangs. (A...

I've created a view in Oracle. The view contains a function. The function is not in the list of available fields to group on. Is there a way in Crystal 8.5 to group on a function? Thank you.

I'm new to SQL and have a question regarding the combining of data. I have a SQL query that accesses three tables and is producing four records with the fields: Loan number, Loan type 1, Loan type 2. The loan number is the key on all three tables Table 2: Loan type values: 'A', 'B' Table 3...

I have an 8.3 version of Progress. Can a view be created in this version of Progress?

Crystal 8.5 How can I print data from a table based on every nth record in the table? Thank you.