1
  • Oracle Reports 6i style

    Currently my report is being displayed in landscape style. I want it to be displayed by rotating it in a 90degree angle. For example, say my current report is '|'. I want to display it as '-'. The reason behind it was, the increase in the number of columns. Do we need to make any change in the...

    Pardhu15 pointsBadges:
  • Oracle Inventory – View pending transactions

    Hi, One of the users cannot view PENDING TRANSACIONS, while others can view. All  use same responsibility. What can be a reason?

    Tahirali5 pointsBadges:
  • 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.

    Tgee60 pointsBadges:
  • oracle views

    what is the differnts bw view and metialized view

    Oracleviews5 pointsBadges:
  • 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...

    Ariadnedbka5 pointsBadges:
  • 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?

    Skabanga5 pointsBadges:
  • 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...

    OracleATE190 pointsBadges:
  • 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 view...

    Orit15 pointsBadges:
  • 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...

    NotesBeginner5 pointsBadges:
  • 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.

    Dbawiz5 pointsBadges:
  • view and temp. table which one works better in T-SQL?

    please tell me which one performs better view or temp table ?

    HL5 pointsBadges:
  • 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...

    Ora mer20 pointsBadges:
  • 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.

    Maneswar15 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following