Oracle Database Forum

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

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

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

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?

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

Hi All, How can i select last ten modified records in table. Can u please help me.

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.

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

Hi all, I am using Oracle_OraClient11g and PL/SQL developer. I am finding a COMMAND LINE of DOS to generate a script.sql. That means the COMMAND LINE will be sth as following: _ Input: name of table _ Output: file sql.script I think I can find such a COMMAND LINE like that in "..\product\11.1.0\client_1\BIN" or...

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

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);

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

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

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

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 ?

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.

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

I am trying to determine the record number of a record in Oracle Forms so I can navigate to that record. I am using the code below but it only gives me the record number of the record I am currently displaying. declare temp_record number(40); char_record varchar2(40); Begin temp_record := 0; if :control.barcode_query is null then...

Hi to all, I am new for oracle please can any one give me a query to get most used tables in the database. Please help me.... Thanks Manjunath

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

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

All, Below listed are the new features in Oracle 11g ,please join me in this discussion to generate a testcase and analyze each of the listed features . Precompilers: Additional Array INSERT and SELECT Syntax Support by Pro*C/C++ and Pro*COBOL Precompilers: Dynamic SQL Statement Caching in Pro*C/C++ and Pro*COBOL ...

I have created a fairly complex view based upon several UNION statements and the view selects exactly the rows that I want if I am in ORACLE SQLPLUS or MS Access. But in Crystal Reports it returns rows that should not be visible through this view. Has anyone else experienced this and what did you to get around this?