Search results for query: *

Is it possible to create a table within a PL/SQL block? Basically I am checking user_tables to see if a table exists, and if it doesn't then I am creating it. declare v_count number; begin select count(*) into v_count from user_tables where table_name = 'TEMP_2YEAR_DRIVER'; if v_count =...

I am using CR 8. I am trying to select information from multiple tables and am getting snagged by an invalid character. My best guess is that I am getting hung up on the FROM protion of my SQL Query. I am trying to select information from a nested query. My from statment looks similar to...

My goal: Have a listbox full of OfferIDs. I want to display the detailed information for a perticular OfferID when it has been selected in the listbox. Here is what I am doing, that is not working: Created table to hold the selected OfferID. Main form is based off of this table. Put a...

The database table I am looking at has legacy data. I am looking to get the minimum start date, but the rest of the data from the current record. Here is an example: Table: BOOKS Fields: Name Description Release_Date Expired_Date ABCook Cooking 12/30/2003...

...there is a growing SubReport above. I am using Crystal Reports 8. I have a growing SubReport above other SubReports. The problem is, the top SubReport is growing over the lower SubReports. How do I get it to push the other Fields/SubReports down on the sheet? Thanks in advance for any...