1,488 Topics
 | |
 | I have problem with jinitiator. I am using Oracle ERP forms which runs on Jinitiator.When I access some other java applet application at the same time it runs in the JRE in and works fine. When I pass the same java applet application in ERP through a link , I …  |
| | Hi, I am looking to store files into Blob in oracle table. Like .pdf .doc .xls .jpg etc. Please help me on this. Regards, Kavitha Kesav |
 | 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 ? |
 | Hi Friends, I am working as a programmer in one bangalore based software company, interested to get some freelancing website projects. Plz suggest any firm that provides projects(software development & website development) to work from anywhere or any site that i can get freelancing work to do. I can handle … |
| | 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 would like to know how much does it cost for a website that handles about 100.000 active users simultaneously.. I mean what are the specific prices / costs for a VPS server and a Database ? |
| | 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 Sir I Want to Know about Database connection at runtime using tnsnames.ora  |
| | Could you give me some sample code, which was succesfully used before, which contains connecting and taking multi rows result sets via ODBC from Oracle? If you don't have sample code, which books will must be read by me, to rich the best result? |
| | 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 … |
| | Dear All, I am trying to understand RMI Concept and have tried the sample steps and programs written in Oracle website [http://docs.oracle.com/javase/tutorial/rmi/compiling.html](null) In this URL they have mentioned to run the command as below javac -cp c:\home\jones\public_html\classes\compute.jar client\ComputePi.java client\Pi.java mkdir c:\home\jones\public_html\classes\client cp client\Pi.class c:\home\jones\public_html\classes\client I have tried the exact command … |
| | 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 |
 | How do I retrieve image saved as a blob from oracle database please kindly help out.  |
The End.