1,135 Topics
| |
Hi guys, I have the following problem select a.id, a.start_date, a.end_date, b.start_date, b.end_date from interval_1 a, interval_2 b where a.id = b.parent_id This will generate a solution like: 5 | 01-Apr-2012 08:30:00 | 01-Apr-2012 12:00:00 | 01-Apr-2012 09:30:00 | 01-Apr-2012 10:00:00 5 | 01-Apr-2012 08:30:00 | 01-Apr-2012 12:00:00 | 01-Apr-2012 … | |
Hello I am trying to write a select statement that will compute the average room rate under the assumption that if the room rate is "null" it should be replaced by the minimum room rate from the table. The following is all the details of my table : create table … | |
Hello All, i am new to oracle , i need to know where to start (books , videos , tutorials) where to start from scratch Thanks a lot. | |
Hi Iam admin for Redhat, my client requested to install oracle 10g in RHEL5 i downloaded packages how do i proceed the further steps. please guide me. | |
Hello every one, I have a question about creating users in Oracle using SQL*PLUS. But what I want to do is write the syntax in a txt file first (script) then when I run the script by calling it using the @ or by copy/past it should prompt me for … | |
Can Anyone tell how to convert String datatype 2 timestamp using altercommand in oracle | |
hi frends i m in fifth semester of engg in info.tech and i need info abt projects of database particularly hospital and railway reservation management pls send me informatuion from where i can get these projects and front end of projecs shuld be in visual basics VB | |
I am trying to create a table with a multikey but given i have to create a trigger and a sequence to place an auto increment key i am having difficulties on how to set a foreign key to be attached to a multi key. any help will be appreciated | |
hello iam started taking oracle 10g i have few doubts please clear me for example create table employee (ename varchar2(10),salary number(7,2)); what is the use of varchar compared to character??? what is number(7,2) i mean 7,2 i dont understand please explain me | |
Hello, I want to do horizontal fragmentation of a table say employee. But fragmentation is often related to distributed databases. So i want to ask how can i do this on my single home computer? Could anyone list out the steps that should be performed. I saw the concept of … | |
I am facing problem in database. i want to select tables which have been updated from last one week.. | |
ORA-01000: maximum open cursors exceeded tips I am getting following error. I made a combo box with select query behind it, i used itemlistener to fetch data. Today during testing i found that if user move too quickly in combo box so select query will be fired for each number … | |
hello there, i am new to oracle. i am trying to load different database, which i have just created using database configuration assistant in oracle, called "mydb". i want to load it when scott user logs in. btw which database loads when scott logs in, is it orcl or something … | |
have got this update script updating certain columns [CODE]update oppar set oppar_run_mode = 0, oppar_run_time = 0, oppar_interval_ind = 'N' , oppar_destination = '', oppar_run_date ='', oppar_run_interval='' where ( oppar_job_name, oppar_job_rec ) in ( ('CSCLM' , 'XYZ') , ('ARCLEVEXT' , 'LMN'));[/CODE] But there are cases where there is no record … | |
Hi everyone, I am currently putting my skill set together and I am looking for a site (free) to host a sample of my Oracle 10g database work. I did some searches and I found this one [url]http://apex.oracle.com[/url]. Can anyone share his or her opinion on this site or can … | |
I have created Following Function which takes 2 parameter [CODE] CREATE OR REPLACE FUNCTION Inst_Param_Desc(constant_Val IN varchar2(2), display_name1 IN varchar2(40)) RETURN VARCHAR2 IS Front_Display_Name VARCHAR2(40); Enum_Id number(4,0); BEGIN select b.enumeration_id into Enum_Id from xyz b where b.display_name = display_name1; SELECT a.front_end_display_name INTO Front_Display_Name from abc a where a.enumeration_id = Enum_Id … | |
[ATTACH=RIGHT]16645[/ATTACH]Oracle announced Thursday evening (August 12) that they would be filing a lawsuit against Google, claiming that their Android phone software infringes upon patents and copyrights of their Java software, which they acquired when they purchased Sun Microsystems in January for $7.4 billion. "In developing Android, Google knowingly, directly and … | |
i type the following code.... it runs properly....data gets fetch but i am not able to display it in a textbox.... it simply remains blank....whereas i am able to fetch the data outside the form tags here is my code: here i can see name =himanshu outside the form but … | |
need help here's code I'm almost finish I'm trying to find out how can i search down to the student who is taking at least two database classes here's the code [code] drop table student; create table student (student_id varchar(10) primary key not null, student_name varchar(10), major varchar(20), gpa decimal(10,1)); … | |
Is there a workaround to this as decode does not seem to allow the use of greater than equal sign I am trying to show the comment for any days beyond 4 days, not just 4 days. [CODE] decode(shipdate-orderdate,'4','This is unsatisfactory!') comments from orders [/CODE] Thanks in advance! :) | |
Hi all, I am trying to implement Oracle autovue in my project . Can any one post any pdf file or any link regarding Oracle Autovue. thanks in advance. | |
<prjt.ctl> [CODE] LOAD DATA INFILE 'F:\DataMining\dvdlist.csv' DISCARDFILE 'F:\Datamining\Discard\dvdlist.dis' INTO TABLE dvdlist FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS( DVD_Title char, Studio char, Released date "DD-MM-YYYY" NULLIF Released=BLANKS, Status char, Sound decimal external, Versions char, Price char, Rating char, Years char, Genre char, Aspect char, UPC integer external, … | |
I am using NetBeans 6.9 and Oracle 10g Express Database. All sql commands except insert are working fine. If I insert a value after connecting from the command line (conn HR/hr), the values are not reflected in Netbeans. The SQL Command line, Windows Command line and Oracle Home Page are … | |
[B] I will do an artifical intellegent project which is knowledge base system My question is Can I use [COLOR="Red"]ORACLE[/COLOR] database as knowledge base?[/B] | |
Hi All i am getting the below error pls help me to solve the issue datbase erre:ORA-20220: ORA-06502 PL/SQL: nemeric or value error: number precision too large in sp_watm_per_adj ORA-06512 at sp_watm_per_adj line 375 ORA-06512 at line 1 create or replace PROCEDURE sp_watm_per_adj ( in_per_adj_cd in per_adj.per_adj_cd%type, in_per_dt in per_adj.per_dt%type, … | |
Hi, I have a table called BookTitle that holds book information. I have an SQL statement that lists all books that have the same value of a book called 'Northern Lights'. The code works but what I want to do is to exclude 'Northern Lights' from the result. This is … | |
Hello all, I have a .zip file which is stored within a BLOB file. Using SQL Developer, how can I extract the .zip file from the BLOB in order to either open the file or store it on my local drive? I've never dealt with Zip files in BLOBS prior … |
The End.