1,135 Topics
| |
I just tried to install IIg on my laptop. It seems to have worked, but there were issues. The program couldn't find several files during the install process, but still seems to have worked. What did not was the config part where it looked for a template file. I had … | |
I have the following code for connecting to an Oracle DB [code] using Oracle.DataAccess.Client; // C# ODP.NET Oracle managed provider OraDb= (DESCRIPTION= (ADDRESS_LIST= (ADDRESS=(PROTOCOL=TCP)(HOST=ORASRVR)(PORT=1521)) ) (CONNECT_DATA= (SERVER=DEDICATED) (SERVICE_NAME=ORCL) ) ) string oradb = "Data Source=//192.168.100.108;User Id=hr;Password=hr;"; // C# string oradb = "Data Source=(DESCRIPTION=" + "(ADDRESS=(PROTOCOL=TCP)(HOST=ORASRVR)(PORT=1521))" + "(CONNECT_DATA=(SERVICE_NAME=ORCL)));" + "User Id=hr;Password=hr;"; … | |
please convert this below query to plsql format select (select count(*) from cadastredefunct t where t.areacode= 'PTH01' AND T.SECTIONNUMBER = 'D' and t.defunctnumber <> 'ONGD') as total, (select count(*) from cadastredefunct t where t.areacode = 'PTH01' AND T.SECTIONNUMBER = 'D' and t.status = 'COMP' and t.defunctnumber <> 'ONGD') as completed, … | |
I'm trying to create a table in oracle here's the code [code] drop table class; create table class (schedule_num integer primary key not null, semester varchar(10), course_name varchar(14), credit int, department varchar(15), /* meeting_time time,*/ meeting_place varchar(20), enrollment_limit int); [/code] I don't how to initiate the 'time' data-type, can someone … | |
i want to find records between two dates IN ORCALE but the table field values is in "mm/dd/yy hh:mm::ss" and data type is varchar2 The query which i was trying was: [CODE] SELECT * FROM NEW_OUTPUT_UPLOAD_TSN WHERE OUTPUT_UPLOAD_DATE BETWEEN TO_DATE('01/13/2008 18:45:19','MM/DD/YYYY 24HH:MI:SS') AND TO_DATE('01/13/2008 18:45:19','MM/DD/YYYY 24HH:MI:SS') [/CODE] | |
Hi I just installed Oracle 11g R2 on my Win 7 Ultimate x86 machine in compatibility mode (XP SP3). It showed that the setup completed successfully (without a single error & warning, I got few when I ran it in Win 7 without compatibility mode enabled.). Now I am trying … | |
Hi, I installed wamp server and oracle 9i ,both are running . Oracle having user id,password and host string , using these how can I connect to retrieve data from Oracle ? thanks in advance , very urgent Subrata | |
Hi, I'm having a data base which looks like this patient(pk_id)--(fk_pat)appointment(fk_doc)--(pk_id)doctor(fk_spe)---(pk_id)specialty The goal is to select all the patients which had an appointment with a doctor with 'dentist' speciality. I made 2 requests, one is correct and the other is incorrect correct one: [CODE] select distinct patient.name from pataient, appointment, … | |
Hello. I've got an exaple data base for hr account from Oracle. My goal is to create a view which contains empno,ename and deptno from EMP, but than i can only add rows with condition deptno=20. I've cameup with [CODE] create or replace view d20emp as select empno as num, … | |
Good Morning, I need some example with SQL plus code on various SET operation. But the query have to be with SELECT keyword. For example I am giving a code: [CODE]Create table student (s_id number(4), sname varchar2(10),constraint pk_sid primary key (s_id),blood_gp varchar2(4)); create table location(l_id number(4),location varchar2(20),constraint pk_lid primary key(l_id)); … | |
Hellow. I have 3 variables 1. string query; 2. public static OracleCommand oracmd; 3. public static OracleDataReader reader; I have used these variables in a function [CODE=C#] . . . public void PreviousValue() { query = " select * from....... "; oracmd = new OracleCommand(); .... .... reader = oracmd.ExecuteReader(); … | |
How should I use SQL loader to load a .csv file as an Oracle Database ? [CODE] CREATE TABLE products( ProductID INTEGER NOT NULL, ProductName CHAR(30) NOT NULL, SupplierID INTEGER, CategoryID INTEGER, QuantityPerUnit CHAR(30) NOT NULL, UnitPrice INTEGER NOT NULL, UnitsInStock INTEGER NOT NULL, UnitsOnOrder INTEGER NOT NULL, ReorderLevel INTEGER … | |
hello all My question is, At, the server side i m using 10 G and at the client side i m using 9i when i use export utility then it create the dump file but when i try to import it then my command prompt doesnt show any progress of … | |
Hello All, I have a sorta unusual problem (not too sure where to post it either), it goes like this: I am currently using MS Visio 2007 to Reverse Engineer some tables in an Oracle database, MS Visio lists the tables using unprintable characters (lots of little squares). Because of … | |
i want to know tht how to overwrite data(Tables) with existing tables in oracle database. first i imported some tables using .dmp file then some table_names was in tht .dmp file. then again i run tht import command with tht same syntax now tht showing some tables are already exist … | |
Hi Guys, I have imported a CSV file into the database and i want to write some functions to ensure that when data is loaded in that all spaces are removed from certain columns. For Example: In the Phone No column the numbers can appear as follows 07712345678 077 1234 … | |
Hi i'm a newbie in pl/sql and i need some help from the experts. I'm a vb programmer. Just want to ask you how do you do this in pl/sql? If I log in on my account my username should appear in a textbox. From this LoginForm I have 2 … | |
I am having problem in connecting Oracle to Netbeans. I am using Oracle 10g EE 10.2.0.3.0 and NetBeans 6.9. I have attached an image that will explain the problem. Please help! Thanx | |
[CODE] CREATE TABLE Query3Ans( dname char(20) ); CREATE VIEW deptNonPhDs(dept, numNonPhDs) AS SELECT dcode AS dept, count(*) AS numNonPhDs FROM instructor WHERE idegree != 'PhD' GROUP BY dcode; INSERT INTO Query3Ans( SELECT d.dname FROM deptNonPhDs dp1, department d WHERE dp1.numNonPhDs >= (select max(dp2.numNonPhDs) FROM deptNonPhDs dp2) AND dp1.dept=d.dcode ); select … | |
Hi everyone!!! I wanted to know the incorrect values for oracle data types. like for example, string data type cannot accept ' value. What other values does string data type does not allow.? and what about other data types like number, float. Thanks in advance.. | |
Hey buddies i want to know tht How can i redirect my sql query result to text file using sql command. | |
I need to know how to calculate in c++,using oracle.In this case i must know how to join table.Can I know how this can be done. Thanks. Anjana89 | |
Hi, I am using SQL Plus Oracle 10g and sometimes when I ran a query such as: select * from employees; some of the columns were cut-off in the results because the table contains too many columns. So my question is: how can I let all columns be displayed in … | |
Unable to load DLL 'OraOps9.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E). Following is my scenario: 1 - Previoulsy I had Oracle 09 in my asp.net 4.0 applicaiton working fine on Windows XP. 2 - I updated the windows to windows 7 and installed Orcale 11g. … | |
hy.... how to get year now and 10 year before with query result is 2009,2008,2007,2006,...... thanx.. | |
hi can i reset my password and user name for oracle 10g i lost all users and user default it can not log using system . sys or scott at moment plz how i can rest password i have to do project and i cant acess to sql plus | |
In going through some homework, I was able to do some of the problems, but not others. For example, one problem was "Produce a list of employee last name, first name, job function, department name and department location. Use appropriate, user friendly column aliases." I finished this with this code: … | |
1.Procedure named *ship_order* that will accept an order# parameter. It should verify that the ship date for the order# is null and each book ordered has a sufficient quantity on hand. If every book is available, the quantity on hand for each book should be decremented and the ship date … |
The End.