Oracle Database Forum

Hi all Every time you post any code for reference of experts in this forum please take care to explain your problem in details and take specially care not to forget to post table/view structure. Unlike other subjects it is not possible to copy and paste your code and check it for errors without having the table structure. Please use code...

What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge required to effectively administer and manage Oracle WebLogic Server, which is a leading application server used for deploying and managing enterprise Java applications. WebLogic Admin Training typically...

Hi,i'm writing sql trigger that updates some columns in table. I have to write that this trigger fires only after commit. I read some articles about this topic but in the most it is said to use procedure. But I have to do it with trigger. CREATE OR REPLACE TRIGGER tr_reset_er_encours AFTER INSERT OR UPDATE ON T FOR EACH ROW BEGIN IF...

create table jira_upload(id_num number,filename varchar2(50)); insert into jira_upload values(1,'test'); create or replace procedure sp_jira( id_req IN jira_upload.id_num%type, err_msg OUT varchar2) as lv_count number; begin

Hi I am getting ORA-01578: ORACLE data block corrupted (file # 53, block # 34982) ORA-01110: data file 53: '/u01/app/oracle/oradata/orcl/users_08_01.dbf' on table so can we drop and recreate that table ? so my ORACLE data block corrupted problem is resolved or not ?

. Compression is critical since table size is quite tall, maybe 16-20 columns wide. My pipeline, as for now, is using Oracle GoldenGate on-prem, replicat on-prem as well in the same node, and build the … I was wondering what could be considered a best practice when it comes to extract incremental data from an Oracle transactional table running...

i have pl/sql table xxx. We are storing start_date and end_date in this table. I want to add 1 month to start_date untill start_date = end_date basically I want to create a loop which will insert date in another table with incremental start date

HI Guys, Could you please help me how to create external table with only one filed(number data type) in oracle I used the below code but it was not loading the data. CREATE TABLE SOLNGLOBAL_ORIG_DATA_656356 (Account_NUMBER NUMBER ) ORGANIZATION external ( DEFAULT DIRECTORY SWA_ED20307_OTHERPREP ACCESS PARAMETERS (RECORDS DELIMITED...

Hello, Does someone know/has experience in connecting from Oracle RDBMS 12.1/12/2/19.1 to PostgreSQL 10.3/9.5 through a database link? As well as from PostgreSQL 10.3/9.5 to Oracle RDBMS 12.1/12/2/19.1 ? Thanks by advance for sharing your experience. Kind Regards

CREATE OR REPLACE TRIGGER display_salary_changes BEFORE UPDATE ON customers FOR EACH ROW WHEN (NEW.ID > 0) DECLARE sal_diff number; BEGIN sal_diff:=:NEW.SALARY-:OLD.SALARY; dbms_output.put_line('Old salary: ' || :OLD.SALARY); dbms_output.put_line('New salary: ' || :NEW.SALARY);

dear how to changing number to word in oracle developer? i have an attachment like this, i am beginner in oracle forms and this site also. Can any one please help me out from this problem.

SQL query to display the Ename of EMP table of Dept no 10 in lowercase ,and Dept no 20,30 in uppercase.

I need help on this. I want to create a trigger that should fire before update(back end) when an insert occurs on a table(front end)but the back end table has one of it column datatype(NVARCHAR2(2) different from the front end datatype(VARCHAR2(35)table and as such the trigger is not working. So i introduced a case function IF...

HELLO FRIENDS, Good afternoon I need your help to solve one problem in my connection from sap to oracle 11.2, my database connection is established good, but when run exec my connection in sap to oracle send error 0ra-02019. the Legend from sap is ora-02019 connection description for remote database not found I Accept tips and...

I have list of MATERIALIZED VIEWs and I would like to know the underlying tables in the MVs. This is required to decide whether the MV is ready to be refreshed of not.

i need to call report from another report as dynamic but without show the url to users

Hi everyone, I'm curious to know how often do you apply CPU's and are you only relying on CPUs for security? How about versions that are not currently on Oracle premier or extended support like 11.2.0.3 or 10g?

Hi, I want to display pdf file into OLE field using button from oracle forms 6i, the file located in my local desk. How can I work around this issue? Many thanks

I just need to print or get the max display date from table b using table a with left outer join

Hi Gentle, How do create a schema for existing database?

I'm just a beginner in PL/SQL. I'm trying to call the TESTPROC procedure inside my TRIGGER. Here is my code: CREATE TABLE FORTESTING ( TestName VARCHAR(50) , ); CREATE OR REPLACE TRIGGER TESTTRIG BEFORE INSERT ON FORTESTING

PROCEDURE invoice IS repid REPORT_OBJECT; v_rep varchar2(1000); rep_status varchar2(20); PL_ID PARAMLIST; pr_nm varchar2(20):='PNM'; v_rptserver varchar2(10):='oliur';----1 --rwserver server=oliur EXECUTE IT ON RUN v_host varchar2(20):='localhost';---2

I am using oracle developer 2000 to make a report, the requirement is to print the data on page then again print after the printed line. I have saved the total number of line printed but i don't know how to start print after that printed lines? Please suggest solution. Thanks in advance!

i am able to create database link at oracle. but i am getting error as SQL> create public database link link2db connect to "swarna" identified by "root" using 'TSTLINK'; Database link created. SQL> select * from "ss"@link2db; select * from "ss"@link2db * ERROR at line 1: ORA-28545: error diagnosed by Net8 when...

ID |NAME |CITY ------------------------------- 1 ahmed HARGESIA 1 ahmed HARGESIA 1 ahmed HARGESIA i need to update the ID column TO change this way 1,2,3, and know it's 1,1,1, how can i update

select loc from emp e, dept d having count(e.deptno) = 0 or sal <= min(sal) and d.dname = 'SALES' and count(ename) >=2 and sal < avg(sal) group by loc where e.deptno != d.deptno; ORA-00933: SQL command not properly ended This error I get when I run this command on oracle, can anyone help me resolve this error?