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...
View Answer
| Apr 11 2008 7:03 AM GMT
| asked by
NotesBeginner
Lotus Notes, Oracle Views, Formula Language
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.
View Answer
| Mar 26 2008 4:14 PM GMT
| asked by
Dbawiz
Oracle Views
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.
View Answer
| Jan 5 2008 11:57 AM GMT
| asked by
Tgee
SQL, Oracle Views, DB2/400
view and temp. table which one works better in T-SQL?
please tell me which one performs better view or temp table ?
View Answer
| Jan 5 2008 0:13 AM GMT
| asked by
HL
Oracle Views, T-SQL, Temp Tables
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...
View Answer
| Nov 20 2007 9:08 PM GMT
| asked by
Ora mer
Oracle, Oracle Views, cross schema
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.
Answer Question
| Oct 4 2007 1:10 PM GMT
| asked by
Maneswar
Oracle Views, Oracle
