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

    ITKE372,465 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!

    ITKE372,465 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?

    ITKE372,465 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.

    ITKE372,465 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!

    ITKE372,465 pointsBadges:
  • PL/SQL – How to make a check whether the attribute is positive or zero

    Hi Experts, How to make a check on attribute(NUMBER) is positive or zero?

    Inprise610 pointsBadges:
  • Roadmap for Oracle database

    Hello, Can you tell me where I can the roadmap for Oracle Client and Oracle database? Thank you!

    ablouin5 pointsBadges:
  • Display date in Oracle Toad

    How to display all the months between two dates. My fromdate format is 'mon-yyyy' and todate format is 'dd-mon-yyyy'. Please suggest.

    Deb4u50 pointsBadges:
  • To show two columns using select syntax in Oracle 11g referring another column in same table

    Hi everyone, I really need help on one thing. Suppose I have a table employee and there are many columns and three of them are empno, ename and managerno(of employees) and o want to show results using select syntax and the managerno contains the empno of employees and I want to show ename and (a...

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