1 - 11 of 11
PREVIOUS 1 NEXT
5 pts.
Using INSTEAD OF Views in Oracle Forms 6i
I have a block in my forms which is based on a view. I have created an instead of trigger on this view tu update certain fields. I would like to update this view through a Forms. I have made the block and the field updatable, but it gives me the following message when I try to write something on...
I have a block in my forms which is based on a view. I have created an instead of trigger on this view tu update certain fields. I would like to update this view through a Forms. I have made the block and the field updatable, but it gives me the following message when I try to write something on...
Oracle v$ view that dynamically has the names of procedures
Is there a v$ view where I may find just the names of all the procedures that are currently running in an Oracle database?
Is there a v$ view where I may find just the names of all the procedures that are currently running in an Oracle database?
Need help creating a specific Oracle View
We have several tables with what would probably have been nested columns if that feature had existed when they were created. They are simple VARCHAR2 columns occurring a fixed number of times (2 to 4). Since they are often null, the true number is variable with a fixed maximum. Although we would...
We have several tables with what would probably have been nested columns if that feature had existed when they were created. They are simple VARCHAR2 columns occurring a fixed number of times (2 to 4). Since they are often null, the true number is variable with a fixed maximum. Although we would...
Oracle Applications view functions mapping
hi, I have a query regarding Oracle Applications (OA) and I hope you will be able to assist me. I am looking for a list of OA functions which are VIEW functions, according to the hard-coded definition of Oracle. In other words, I am looking for a list of FORM FUNCTIONS that allow users only to...
hi, I have a query regarding Oracle Applications (OA) and I hope you will be able to assist me. I am looking for a list of OA functions which are VIEW functions, according to the hard-coded definition of Oracle. In other words, I am looking for a list of FORM FUNCTIONS that allow users only to...
view color codes
Hello... i m beginner in lotus notes and would like to know how to change/set color code to particular row in the view based on formula or condition...?? For ex. if the column value is vacant i have to set green color for that entire row in the view. if the column value is occupied it should red in...
Hello... i m beginner in lotus notes and would like to know how to change/set color code to particular row in the view based on formula or condition...?? For ex. if the column value is vacant i have to set green color for that entire row in the view. if the column value is occupied it should red in...
Oracle View
How can I get my view to return SYSDATE-4 hours? I currently have WHERE event.cdts = TO_CHAR (SYSDATE, 'yyyymmdd')is creation of the view. It is not returning anything.
How can I get my view to return SYSDATE-4 hours? I currently have WHERE event.cdts = TO_CHAR (SYSDATE, 'yyyymmdd')is creation of the view. It is not returning anything.
Assign default values to SQL VIEW columns
I'm trying to assign default values to VIEW columns defined for left joined columns or columns created by aggregate functions. I've tried the ALTER TABLE after the VIEW was created but get an error that my VIEW is not a TABLE and the ALTER VIEW is not supported by DB2/400 v5r3.
I'm trying to assign default values to VIEW columns defined for left joined columns or columns created by aggregate functions. I've tried the ALTER TABLE after the VIEW was created but get an error that my VIEW is not a TABLE and the ALTER VIEW is not supported by DB2/400 v5r3.
view and temp. table which one works better in T-SQL?
please tell me which one performs better view or temp table ?
please tell me which one performs better view or temp table ?
Oracle Cross Schema View
I am creating a cross schema view and am receiving the error 'Table or View does not exist' on the second table of one schema in my view. Here is the View: CREATE OR REPLACE VIEW WORKMGMT.VIEW_WORKMGMT_USERS( USER_ID, USER_VALID_FROM, USER_VALID_TO, DEFAULT_UNIT, LANGUAGE_PREFERENCE) AS SELECT...
I am creating a cross schema view and am receiving the error 'Table or View does not exist' on the second table of one schema in my view. Here is the View: CREATE OR REPLACE VIEW WORKMGMT.VIEW_WORKMGMT_USERS( USER_ID, USER_VALID_FROM, USER_VALID_TO, DEFAULT_UNIT, LANGUAGE_PREFERENCE) AS SELECT...
i want to get updated or deleted or inserted views from last four days
sir, How can we find views which are got manipulated(DML) from last four days or one week.
sir, How can we find views which are got manipulated(DML) from last four days or one week.
1 - 11 of 11
PREVIOUS 1 NEXT
