Forum

Posts

RECENTLY INDEXED PROGRAMMING SOLUTIONS OF Oracle


Get Data from CLOB  

Hey All,I'm writing a PHP page to display some data from an Oracle database. Unfortunately, I can't copy the code because it's proprietary, but I'm having an issue I was hoping somebody could help me with. One of the columns in the db is of type CLOB. I'm having trouble... Continue Reading
Views : 101
Saturday 29th of December 2012

Aggregate two columns  

I have two table and I want to merge themTERMS_TABLE ID | TERMS 309 | 'hardware' 309 | 'software' 309 | 'computer' TFIDF_TABLE ID | TERMS 309 |'computer,phone,mp3....' Now I want to add... Continue Reading
Views : 91
Saturday 29th of December 2012

Save Password disabled in Login screen  

Hi,I have Toad 9.6.1 already installed on my machine and have now installed Toad 10.6 . unfortunately the Save Passwords option on the Connection screen is disabled. Could you tell me how do I enable that option.Thanks and regards,Ranjit Menon Continue Reading
Views : 71
Saturday 29th of December 2012

Help with Oracle SQL*Plus Query assignment  

You need to understand the difference between ASNI SQL and earlier versions to write all that. Continue Reading
Views : 37
Saturday 29th of December 2012

PL/SQL PROCEDURE using Cursor Loops and SINGLE PARAMETER  

** Continue Reading
Views : 140
Saturday 29th of December 2012

Difference between NOT IN,MINUS,NOT EXISTS and EXCEPT operators  

Hi guys, can anybody tell me where difference lies between these operators or clause, & whether there is any "except" operator in oracle, i know other three are used bt dont think oracle uses "except" too..as far as i have seen "NOT IN", "MINUS" , "NOT EXISTS" are exactly similar? pls... Continue Reading
Views : 67
Saturday 29th of December 2012

Single row subquery errors during update  

I'm getting back more than I want. I need to get the latest row in the PS_ACAD_STDNG_ACTN that has the academic standing code for students.I thought if I max the effdt, strm, and effseq I would get back only one row. Especially effdt since a academic status is hardly ever... Continue Reading
Views : 103
Saturday 29th of December 2012

Page 2 - User Defined Data Type  

Select the base data type from the list box. The list box displays all data types except for the geography, geometry, sys name, time stamp , and xml data types. The data type of an existing user-defined data type is not editable. Continue Reading
Views : 136
Saturday 29th of December 2012

Adding description on lookup table  

Ive got a look up table and i want it to display text instead of just the ID number, how would i do that? so for example if1 = Hello2 = Byeit would display "Hello" instead of "1" Continue Reading
Views : 31
Saturday 29th of December 2012

Noob create table trouble  

I am trying to create a table that will increment my ID by one using the following commands:/*Creates the log needed to increment ID*/create sequence seq_log;CREATE TABLE MESSAGE_LOG_TABLE( ID NUMBER(10) NOT NULL PRIMARY KEY, Continue Reading
Views : 24
Friday 28th of December 2012

Trigger Advice  

HiI am soon engaging in a project where we will deploy three triggers to each table in a customers live database. One each for Inserts,Updates and deletes.These triggers write or update a row in a separate table on a different schema.We have experienced... Continue Reading
Views : 37
Friday 28th of December 2012

Using software online developed by dev 6i and 10g XE  

I Developed a point of sales software using developer 6i and database 10g. XE. Now I want to use it online. How do I can it ? Please describe step to step. Continue Reading
Views : 20
Friday 28th of December 2012

Oracle Returning Max value and value prior to max  

I have this query to return to me the latest case note, now I would like to add the date prior to the latest case note.select case_notes.applicant_id, reg.program_code, reg.last_name, reg.first_name, reg.reg_date, ... Continue Reading
Views : 211
Friday 28th of December 2012

Order By In Oracle With Priority  

I have a table (emp) with three columns in ORACLE:COMPANY OFFICE EMP------------------------9999 00001 emp19999 00001 emp29999 00002 emp39999 00002 emp40001 99999 emp50001 00001 ... Continue Reading
Views : 216
Friday 28th of December 2012

A second trigger  

Relevant tables:create table messages( msgID number(10), fromID number(10), message varchar2(1024), ToUserID number(10) default NULL, ToGroupID number(10) default NULL, dateSent date, constraint messages_pk primary key(msgID), Continue Reading
Views : 93
Friday 28th of December 2012

Installing Oracle 10g developer's suite and database server  

i am sort of confused. if i installed oracle 10g dev suite do i still need to install the db 10g?i tried installing db10g first then the dev suite. On the db 10g i can connect via sqlplus. while i cannot connect on the dev suite, which has a 'sqlplus' too.i am... Continue Reading
Views : 46
Friday 28th of December 2012

Collapse a matrix to a single line item  

Hi,I think it would be best to use a simple example to explain my problem. The table below needs to become compressed into to distinct line itemsCustomer_No Hair SP_Code Gender Age Colour Weight1 blonde 123 M null null null1 blonde 123 null 23 ... Continue Reading
Views : 178
Friday 28th of December 2012

Newbie SQL Query: Asking to fetch multiple entries in same table  

Good Morning,I'm new to SQL and although I'm getting better, I've got a query at the moment that is totally blinding me! It's probably really simple, and I was wondering if you could provide some help.Basically, an application we use in my business records some... Continue Reading
Views : 59
Friday 28th of December 2012

When using Form Builder to create a new form from TEMPLATE.fmb, there is an error  

FRM-30064: Unable to parse statement select timezone_code,name,to_char(trunc(gmt_offset),'S09') || ':' || to_char(abs(gmt_offset - trunc(gmt_offset))*60,'FM900') offset,decode(daylight_savings_flag,'Y','*',null) dst_flagfrom fnd_timezones_vl Continue Reading
Views : 219
Friday 28th of December 2012

Any details for Oracle 9 Projects Essentials( exam 1Z0-554)  

I know the Oracle 9 Projects Essentials( exam 1Z0-554) is available now, but i dont know is it valuable for me to take now. Who can give me some advices by taking this JD Edwards EnterpriseOne 9 Projects Essentials test ? i'm hesitate with it Continue Reading
Views : 50
Friday 28th of December 2012

Need to re-write a MSSQL update statement to work in Oracle  

How do I write this MSSQL statement so it works in Oracle?update b1set b1.b1_app_status = r3.application_statusfrom conv_app_status_update a, statyp r3, b1perm b1where a.spc = r3.serv_codeand a.task_des = r3.r3_act_type_desand a.task_status... Continue Reading
Views : 177
Friday 28th of December 2012

Missing Right Parenthesis  

Hello, this is my first time posting and I hope I'm doing this right. I'm working on my database homework, and I came across an error that I cannot seem to fix. I'm getting a missing right parenthesis error on line 7, but I seem to have all my parenthesis, endless I'm overlooking one. I... Continue Reading
Views : 44
Friday 28th of December 2012

Trigger help - IF UPDATING THEN  

I've created a trigger named customer_archive_tr on the customer table. The trigger saves the current values of all columns of the customer table to the customer_history table before the record is updated or deleted. (Here is where I get confused...)If the customer... Continue Reading
Views : 125
Friday 28th of December 2012

Create view off split string  

How do i split a string based on a space. And then create a view with three columns of that split string.For example if i have a table with Full name as a column how do i split that string and create a view with firstname, middlename, lastname as column names with the split string... Continue Reading
Views : 41
Friday 28th of December 2012

Sequence Number issue in 11g RAC  

Hi All,In our production, we have two nodes in the cluster. We use the sequence for one of the main table for primary key. Our application is expecting sequence number increments along with created date time stamp. Right now sequences are cached for each node and it creates... Continue Reading
Views : 155
Friday 28th of December 2012

Precautions for converting a table field from long to clob  

Hi guys,I am more of a C/C++ guy and relatively amateur in oracle. I have to update a table field from "Long" to "CLOB". I have planned to do a simple alter table, and as far as I know there won't be any issues.Queries:1. Although I have triple checked, is there any... Continue Reading
Views : 79
Friday 28th of December 2012

How To Patch Oracle 11g  

I've been told by management this weekend I will be required to perform a complete patch of our Oracle 11g database. Problem is I really have never installed / patched... Continue Reading
Views : 34
Friday 28th of December 2012

Alt SQL Developer  

I would like to announce the Alt SQL Developer (altsqldeveloper.com). This program is my analog of TOAD, SQL Developer, PL \ SQL Developer, but more FAST!I would like you to test the program and start using it if you like itIt would be great to hear your comments and... Continue Reading
Views : 47
Friday 28th of December 2012

Generate CASE WHEN Query with ORDER BY involving Secondary Sort  

Below Query I understand is improper wrt syntax. Need to modify query to fetch correct result for me. Please help!select * from tableA order by case when a is not null thena DESCelse b DESC, c DESC ENDNote: DESC or ASC is dynamic coming from... Continue Reading
Views : 64
Friday 28th of December 2012

Oracle Query  

Hi I am new to oracle, was pretty much involved in developing in sql server. Can someone please help me in converting the below query to oracle.Declare @lowyear int Declare @highyear int Declare @TotalRecords intSet @highyear = @YearSet... Continue Reading
Views : 93
Friday 28th of December 2012