Oracle Database Forum

Hw to call select statement in trigger.query is below create a row level trigger on emp table.this trigger contains select stmt to ensure that the new salary value falls within the min and man salary for a given job title. please guide me hw to write code as per the above specification.

wtat is the use of decode function ,how to use that function in sql description of decode function

Hi,here's the thing: I have an existed table(many records have been inserted into it) which already has a PK, but now I want to insert records with the same id, can I just add another PK to realize this? I hope someone can help me out.thanks ^_^

How to add not null constrint to an existing table? i tried with "alter table emp add constraint not_null_name not null(name)" command but it's giving error .......... alter table emp add constraint not_null_name not null(name) * ERROR at line 1:

All, How do One convert a comma separated column from a text file into rows in oracle. I have a scenario where the list of comma separated values changes dynamically. It is like: abc, ttt, 1,2,34,56,67,, afg, ttt, 3,4,5,6,,,,,

Hi, I have a doubt, In database db1 I have a procedure,this procedure has to call another procedure in db2 my requirement is ,we have to pass a table type which is declared in db1 as an input to the procedure which is there in db2 expamle procedure_db1

hi everybody i need to retrive all relational tables from oracle can you give me a query for that

Hi all My function return the a customer address. Some customers has got 2 then it doesn't return any values. The cust with one value does return the correct value. How can I fix this. Here is my Script Function CREATE or replace FUNCTION get_add(acc_no IN varchar) RETURN varchar IS

Does anyone know of an SQL statement that combines data directly from two different databases?

Dear Friends, Hope you are doing well. I have one question.Here I have the some columns. Like this: LOAD DATA INFILE FACT_PERFORM.csv

Hi I've done this is MsSql, but this won't work in Oracle. In MsSql, a simple WHERE ColumnName LIKE '%' will return L1, L2, L3, L4 etc

update em123,de123 set em123.sal=sal+17000,de123.dname='manager' where em123.eno=de123.eno error: 0ra-00971 missing set keyword

Hello, I am trying to pull a list of sample counts by test. I only want 1 row per test result so that I can build a report in Cognos showing the rate of a particular result as a percentage of the total results. My problem is that I am getting duplicate rows for the same result - in the example below I have 2 - 5 rows for each result instead...

update em123,de123 set em123.sal=sal+17000,de123.dname='manager' where em123.eno=de123.eno

I have an error showing 'right parenthesis error', so someone can help me? create table employee11( empname varchar2(15), empid number primary key, address char(30), dept_code number foreign key, salary number not null, gender varchar2(2) check m or f, dob date,

I have a trigger as following: CREATE OR REPLACE TRIGGER TRG_REFRESH_MVIEW AFTER INSERT ON MV_AUDIT BEGIN DBMS_MVIEW.REFRESH('MV_SCH_STUDENT_AVAILABLE_COURS','A'); END;

Hi, I am trying to load data file into database in sql loader. How to skip the bad record alone and continue with loading? For eg. I am trying to load data file which has 100 records.The 50th record encounters an error.At present only 49 records gets loaded and it stops from 50th record. I want first 49 records as well as 51st to 100th...

Hi Guys, I have a table where I where I can enter date in HH:MM format. I have already created the table as: CREATE TABLE "test"."SLA" ( "SLAID" NUMBER(10,0) NOT NULL ENABLE,

I am trying to create a schema using SYS as SYSDBA account. create schema authorization testschema create table timsheet(tid INTEGER PRIMARY KEY) Error at Command Line:1 Column:0

I'm working for Taiwan operating unit where supplier name is store in traditinal chinese language. I have written a package in which I'm displaying these chinese supplier name in fnd output file of a concurrent program. But in output file I see ? (question marks) instead of chinese characters. So can anyone tell me how can i output chinese...

Hi, I'm using ((OracleStatement) sg1PreparedStatement).defineColumnType(3, Types.DOUBLE); if the value for Double type is NULL, then it returns Zero. Can any one help me to stop replacing NULL with Zero. And this happens only for Double datatype

what is the diff b/w where clauss and having clauss

How I can enable the parallel execution in the database in order to execute the SQL statement in parallel? THANKS.

I have a materialized view which needs to be refreshed automatically once each day at a specific hour (2:00 PM). How can this be done? I need a clear example ,please. THANKS.

query: SELECT COUNT(*) FROM dwdbo.FNL_DW_COM_ACCT_D a WHERE a.ACCT_REPORT_DT = '30/jun/2011' --v_report_dt AND (INSTR(TO_CHAR(a.ods_acct_id), '888') > 0 --v_search_attr