Recent content by Shantha

Hi, Thanks for your reply. Now I got the procedure executing in ACCESS_MGR and creating tables in MAIN_MGR. After creating of the table i am trying to create synonym for the newly created table back to ACCESS_MGR within the same procedure. For this, the same procedure after creating the...

Hi, We are using Oracle 10g. We want to implement certain security setup for the schemas to be accessed by the developers. The design is as follows: MAIN_MGR:- will hold the complete tables, data and stored procedures ACCESS_MGR:- will have the synonyms to the tables created in MAIN_MGR and...

Hi, It has been planned in our project to migrate from oracle 8i to 10g. The installation and server upgradation will be taken care by a seperate team. We need to deploy the complete set of tables, data and stored procedures in 10g. Is it possible to take simple export & import the data in...

Hi, Would require help in transposing row values to single column values The below query provides the list of indexes and the index columns. In case of composite indexes, multiple index column is appearing in seperate rows. select a.INDEX_NAME, b. column_name from all_indexes a...

Hi, I am new to BO & Analytics tools, and having problem in displaying the dates in sorted order in the dashboard. The dashboard is a trend chart, which picks up data from an QUAS query. The QUAS query has an BO universe object with timestamp column in it formatted to display as DD-MON...

Hi SantaMufs, This is what i exactly need...Thanks and please have a star. Thanks, Shantha. Talent is what you possess; genius is what possesses you

Hi, The data residing in a particular table is of the following format: ROW_VALUE FIELD_VALUE ------------- -------------------- 1 1 1 BCKUP 2 13 2 BUSER 3 4 3 AUSER 4 36 4 CUB 5 7...

Hi Remou, What row_name indicates? Thanks, Shantha. Talent is what you possess; genius is what possesses you

Not for all metrics, but for few we want the data to be stored in the db to do some trend analysis. Thanks, Shantha. Talent is what you possess; genius is what possesses you

Hi, My requirement is to collect metrics from database/ datawarehouse environment and publish it. A master table with the below structure will hold the required information: Metrics Master ============== Metrics Id Metrics Name Query The query will contain the select query which would be...

Hi, I am facing problems in populating the data from a BLOB field to a CLOB field. Could somebody help in this regards. Shantha. Talent is what you possess; genius is what possesses you

In oracle if we want single quotes in data then we append it with another single quotes. For example if we want field1 in table1 to have the value 'Pike's Peak' then while inserting/updating the field you should say it as 'Pike''s Peak'. In your case you should say something like...

It is not recognizing calldemo.get_employees Either the user throught which you are logging into oracle doesn't have the access to calldemo.get_employees or it could be the object (calldemo.get_employees )is not existing in the database. Hope this helps. Shantha. Talent is what you possess...

One can load data into an Oracle database by using the sqlldr (sqlload on some platforms) utility. Invoke the utility without arguments to get a list of available parameters. Look at the following example: sqlldr scott/tiger control=loader.ctl This sample control file (loader.ctl) will load...

select customerId from <table> group by customerId having sum(order_amount) = 500 Hope it helps. Shantha. Talent is what you possess; genius is what possesses you