• RDBMS and DBMS in Oracle

    What is RDBMS and DBMS in Oracle?

    Gkg5 pointsBadges:
  • ORA-01009: Missing mandatory parameter

    Dear Friends I have this script in the WHEN-BUTTON-PRESSED Button DECLARE LOC_FLAG NUMBER; BEGIN :IM_NEW_ITEMS.COLOR_CODE := TO_CHAR(NVL(:IM_NEW_ITEMS.COLOR_CODE,0)); :IM_NEW_ITEMS.SHAPE_CODE := TO_CHAR(NVL(:IM_NEW_ITEMS.SHAPE_CODE,0)); SELECT NVL(FIN_FLAG,0) INTO LOC_FLAG FROM IM_CLASS WHERE...

    MAY05659292714120 pointsBadges:
  • Connect database from Oracle to VB 6.0 in SQL Server

    I'm a BCA student. I'm doing my project on college management system with VB 6.0. I want to know how to connect a database from Oracle to VB 6.0 in a SQL Server. Thanks!

    eliza72472fathima5 pointsBadges:
  • Cache Oracle tables in a NetApp cache

    Sysadmins say our Oracle databases are using virtually none of the 512GB NetApp cache. Is there a way to cache Oracle tables in the NetApp cache similar to the Oracle keep pool?

    royaldbaness5 pointsBadges:
  • UPSERT in Oracle table

    Is there a way to UPSERT in Oracle (so I can insert either / or update a row into a table? I thought Oracle doesn't have that statement so I'm not sure the best way to do it. Thank you.

    ITKE366,630 pointsBadges:
  • Current Example does not handle duplicate Value 1 population

    IF we take the same example and Ray has a 2 rows where Value 1 is populated. Max will return only 1 row.....how do you collapese the rows so that both values retained for Ray and perhaps take it further align the similar values. Asuming that all of these rows belong to 1 FK

    sabinasql5 pointsBadges:
  • Make copy of an Oracle table without the data

    Anyone know how to make a copy of an Oracle table without actually copying the data? I figured out this statement: create table xyz_new as select * from xyz; But that only copies the structure / data. I just want the structure. Thanks!

    ITKE366,630 pointsBadges:
  • SAP Crystal Report 2013’s compatibility with Oracle 8i

    Is Oracle 8i still capable with the new versions of Crystal Report (E.G: 2013?)

    BillYuAtbcs5 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:
  • How can I become a DBA?

    I'm in a 2nd year CS engineering student and want to be a DBA. How shall I proceed?

    HritikaMehta5 pointsBadges:
  • Oracle 11G database installation error

    I am new to Oracle database. While trying to install the database software, I get: DIM-00019: create service error ORA-12560: TNS:protocol adapter error I have been trying for a long time to install the database but cannot. How do I install the database?

    prashantmishra29015 pointsBadges:
  • AUTO_INCREMENT in Oracle 11g

    I might have missed something but, in Oracle, is there no concept of AUTO_INCREMENT? If there isn't, is there a way to create a column that resembles AUTO_INCREMENT in Oracle 11g?

    ITKE366,630 pointsBadges:
  • How to use POS.NET for a BARCODE SCANNER in a VB.NET application

    Hi! I have an old office project... Its Point of sale software built in VB.net over oracle db express edition. Its really cool but lucks the barcode scanner functionality. Some customers are demading for that functionality.....bla bla bla!!!  ...Devices I've programmed 4 in the past usually comes...

    49cubes45 pointsBadges:
  • Learn to use SQL queries

    I'm a beginner in computer science so how can I make grip on Oracle SQL Plus. Is there any website or any electronic book that contains preset queries on SQL which can help me in working in SQL. I want a guide book which has queries to start and work in SQL Plus and developer.

    Yasir oracle5 pointsBadges:
  • Duplicate values in an Oracle database

    Is there a SQL statement that would return duplicate values for a given column / count of their occurrences in an Oracle database? Thank you very much.

    ITKE366,630 pointsBadges:
  • How to validate user parameters in Oracle Reports 6i?

    Hi! I am using Oracle reports 6i to modify a standard report. I need to add two user parameters and a field retrieved should be between them if they are not left blank. If they are left blank, then, they should not be taken into consideration. My problem is: These two parameters are included in my...

    Nafy5 pointsBadges:
  • Oracle Development or Oracle JDevelopment?

    Which course is best for my career: Oracle Development or Oracle JDevelopment? Please help me.

    waqar00135 pointsBadges:
  • What is Oracle Sphere?

    I have been tasked to find out about the product Oracle Sphere. What is Oracle Sphere? Is this a combination of products because am unable to find this name on the oracle website. Please advise.

    kabwalya5 pointsBadges:
  • Oracle: Getting list of all tables

    In an Oracle database, is there a query that would display the name of all the tables in it? Thanks so much!

    ITKE366,630 pointsBadges:
  • How to uninstall OracleserviceXE

    I am trying to install a new version of Oracle 10g. I thought that I had uninstalled the previous version but whatever I do I get the message "OracleServiceXE is present on the system". How can I fix this please? Des

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

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