Forums: SQL PL/SQL

Hi Guys. I hope you can help me solve this problem, i have a query below and i want to convert (+) into join syntax like 'left outer join ? on ? =...

Dear all, i am using three cursors in one pl/sql block each of this three cursor will fetch data based on column of date data type.i...

Dear all, I have created one procedure and it is working perfectly ,but i want two point to be included in this code point 1: i want to trap any...

I am reengineering a database and wnated to change POC to PocID as this is a number field that is the PK for the table. I di this by generating the...

I want to settle in Datamware Housing Tech. Then in which topics i have to do more concentration in sql and plsql?

I want to avoid duplication on old_nic_no and new_nic_no number in a Table, for this i am using a following trigger CREATE OR REPLACE TRIGGER...

Hi Techies, I am new to oracle PL/SQL programming. I am not getting the output. Can anyone suggest me? declare vemp emp%rowtype; ...

HI I'm confuse to understand the concept of PLACEHOLDER in dynamic sql... I've also studied the link provided in this thread but still confused...

Dear all, I have created a package and successfully compiled it but i am unable see the status of all the procedure belongs to this pacakage. ...

hey guys please help me to sort out this query. i am practicing with oracle 9i with the default database ..here is the query. Display the job,the...

WORKING AROUND MUTATING TABLE ERROR USING VIEW SQL> CREATE TABLE STUD(RNO NUMBER(5), SNAME VARCHAR2(20), M1 NUMBER(4), M2 NUMBER(4), ...

I need pl sql code to send emails from oracle 10g database using utl_smtp.

These are the problem to create a package

declare v_name varchar2(30):='&give_name'; v_parse varchar2(50):=null; begin dbms_output.put_line('the given...

Dear all, i have one table sql>desc request Name NUll? Type ---------------------- --------- ...

Hi There is a requirement for me to retrieve only one phone number the preference is if mobile available M. if not Home number - H1 else Work...

Dear, I am a programmer in Oracle PL / SQL in Oracle 10g I'd like to use the same time on one Database two types of fonts English and Russian...

I am working on a project of migration where I need to have Stored Procedures for DB access routines cursor - Declare, Open, Fetch etc. I need to...

Dear Sir, since this code is in development stage,i am trying to analyze and implementing the logic as per the requirement then i...

what is the usage of the bit map index and where it use