• Name of server my Oracle database is hosted on

    I'm in desperate need here for some help: How can I find the name of the actually server my Oracle database is hosted on? Thank you so much!!

    ITKE440,570 pointsBadges:
  • Oracle 10g forms and reports

    When I run an Oracle Report through report builder, the document name in the print job shows the file as .eps . This report is not getting printed from HP 4645 printer, but gets printed from canon, dotmatrix, Line printer and from other HP printers. Are .EPS files are not compatible with certain...

    lacchhii5 pointsBadges:
  • Export Oracle SQL Developer query to CSV file

    I'm currently using Oracle SQL Developer and I need to export one of my queries to a text file. I would like it to be a CSV file. But I'm not seeing any export options at all. Even double clicking on the query itself didn't work. What should I do here?

    ITKE440,570 pointsBadges:
  • Confirm what version the Oracle Database is in SQL

    My partner and I are currently creating an installer for a new application. Basically, a user gets to select a data source for their configuration -> nominate what database it is. But here's what we have to do: Basically make sure that the database is Oracle / the version too (this will be done...

    ITKE440,570 pointsBadges:
  • Fuzzy Oracle text string search

    When searching a string I need to fetch all the words present in the database from that string. e.g. " Today is very hot day", if I am having (Today/very/very hot/day/etc..) in my database, so this should fetch all the related results to that string.

    shubhanshusriv15 pointsBadges:
  • Mobile application development using Oracle MAF

    How can I do mobile application development using Oracle MAF?

    velukalur20 pointsBadges:
  • I am presently in Oracle apps Technical Consultant, If i learn OBIEE, what are the benifts to my future career? Is really it improves my career?

    Hi All,       I am currently in IT Industry as Oracle Apps Technical Consultant since last 3 years.       I have learn OBIEE (Admin and Presentations Services) and around 6 months work experiance in OBIEE (Admin and Presentation Services). Now, my confusion is is really help this way of...

    Prasadrm5 pointsBadges:
  • Free online practice exercises on SQL/Oracle

    I would like to know is there any website which offers free practice exercises on SQL/Oracle queries? Preferably advanced level queries. Thanks, Kruti

    Kpatel0 pointsBadges:
  • Search within all SAP ABAP code for a variable.

    I used a variable called - myvar. I am uncertain where all i have used it during the ABAP development. How can I search all ABAP code ever written in SAP for this variable? In other words, how can I search SAP ABAP code for a variable, key word etc. For example, in Oracle we had all_source,...

    gram7720 pointsBadges:
  • Is it safe and ‘recommend​ed’ to reclaim/sh​rink Oracle/sys​admin volumes in DOT 7 mode?

    We have created several flexvolumes such as 1 flex volume contains 1 qtree. these volumes are created in the similar way for oracle and Sys Admin's e.g oracle volume - /vol/oratla_data/oratla_data Sys Admin Volume - /vol/traces/traces These volumes are fully allocated volumes (not thin-provisioned)...

    curi0usV5 pointsBadges:
  • How to grow career as a CRM consultant

    Hi, I have started my career as a Oracle CRM consultant, currently working in sales cloud. I really want to know how is the market for CRM consultants and what courses or technologies would help in growing my career in CRM? Thanks Shweta

    shwetadixit95 pointsBadges:
  • Can we handle unstructured data with Oracle Enterprise Data Quality

    Is it possible to handle the unstructured data like videos or images in OEDQ?

    maddymk5 pointsBadges:
  • RAC patching: How to force sessions to connect to other node

    Hi experts, I have one query regarding applying a patch (interim,psu) in a 4 node RAC in rolling fashion. My question is while applying patch on one node I heard that we should down the instance and we will apply remaining nodes are up and running. At that time what happens about the running...

    sirajdba175 pointsBadges:
  • Help using oracle Analytical function.

    I am trying to create a query that will do two parallel select from the data available. I want to write one select statement using analytical functions, What I want to do is as follows: I one single query I want to find out the count of the transactions in the last 7 days from sysdate and last 6...

    Prativa0 pointsBadges:
  • Create a trigger to call a procedure

    HI, I am trying to create a trigger where is checks for a condition every time an insert or delete happens on the table and then calls a procedure. Any help is appreciated.PROCEDURE: ============ CREATE OR REPLACE PROCEDURE "GFMPNRT"."PP_CLEANUP_ALERTS_FOR_POC" (v_ACTION_LEVEL_KEY IN VARCHAR2,...

    Nagesh198540 pointsBadges:
  • Block SSH Authentication on Linux

    Scenario: We have multiple user in production server like Oracle, DatabaseUser.Concern: Because of a security concern, we don't want Oracle & DatabaseUser User to get SSH authentication. Who can we stop only specific user from SSH authentication? Is there any configuration change I need to make...

    NitinIND200 pointsBadges:
  • Running Oracle 10g form

    I can't get a form to run through the browser on my machine. I can compile ok, but when I run the form I get the "cant display page" error in IE. I have the listener running. What am I missing?

    Tdmcolumbus75 pointsBadges:
  • Receiving SQL error message: ORA-01722

    In Oracle / SQL, I keep getting an error message when I'm trying to an insert. Here's the message: ORA-01722: Invalid number error. What does that mean? What can I do about it? INSERT INTO CUSTOMER VALUES (1,'Michael','Claire','27 Smith St Caulfield','0419 853 694'); INSERT INTO CUSTOMER VALUES...

    ITKE440,570 pointsBadges:
  • How to get unique values from column without using Distinct keyword in Oracle?

    I have a table in which the column has duplicate values in it. If i need to get unique value from that column without using distinct keyword then what will be the query?

    Sheeldk5 pointsBadges:
  • Extract data from dmp-file without Oracle

    I need to extract data from a large ORACLE dmp-file (many users, many tables). My idea is to get in TXT or CSV. However, NXTract could not manage this because of the size (buffer overflow error). Is there any other tool out there that can help me...?

    ITKE440,570 pointsBadges:

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.

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