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
<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 ()
Member Avatar
Hi I got this error ORA-01403 "no data found" and ORA-06512: at line 8 however I'm sure that there is date in my table dept!!! ...
by tony75 10 in Databases ()
Member Avatar
Hi group, I'm getting an "single-row subquery returns more than one row" error when running my routine. Looking through the table I'm querying, it is listing a date twice for some reason. Since I'm not able to remove this one row, is there a way to return the first instance …
by doncwilson_1 16 in Databases ()
Member Avatar
Hi Why I got error ? ...
by tony75 10 in Databases ()
Member Avatar
Member Avatar
Hi What my misstake? I got error whwn I run my code! ...
by tony75 10 in Databases ()
Member Avatar
can any one help to find out how to create a oracle app using oracle express edition 10g
by Vekariya in Databases ()
Member Avatar
Hello group, I've decided I want to take some classes in SQL, to better understand how to write queries. In looking online for where to turn to for this kind of training, I also see classes to prep for certification. I'm curious of what the value to my employer would …
by doncwilson_1 16 in Databases ()
Member Avatar
Group, I'm extracting some month and year values from dates. I need to ensure they are NUMBERS as I'm going to multiply, add and subtract. I'm assuming I need to DECLARE these as NUMBERs. However I'm not sure how to do this correctly as I'm getting errors preventing me to …
by doncwilson_1 16 in Databases ()