• How do I check the maximum number of connections in an Oracle database?

    Would be the best way, using SQL, to actually check the maximum number of connections that are allowed in an Oracle database. I need it to show the current number of sessions and the total number allowed. Appreciate any help.

    ITKE347,785 pointsBadges:
  • PL/SQL: How to check address NOT NULL but can take -(hyphen) instead being NULL

    Hi Experts, How can we make a check on an attribute not null but can take - rather I have address 3 which can't take null instead - would be fine how this can be check n PL/SQL procedure I can check IF address 3 IS NULL THEN ... END IF But i want to test with test case tat it can't take NULL but...

    Inprise610 pointsBadges:
  • How to load an Excel spreadsheet to an Oracle database

    Does anyone know of a free tool that I can use to load an Excel spreadsheet into a Oracle database? I already tried Oracle SQL developer but it keeps giving me a NullPointerException. Can someone help me out there?

    ITKE347,785 pointsBadges:
  • about oracle with Java

    What is future of Oracle with Java regarding jobs for freshers and distance learners. Why I am asking this because I am learning oracle from SQL star tutorial in delhi and doing MCA from Sikkim Manipal University in distance learning.

    Qqqq10 pointsBadges:
  • What do the quotation marks around the table name do in Oracle?

    In Oracle, I need to know what exactly do the quotation marks around the table name do. I thought it was for some grouping marker but I was doing some debugging on a Hibernate code, I noticed this: SELECT * FROM site WHERE site_id = 3; That works fine but this code doesn't: SELECT * FROM "site"...

    ITKE347,785 pointsBadges:
  • Performing a multi-row insert into Oracle 9

    I've been trying to find the easiest way to perform multi-row inserts into our Oracle database (it's Oracle 9). This code has been working for me in MySQL but it's not working in Oracle: INSERT INTO TMP_DIM_EXCH_RT (EXCH_WH_KEY, EXCH_NAT_KEY, EXCH_DATE, EXCH_RATE, FROM_CURCY_CD, TO_CURCY_CD,...

    ITKE347,785 pointsBadges:
  • How to create a command list of values in Oracle

    I've been trying to convert a single-columned subquery into a command-separated VARCHAR typed list of values. I understand how to do it on SQL Server but now I need to do it on Oracle. Can someone help me?

    ITKE347,785 pointsBadges:
  • apex or html.db freeware

    Where can I download Oracle freeware apex or html.db from?

    Bditchbu5 pointsBadges:
  • Installing Oracle on Windows 7

    How to install Oracle in Windows 7 home basic?

    966261873120 pointsBadges:
  • Importing a CSV file to an Oracle table

    We currently have a CSV file that we would like to import into an Oracle table. After it's loaded in, we're going to use the table for another use. Can this be done using SQLPLUS? Thank you very much.

    ITKE347,785 pointsBadges:
  • What’s the easiest way to move data from SQL Server to Oracle?

    I'm an Oracle newbie so I apologize for the general question but what's the easiest way to move a data table from SQL Server to Oracle on a regular basis? My friend told me to SSIS. Is that the best way? Thanks!

    ITKE347,785 pointsBadges:
  • How do I solve the ORA-00933: SQL command not properly ended error message?

    For the past few weeks, I've been using an OLEDB provider for ADO.NET connecting to an Oracle database. Currently in my loop, I'm doing this insert: insert into ps_tl_compleave_tbl values('2626899', 0, TO_DATE('01/01/2002', 'MM/DD/YYYY'), 'LTKN', 'LTKN', '52', TO_DATE('01/01/2002', 'MM/DD/YYYY'),...

    ITKE347,785 pointsBadges:
  • Database Oracle

    Hi, how do I create a database in Oracle 9 and link the database in SQL Server 2000

    Berouty3020 pointsBadges:
  • How can I create a user in Oracle 11g?

    I need some help! I'm trying to create a user in Oracle 11g and only grant them the ability to execute one stored procedure, along with the tables in the procedure. Is that possible? If so, what's the process to do it?

    ITKE347,785 pointsBadges:
  • install oracle developer suite 10g in windows

    without oracle database can i install oracle developer suite 10g in windows

    A15 pointsBadges:
  • How can I get the last row of a table in an Oracle database?

    I have an Oracle 11g Express database and I'm having trouble getting the last row in one of my tables. Can anybody help me with this? Thanks so much.

    ITKE347,785 pointsBadges:
  • Apache Maven support for Oracle JDeveloper?

    What options are available for Apache Maven integration with Oracle JDeveloper? Moderator Note: This is a submitted question.

    BrentSheets6,925 pointsBadges:
  • What’s the easiest way to test an Oracle stored procedure?

    We've been working on an ASP.NET project that's using an Oracle database. We've been using TOAD to add and manage stored procedures. This is where the problem lies....we're having too much trouble testing an Oracle stored procedure. Here's an example of one of our stored procedures: CREATE OR...

    ITKE347,785 pointsBadges:
  • Can I load data from a txt file to an Oracle table?

    I'm pretty new to Oracle so I have two big questions: Would there be a way to load data, from a .txt. file, to a table in Oracle not using SQL Loader? Just the opposite...can I unload the data from the table to a .txt file? Thanks so much!

    ITKE347,785 pointsBadges:
  • How to remove duplicate rows from an Oracle table

    I've been doing some testing in Oracle and just populated a table with some sample data. But, by accident, I loaded several duplicate records into as well so I can't create a primary key using some of the columns. Is there a way for me to delete all the duplicate rows and leave just one of them?

    ITKE347,785 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