Oracle Database Forum

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 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 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'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.

Hi Guys, The following query is trying to retrive data from a Oracle cube.I am not very much aware of the cubes.Can someone help in explaining what does mean MODEL DIMENSION BY ( DIM_TEMPS) MEASURES (

I have a project in Isql*plus database.In this project I have to get names for Employees who started work in the first half of the year(01 january to June 30 th)...I'm stuck..please help ============================================================== Here is my Algorithm: select last_name,Hire_date,Department_ID from employees where...

I initially thought this had to do with Daylight savings time change, but now that it has passed in the US, I looked at the query and now I observed this behavior: begin_time is my column and is assumed to be UTC+0. This Yields 01:30 TO_CHAR(e.begin_time,'HH24:MI') BEGIN_UTC Okay, let's convert that to US/Eastern:

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

We are using ERP software package based on Oracle forms 11g & Oracle DB 11g. For customization we need to integrate JSP page with Oracle forms 11g. Please suggest the way to integrate JSP with oracle forms 11g.

Is there a way to create virtual table if I don't have create privilege??

Hi, i want to make database link in oracle 11g but some error has been occurred again and again in vista and xp both. Error is:- ERROR at line 1: ORA-28545: error diagnosed by Net8 when connecting to an agent Unable to retrieve text of NETWORK/NCR message 65535 ORA-02063: preceding 2 lines from TAB_LINK i have try many solution in...

hi every body: i made a form in form 6i and want to create image browsing facility in form and to store that image in database oracle 11g ,,,,,,,,so plz told me this method?

Hi, I need to write an SQL query to compare all the weekends in 2011. I have a table with orders and the dates for delivery. I just want to get a list of all orders on weekends in 2011. How can I do that? Just need a hint for a logic or some function which can give whether it is saturday or not. Thanks.

Hi all, I am using Oracle 11g on windows 2003 server R2 standard edition service pack 2. I am trying to create a trigger within a schema called "inventory" by logging in as the schema owner. Here is my code for the same: create or replace TRIGGER AUDIT_SYS_TR_TEST AFTER ALTER OR DROP ON DATABASE BEGIN IF(ora_sysevent =...

My machine is win xp os with oracle 8 and mssql 2000 database.when i try to import data to mssql database from oracle through "Microsoft ODBC for oracle" get an error TNS name could not resolve,but few days before it was working fine.I can directly access the data from oracle db through SQl plus and "TOAD" software.Please give solutions

Dear All, Plz help me with this oracle form builder installation? I have installed SQL *PLUS Release 9.2.0.1.0 and then installed form builder 9.0.2.7.0. When i enter the following username password database system manager I get the folowing error ; ORA - 12154 TNS could not resolve service name.

ORA-02291: integrity constraint (ME_1944_SQL01_S30.SYS_C0020218404) violated - parent key not found This is the answer I receive when I try to insert data into table. Two days ago there were not any problem, parent table was not changed but when I try to add data I receive this message, although parent key exists. Please, help if you know...

SELECT trunc(sysdate) dt, count(*) as count FROM ATM_MONITOR.ATM_PROBLEM WHERE trunc(sysdate) = trunc(create_time) union SELECT trunc(sysdate)-1 dt, count(*) as count FROM ATM_MONITOR.ATM_PROBLEM WHERE trunc(sysdate)-1 = trunc(create_time) union SELECT trunc(sysdate)-2 dt, count(*) as count FROM ATM_MONITOR.ATM_PROBLEM

when i put a query like select * from my table it will be running/scrolling continuously as there are many records in the table but I want to stop it and see the data in the table for limited records. what is the query ? and how can stop scollin

How can I export data from oracle to excel sheet and other database