1,135 Topics
 | |
| | Hi, I am a student who is taking a Database course. I am running Windows 7 on a laptop with 4GB RAM. I would like your advice on what software to download on my laptop so as to be able to practice concepts taught in class. Since I am a …  |
 | I'm stuck on this problem any one know the answer. **Write a query that displays the grade of all employees based on the value of the column JOB, as per the table shown below. Order the result according to the grade! ** JOB GRADE PRESIDENT A MANAGER B ANALYST C … |
| | Hello, So shortly I am receiving an SQL Error: ORA-00932: inconsistent datatypes: expected NUMBER got OE.CUST_ADDRESS_TYP 00932. 00000 - "inconsistent datatypes: expected %s got %s" when I am trying to retrieve a part of a string data. SELECT dbms_lob.SUBSTR(cus.cust_address, 0, INSTR(cus.cust_address, ',')-1) AS output FROM oe.customers cus; So basically that's … |
| | hey.. Guys can you tell me by default password for this setup oracle 11g home . bcoz of when i was installed that time didn't asked any user and password information . please anyone can help me . but i'm trying deafult user those above said article system/orale and system/system … |
 | I want to read data from database. the data is in arabic language. the character set of my database is AL32UTF8. when i try to retrive the data i get "????" please do reply how to solve this problem this is the code public static void main(String[] args) { // …  |
| | (SQL , PL/SQL) enough for searching jobs in ORACLE ? i have 2.6 years exp with oracle sql, plsql . can i get better JOB ? |
| | i created a pl/sql program in which i want to take multiple inputs from user.. i wrote that n:=&n; in a loop ,i though it will take,but its not working... is there any way to take multiple inputs from user in oracle???? |
| | Can We write a stored proceudre that can generate session id uniquely??? is there any concept in oracle that can generate any ids unique??? can we use sequences??? pls help me... |
| | I wrote a sample program in notepad begin dbms_output.put_line('welcome'); end; / and saved it as p1.sql i opened sql prompt and gave @p1 it didnt worked??? i tried exec p1; still not working?? how to execute a pl/sql program???pls help |
| | Hey every body , Just need a bit of help with a problem understanding something. When I install Oralce onto a computer what are the default tablespaces and their role in the whole thing. What information is held in the DATA_DICTIONARY for examining tablespaces and their status? Is my second … |
| | 1. I have heard that database is measured in blocks...My question is how the database stores the data in memory device.What it follows to store an entire record??whether each field is stored in different locations or in adjacent locations??? 2. The data is stored in a file called data file..Do … |
| | Hi, I'm getting the following error "" for the query as shown below. Any help is very much appreciated. SET SERVEROUTPUT ON; DECLARE v_CARE_COUNT NUMBER := 0; v_PHONE VARCHAr2(40) := NULL; BEGIN select count(distinct care_level) into v_CARE_COUNT from Table1 where user_id = '100'; IF(v_CARE_COUNT > 0) THEN select phone into …  |
| | hi all, I need one help.i want to give OCA exam the name and number of exam is "1Z0-047 Oracle Database SQL Expert" these is for "10g".But i don't have any material for that.please send me the material for that. only i know the exam topics which i am send …  |
| | I had c# application that has registration form and another from that user use to sigin in into my application i wonder how to check if user its register or not my login form has to textbox username and passpwrd and im trying this code i gusse its wrong can … |
| | Hi Everyone, Just joined the community and wanted to share a quick "how-to" for anyone experiencing errors when setting up Oracle GoldenGate's archive settings. The default configuration of an Oracle database created with DBCA is to allow archiving to follow default settings. This in essence sets the log archive location … |
 | Hi there I got a little problem with a small bit of code am unfamiliar with orcale database the scripts I have were done by a other person for version 6/7 am currently using version 8i for compatibley reasons with the server software I am currently setting up. the script … |
| | hi all I had make this samll method to insert data from c# forms into my oracle database the code processed fine but when I go to sql developers software to check if the record has been inserted or not I found nothing... so whats wrong with it please thanks … |
| | I installed oracle 11g R2 on centos 6.4 and it was successful. However, If I am not on LAN(Local Area Network), then it does not start properly i.e the TNS fails. During installation, There is no where I specified IP Address;yet, it can only work when I plug network cable. … |
| | We have ERP application that store the data to ORACLE database and also we have a lot of another web applications that use the ERP database. We got the performance issues when ERP and another application use the same database. We are planning to do mirroring of oracle database into … |
| | After installing Oracle 8.06 on Windows XP (Pentium (R) D CPU 3.2GHz 3.20GHz - 480 MB RAM). I'm Attempting to run "Oracle Net8 Easy Config" when error comes up saying "jre.exe has encountered a problem and needs to close.." I tried: -Doing a system restore and installed it again (after … |
 | i want block of code,, that deletes data from different table concurrently,, so that i can save time |
| | Hello people, I declared a field in my table : [B]my_field VARCHAR(20)[/B], but I don't want it to contain any number: can you tell me how I can do that using a trigger or using a constraint ? Thank you in advance for any help |
| | |
| | hey all I just need someone who can explian to me what the ESCAPE keyword does here ?? nd what the deference if I remove it ?? SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA\_%' ESCAPE ''; note working on the sample database SQL developers  |
| | how to configure oracle datasource in jboss 5.0 ?? and then how can I use this datasource in hibernate.cfg.xml file to make connection to the database ? |
| | hey all Im using SQL Developers version 1.1.3 and I want to totally remove it I sareched alot about an offical way to remove it but I found veryone remove its folder so I go though it but now when I want to install the software agian... I am getting … |
| | hi all i want to execute sql loader in windows 7 but i get this error :\Users\Admin>sqlldr access_dept1/access_dept1 control=G:\data1.ctl; SQL*Loader: Release 11.2.0.1.0 - Production on Fri Sep 27 19:11:51 2013 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. SQL*Loader-500: Unable to open file (G:\data1.ctl;) SQL*Loader-553: file not … |
| | I install orecal 9i but it require user id and password... i try scott/tiger system/manager sys/change_on_install but it not working plz solve this problem immedetly.... |
| | hi all i want to insert 110 million record in oracle database but i am using java application to insert the data but it takes 4 days to complete i check the program to see if there is a problem but what i found that the insert to the database … |
| | Guy...please help, I'm running Sql plus 9.... Can u guys help me with the host string? |
The End.