1,488 Topics
 | |
| | I want to find duplicate names from my database I wrote the following query. But it is displaying more that existing records. I guess it is taking cartesian product. select a.name from emp from emp a,emp b where a.name=b.name; can anyone correct this query. I want to display all the … |
| | hi i am looking for a jiob as a junior Oracle DBA can any one please advice me on how to get an Oracle DBA job. i have beeen looking for where to startup my career but everywhere i go to they are asking for 3 or more years real-time … |
| | Hello everyone I need a solution for my problem. The solution can be a simple PL/SQL block or a trigger I have a table called T_SBSTTN_VLTG_MSTR with following data SBSTTN_CD VLTG STTS DT_ENTRY FK_TM_ID 10111111 11 Existing 2/9/2009 19:32 10144 10111111 33 Existing 2/9/2009 19:32 10144 10111111 132 Existing 2/9/2009 …  |
| | Hi, Could someone please tell me how to get all the tables in one program/file so that i can run them as one. Please very important..thank you |
| | Hi, All. Actually i m creating a program using C# which connects to the database (oracle) and checks for the given table "OPC_GROUP". if the table doesnt exists then it creates the table else it updates all field with provided values I used following command to query [CODE]cmd.CommandText = "SELECT … |
| | I want to write an sql statement in c# where I want to pass a "true" or "false" value basing on some condition... can we pass true to sql statements Ex: [CODE]select * from emp where (empid=1234 and true); select * from emp where (empid=1234 and false); [/CODE] This true … |
| | I am new to Oracle and SQL. I need to write a select statement for a student extract at a college. For ex: select ss_id from id_table This will return all id's from this table and they are a length of 9 digits, i need to return just the last … |
| | I have two tables, say t1 and t2. t1{ txn_id varchar status varchar } t2{ txn_id varchar date Date } I want to built an update query which will update t1.status='X' with join condition t1.txn_id = t2.txn_id and t2.date < sysdate. Please let me to build an update query. |
| | i ve 1 table named 'A',it contains many attributes in 1 attribute the values are stored like this [COLOR="Red"]"Q108:5380;Q208:5380"[/COLOR] this data present in table 'A' should be entered in table named 'B' in two fields named B1,B2 as B1 B2 Q108 5380 Q208 5380 like this in two columns this … |
| | I am doing the following report. Write a report for a large bank on the benefits that cloud computing can bring to their database system (Oracle). Could anyone tell me I can find informaion to help me do this report?  |
| | Hi Guys I have designed reports in Discoverer Plus and the users are viewing the report using viewer. My need is that suppose there is a report which is made. Now if some user views the report by changing the layout and save the changes. Now problem is the change … |
| | Sir, I have developed an application in VB6.0 and back end as ORACLE8i . I would like to know how to "Deploy" it OR How do my application detect my Oracle dB automatically? |
| | I'm getting the following exception "ORA-24960: the attribute OCI_ATTR_USERNAME is greater than the maximum allowable length of 255" when using Environment:createConnection. I'm using VisualC++ 8.0 and Oracle 10g R 10.2.0. Below is the snippet of code that creates the problem:[code] #include <iostream> #include<occi.h> using namespace oracle:cci; using namespace std; try{ …  |
| | Your web based ordering should work as follows: 1. Authorized customer must be able to place his online orders. 2. Authorized customer MUST log in first before making any transaction. If the login is invalid the customer access is denied and a message is displayed to the customer “ACCESS DENIED” …  |
| | hello! How can I display if the query results more than one value? For example, how can I do a query that produces all pairs of salespeople who are living in the same city. Thanks in advance. |
| | Hi all, I need some favor from u all regarding to connect remote oracle databae via network using vb.net......for info as below:- IP server : 172.19.30.10 Database name : minedb user : own Password : ownmy Please help me...thank you  |
| | Hi folks, I want to access Oracle 9i table "emp" in Java... I do not know what driver to use .. The name of the Oracle database under which "emp" falls is "Oracledb" I do not know what the connection string is? Pls help... |
| | Hello everyone. Happy New Year. correct coding for connectivity of oracle database with VB 6 or VB.Net Thanks |
| | hi, any help will be appreciated. I use Oracle discoverer plus. recently I tried to build a running total (average) calculation using the template provided. I defined 10 previous observations for this purpose. discoverer performed the calculation but the problem is with the first 9 (in this case) observations of … |
 | Sorry for the simple question... But please i need help from you guys... How to import and export the database in oracle..iam have been using oracle 8i in my computer... im completely new to this environment... please help on this.. Thanks in advance... Shanti. |
| | In oracle 9i ........How to delete duplicate entries in a table ? if suppose in a table named office, one or more entry(row) is repeated more then twice or minimum twice. I need a query to delete the multiple entries .... Note: --->No constraints applied on the table. --->No Primary … |
| | |
| | i want to get the [COLOR="Red"]ROLE [/COLOR]of an user by entering the username and password in login form.... for example:: username password role ramesh xxxxxxx manager loginform:: enter username: enter password: [U]plllllzzzzz any one post the required query of the above problem[/U] |
| | hi all, can some one help me how to display the fields which enter in current week,current month like that  |
| | Hello guys, Just need to know - wats making oracle to stuck when i run this simple pl-sql module declare counter number; begin <<outer>> for counter in 1..10 loop <<inner>> loop insert into lines values(counter); exit when counter=6 or counter=8; end loop inner; end loop outer; end; / |
 | [B]Can someone let me know how the date syntax work. example working with "greatest" 01-oct-02 and 20-may-2003, it accept 20-may-2003 to be the greatest instead of 01-oct-02 which the oldest (greatest) can someone explain this to me. please let me know the logic behind. I have alot of problems with … |
| | status teacher build exam (question and answer) and student take the exam form build_pre_exam add data into pre_exam table when form run , user(teacher ) have to insert question and four cooses then choose from list item which one i correct answer (to enable to check exam for student) ,after … |
| | Hi, Can anyone help me how to retrieve data from table in the following manner. In my application I have five button namely First,last,next,previous,and Query. When I will press the query button, it should show me last data that I had feed to the table. When I press first button … |
| | I am doing a project using oracle10g XE and JSP. Here i am using a table where data type of a field is autonumber. It is working fine when i insert or update record. but it does not continue its sequence when i delete a record. For example i have … |
 | Does anyone know how Oracle's PL/SQL handles subtraction with a negative number? Really what I need to know is, given the following: (NOTE: this is NOT the code I'm working with. It's just an example to give and idea of what I'm trying to do.) [CODE] DECLARE number1 NUMBER; number2 … |
The End.