Oracle Database Forum

How do you search a database for records by date? data base name= sholiday date format=dd-MM-yyyy

I have created the following trigger to update the table "T1", create or replace trigger inserttrigger2 before insert on t1 referencing old as old new as new for each row declare to_date date; from_date date;

when I m try to insert more the 300 date at a time from .NET then some error throw Maximum open cursor, so i m increase the size of OPEN_CUSRSORS =1000 instead of 300 from init.ora and restart database, so again throw same error , Pz give me sol. ASAP

I want to add a column to my table that includes the data of two concatenated columns (first_name || ' ' || last_name "FULL NAME") and am totally at a loss. Any help?

please Solve my issue, I have Table name Record which has the following columns, Empid in number column, dat in timestamp which has the following values empid dat ====== ==== 101 4/9/2012 9:48:54 AM 101 4/9/2012 9:36:28 AM 101 ...

I am using the following statement to replace address abbreviations. I would like to expand this to look at multiple abbreviations which would be replace with the same word (ex: ST, ST., STR would all be replace with STREET). Right now I have indivisual statements for each abbreviation. UPDATE Address SET Address.PHYSICAL_ADDRESS =...

Hi everyone am using APEX 4.1, The Leave_transaction Table has the following Fields, 1.Leave_id 2.Emp_name 3.From_date 4.To_date 5.Remaining_days The Emp_Master Table has the following columns,

CREATE OR REPLACE PROCEDURE MFGNO(BODYSRNO IN VARCHAR2) IS MFGSRNO VARCHAR2(8); mfgno varchar2(8); cnt varchar2(3); BDATE DATE; BEGIN Select year_code||TO_CHAR(SYSDATE, 'MMDD') INTO mfgno from year_master where year in (select to_char(sysdate,'yyyy') from dual); select lpad(count(*)+1,3,0) into cnt from manu where

HI I used BI Publisher for report. In rtf template faced some problem. i want summation two element. <?sum(element1*element2 div 100)?> but its not support.

I have a process that generates a .txt file (fixed length) from an Oracle concurrent process. Originally, this was just picked up from a Linux directory and ftp'd to Windows directory. To automate the process, a mount point was established on the Windows server. The problem we are now seeing is that a control character (end of file) is seen at...

Dear all, I have 2 tables, 1.lv_data, it has the following fields, emp_name tot_days guru 18

I want to set up a CHECK constraint for an ID i.e CON12345, it has to have those three characters "CON" at the front and 5 numbers that follows that?

Hi All, I need to update a specific column when ever sysdate changes, is there any possibility to update the specific column using trigger? Thanks, Sreenath

Hiii, I had written procedure which will display missing data from a table CREATE OR REPLACE PROCEDURE GETEMPLOYEE_INFO ( P_CPNCOD in varchar2, P_PAYDAT in date, P_PAYTYP in varchar2, P_ERV out varchar2) is

Hello Experts, I have a question on PL SQL. Assuming I have the following table TestTable (ID, Table_Name, Column_Name) It is in the form like ID, Table_Name, Column_Name -----------------------------------

datediff function is not supporting in oracle 11g we have any other option to solve this criteria please help me up any one knows what is the key word they are using in oracle 11g to get datdiff if any one knows replt to my post asap with regards

Hi Experts, I need to develop a dynamic SQL in PL SQL to query an unknown number of columns. Let me take a sample query here: SELECT FIRST_NAME, LAST_NAME FROM VENDOR_CONTACTS With "known number of column" method (in this case we have known that we are querying two columns: "FIRST_NAME" and "LAST_NAME"), I write a code based on the...

Oracle Forms Problem in virtual box using ubuntu. The error is as under:- FRM-40922: An OLE error occured: 0x80040154

hai all i want to store attachment files in my oracle database..so,what will be the suitable datatype to use? thanx in advance........

Hi and thanks for checking out my post. My problem is connecting to a remote oracle database from my unix machine. The remote database is on the network and I typicaly connect to it using an alias, username and password. In the past I have connected to the database using sqldeveloper. The connection type is TNS and the network alias is...

i am using toad11.5 version ,here a schema name is(ex:sa) database name(ex:wttest).i need full backup of wttest DB. now i am trying to get through rman(recovery manager) script in databse browser.here, its showing one message 'you must have the sysdba privilege to use RMAN' how can i give the sysdba privilege grant to the user . but i ...

hello plz understand me if you feel bad Because i don`t know well English. I just wonder how to change sessions_highwater value... please...

Hi all, I need your help here, i have pl/sql procedure , this query returns 1 as out put, but to see that result?, when i execute this procedure,like this, execute pro_name('emailid',password); it shows only "anonymous block completed", how to see its output that retrieves, Is there any possibility? my PLSQL query is,...

i am using oracle 10g with toad editor ,i want to take full back up of specific database .i tried through recovery manager but its not working. please help.. thanks in advance..

Dear expert, Kindly help me on the pro* c compiler . I'm new to pro* compiler.I have written the code in pro*c and name it as .pc file. When i compile it to make .c file in pro c compiler in oracle,i'm getting some error message ..The error as below : ++: Release 9.2.0.1.0 - Production on Tue Mar 1 17:20:48 2011 Copyright (c) 1982, 2002,...