Member Avatar
Hello, I have to install Oracle Developer 2000 R2.1 on a Windows 8.1 (x64) machine to run an application developed by a third party developer, but my installation keeps on crashing. Tried running in Windows XP SP3 compatibility mode still same result. The error is as follows: "D2KQT10.ins(54): 'Statement' expected …
by lordrt 34 in Databases ()
Member Avatar
I just use this code to input data to oracle database from vb.net. ... when I run this code it give error: "ORA-00936- missing expression" Please help me
by සශික in Software Development ()
Member Avatar
Previously I used vb.net with mysql database and successfully added data from insert query. In that senario my sql code is like this : ... Now I used oracle database with vb.net. When I run program it shows: "ORA-00936 - Missing Expression" error. I don't know what is matter. But …
by සශික in Software Development ()
Member Avatar
Hi, I have installed Oracle 11g (latest version 11.2.0.1.0) on my system. During the installation it didnt ask me to set username or any password. I'm unable to start sql plus because i dont have the username and password. Can anyone tell me what is the default username and password …
by VenusCrystal in Databases ()
Member Avatar
heY guys, I just step to oracle database system. so I'm new to this. I'm trying to make connection oracle db with vb.net. I saw below connection string on web. But I dont know it's keywords. So please teach me. ...
by සශික in Software Development ()
Member Avatar
Hey, I have been reading Java oracle tutorials. I read this thing. Suppose, for example, class MsLunch has two instance fields, c1 and c2, that are never used together. All updates of these fields must be synchronized, but there's no reason to prevent an update of c1 from being interleaved …
by nitin1 15 in Software Development ()
Member Avatar
Hi Dw. Long time ago I think late last year my computer was infected and I had installed a VM from Oracle and had a number of OS(VMs) installed one of them was with Win7 but I don't know what happened one day, when I open the VM it was …
by Mr.M 32 in Software Development ()
Member Avatar
Hello, I have the below case. ... So, I want to insert into TM_TABLE_2.NITEMID the value of TM_TABLE_1.NID where TM_TABLE_2.NORDERCODE = TM_TABLE_1.NORDERCODE, keeping in mind that its possible to have more records inside TM_TABLE_1 than TM_TABLE_2 so I just want to insert NID's from TM_TABLE_1 into TM_TABLE for row's with …
by fo2sh -4 in Databases ()
Member Avatar
I got tired working on that part of code for 3 days and searching on the internet please I need help to know HOW TO use auto complete textbox1 and use its value to set the value of textbox2 and textbox3 below code ... Now my problem on the textbox1 …
by cusoon.777 in Programming ()
Member Avatar
Please explain to me what execution plans and index creation is in Oracle SQL. An example would be great also. Thank you!!
by Emily_3 in Databases ()
Member Avatar
I'm getting this (errorORA-00936: missing expression) when I input this into the sql commands: select || 'The promotion began on the' || to_char(start_date,'ddth')' of 'to_char(start_date,'Month YYYY') from f_promotional_menus where code=110; I tried googling for answers but came up with nothing. Can someone help me figure out what I am doing …
by Shantel in Databases ()
Member Avatar
Hello All, I am fairly new to Vb.net. I have experience in MS Access and VBA. I am trying to connect a remote Oracle Database through vb.net but getting the below error. But, the same Oracle database connecting with the help of SQL Developer. Can any one please help me? …
by ctrl+s in Programming ()
Member Avatar
I'm running xp pro with outlook express version 6. When I receive emails in the inbox and choose to delete them they just stay there. I can shift delete but just delete does nothing. When I right click and go delete that also doesn't work. Can you please assist. Thanks.
by LenardJoseph in Programming ()
Member Avatar
I wan to call oracle database function I tried this but i am getting error ... ...
by anamo in Software Development ()
Member Avatar
hi..... i am searching for the query for retrieving the deleted data from the table.From the web i got "flashback" method to get the dropped table.Any one has any idea pls,help me thanks in advance
by saideepak89 in Databases ()
Member Avatar
I'm working on shopping mobile application. The application is similar to ebay it have customer and seller. When user create account they can either create account as seller or customer. The payment will be by paypal each user need to provide their paypal account (Seller Paypal & customer PayPal) so …
by luckyme_ in Databases ()
Member Avatar
I have tried to display the names of table in oracle database in visual studio 2012 in combo box but i am not sure why it is not displaying ...
by Nareen in Programming ()
Member Avatar
<select id="keyEquipmentShiftAutomatedModelData" parameterType="java.util.Map" resultType="java.util.Map"> SELECT ID, SUM(VALUE1 + VALUE2) Total FROM tableName GROUP BY ID </select> ...
by Siddharth_6 in Programming ()
Member Avatar
Hi, Can you guys reccomend me some good oracle sql journals? Thanks
by Mohamed_26 in Databases ()
Member Avatar
Hello, What are the different areas of databases I can focus on for my project? Thanks,
by Mohamed_26 in Databases ()
Member Avatar
Hi all, If I have two table of cod-desc, T1 and T2, and I need to create all possible combination, other than using cartesian product, is there another way more optimal to do that? Suppose every table has 1M rows. RDBMS= Oracle 11G. Thanks sandro
by sangi1981 in Databases ()
Member Avatar
Help me :) I want to display the text file in JTextArea but how ? and i want to attach this is searching button.
by Mark Louie in Programming ()
Member Avatar
FROM: ORACLE 9i Give the SQL statements that determine the following: Which customers lives in New Jersey? SELECT * customer FROM customers WHERE state = 'NJ' 2.Which orders were shipped after April 1, 2003 SELECT * FROM orders WHERE shipdate to_date('01/04/2003', DD/MM/YYYY') Which books are not in Fitness Category? SELECT …
by butterflyTee in Databases ()
Member Avatar
Hi I have written a procedure in PL/SQL to get values from user and then I am updating the same in a table. This worked fine 1st time but its just not showing the new values inserted by the user. The field which should be updated with the user value …
by yash_792 in Databases ()
Member Avatar
Hi! Just want to ask if it's possible that within a select statement, there has a loop. Have this sample query but when I run this it says missing expression after <column2> ...
by Venus_1 in Databases ()
Member Avatar
I need some help with creating a simple search engine for website. Basic idea is that user will enter a string in search bar, which will compare in database key_word and get the reuslts. Lets say I have the following table on sql server database. ... Now in search bar, …
by hwoarang69 11 in Databases ()
Member Avatar
I am using CodeIgnitor and oracle db at model ... At controller ...
by ita_info in Web Development ()
Member Avatar
hi all, I m developing a software in vb6 as front end and oracle 11g as backend (i.e. as database) I have desinged some reports with oracle reports builder, how i can call in vb6 program/how to add the oracle reports in vb6 programe. Thanks in advance for help.
by M.I.Sahil in Software Development ()
Member Avatar
We have a WCF web service hosted on Windows 2008 SP2/IIS 7 accessing an Oracle database. Usually data access works fine but during load testing, it often times out and logs an exception saying: ... To query the database, we use something like this: ... I am pretty confident that …
by ddas in Databases ()
Member Avatar
list details of the departments in which the average salary of the employees is the lowest .
by sajay6679 in Databases ()