Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Shantha

    Need Help in Privileges

    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...
  2. Shantha

    Need Help in Privileges

    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...
  3. Shantha

    Oracle 8i to 10g

    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...
  4. Shantha

    Transpose Row to Column Values in a query

    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...
  5. Shantha

    Crystal Xcelsius Help Needed

    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...
  6. Shantha

    Help to frame select

    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
  7. Shantha

    Help to frame select

    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...
  8. Shantha

    Need Help in Table Design

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

    Need Help in Table Design

    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
  10. Shantha

    Need Help in Table Design

    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...
  11. Shantha

    Converting BLOB data to CLOB

    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
  12. Shantha

    Replace single quote with another character

    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...
  13. Shantha

    Pro*C sample file

    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...
  14. Shantha

    Importing CSV

    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...
  15. Shantha

    Sum of some Columns

    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
  16. Shantha

    Exception handling inside a function...

    The exception block should be written inside the for loop after your if condition. Once the exception occurs it will go to the exception handler and do the defined process in the handler and exits the function. Hope this helps. Talent is what you possess; genius is what possesses you
  17. Shantha

    java.lang.OutOfMemoryError while running xsql - URGENT

    Hi, I am getting Exception in thread &quot;main&quot; java.lang.OutOfMemoryError <<no stack trace available>> while running an xsql from the command line mode. I am using Apache/Jserv on Solaris. I also tried increasing the heap size in jserv.properties by setting # The Java Virtual Machine...
    • Shantha
    • Thread
    • Replies: 0
    • Forum: XML
  18. Shantha

    INDEXES

    Here is the one which i use http://download-west.oracle.com/otndoc/oracle9i/901_doc/server.901/a90125/statements_510.htm#SQLRF01209 Hope this helps. Talent is what you possess; genius is what possesses you
  19. Shantha

    .sql files

    I have done something similar to this in unix with shell script. say for example yr .sql script report.sql then in shell script u can give something like the following: sqlplus /nolog @report Hope this helps. Talent is what you possess; genius is what possesses you
  20. Shantha

    How to replace fields in files using AWK? - URGENT

    I need to replace field in one file with field in another file. File 1 111-000001 111-111111 222-222323 232-343333 File 2 111-000001,AER 111-111111,EXE 111-111111,AER 111-111111,EXE 222-222323,AER 232-343333,AER If you note file 1 - field 1 has same values as file2 field1 but in the place...
    • Shantha
    • Thread
    • Replies: 1
    • Forum: AWK

Part and Inventory Search

Back
Top