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
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
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
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
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 ()
Member Avatar
I have a oracle query and i would like to run it by powershell using ODP.Net. Below is the query. ... Problem is i can run single line query but when it comes like this i am getting error ORA-Error-00922. ...
by md.Rayad in Microsoft Windows ()
Member Avatar
I got a requirement. i have a tabular form with some records, for example i have a department table in a tabular form, if i check first record that means department 10 and then if i click any button we need to show the list of employees whose department is …
by SRISRISIVA in Web Development ()
Member Avatar
Im wondering to solve the given task but ended up in nothing.. Can someone help me on this !? ...
by srinidelite -4 in Databases ()
Member Avatar
Okay so let me start by saying I have a pretty decent c++ base and very advanced logic skills. So whatever help you will have to provide will probably be minimal. So here's my problem: I've been trying to figure out the best way to organize all my Magic: The …
by Seth_1 in Software Development ()
Member Avatar
im make program using vb6 n tried to get data from msaccess database ,display it in vb6 and save the data to oracle table database.. The table name in oracle is testcoba. Now i can save the data from vb6 to oracle table. But i want is the data will …
by Lance_1 in Software Development ()
Member Avatar
Hi guys. I am looking for a software tools that can analyse data from several sources like databases: Oracle,Mysql,Access,MsSql e.t.c and draw graphs,dashboards or other data visualisation objects. The software should also be able to read excel sheet and analyse the data and give output in variuos graphs/pie charts. It …
by mwenyenia07 -4 in Databases ()
Member Avatar
Hi, I am new in pl/sql programming and I need your help. I would like to make a procedure. To be more specific, I have tables like the folowing TABLE1 ================================================ |COL1 | COL2 | COL3 | COL4 | COL5 | COL6 |COL7| =============================================== |600 | 140 | 2 | …
by bufospro in Databases ()
Member Avatar
Hello, I am ... the data into table1 where c1 is new column and data is from table2. but c2 data type is ... and c1 datatype is ... . ` ... ... USER_NAME` column is from table2. Thank you.
by Azii in Databases ()