gangadharam.p

 Profile Answers by gangadharam.p Questions by gangadharam.p

• Jan 6th, 2007

Hi,  write a control file to dump the data from file to table using SQL*LOADER or use UTL_FILE to do the same.

jamesravid

 Profile Answers by jamesravid Questions by jamesravid

• Dec 12th, 2006

Use "sql loader" to limport flat file data to database tables.

Answer Question  Select Best Answer

gangadharam.p

 Profile Answers by gangadharam.p Questions by gangadharam.p

• Jan 6th, 2007

hi,  when u do so the view gets error and synonym becomes invalid. If u create a table again with same name but with different cols the synonym will work but view wont.bcz view is the stored...

raghgu

• Nov 16th, 2006

Hi friend, As per RDBMS rule we cannot have invalid synoym, but we can have a invalid view.

Answer Question  Select Best Answer

Pawan Ahuja

• Dec 3rd, 2006

 In forms eigth types of trigger.1) Block_Processing Triggers, 2) Interface event triggers, 3) master/Detail Triggers, 4) navigational Triggers, 5) Query_time triggers, 6) Transactional Triggers ...

Anusha

• Nov 23rd, 2006

1) Block_Processing Triggers, 2) Interface event triggers, 3) master/Detail Triggers, 4) navigational Triggers, 5) Query_time triggers, 6) Transactional Triggers 7) Validational Triggers 8) Message_handling Triggers 9)When_New_Instance Triggers

Answer Question  Select Best Answer

Sagar Sai

• Feb 4th, 2007

Hi,There are 3 types of triggers available in the Database. They are 1.DML Triggers :- These are again 12 types like .. Before INSERT,UPDATE,DELETE and After INSERT...

Pawan Ahuja

• Dec 3rd, 2006

there are three types of triggers in pl/sql1.)DML triggers2.)instead of triggers3.)system event triggersRegardsPawan Ahuja

Answer Question  Select Best Answer

kalpana2u95

 Profile Answers by kalpana2u95 Questions by kalpana2u95

• Oct 12th, 2010

Pre SQL query  means that the integration service runs SQL commands against the source database before it reads the data from source. Post SQL query means IS runs SQL commands against target database after it writes to the target.

Pawan Ahuja

• Dec 4th, 2006

Pre-query trigger fires only ones while post-query trigger fires each time.the Post-Query trigger fires each time Form Builder fetches a record into a block.RegardsPawan Ahuja

Answer Question  Select Best Answer

Guest

• Dec 12th, 2006

Actually your question is not clear. Do u want to change column name or values in the column?to change a values it is quite simple.select replace('replace_underscores_with_spaces','_',' ') from dual;

Gupteshwar

• Dec 9th, 2006

You can use REPLACE function in order to replace a digit or character in a column.SELECT REPLACE(col1, '_', ' ') FROM table_1.This function can also be used to update column's records.Try this function. Hope it would work.

Answer Question  Select Best Answer

chaitunitk

 Profile Answers by chaitunitk Questions by chaitunitk

• Jun 3rd, 2010

Owner of a table is the schema name which holds the table. To change the owner just recreate the table in the new schema Using create table  XXX AS select * from oldschemaname.XXXand drop the previous table in oldschema

Das

• Dec 21st, 2006

Owner of a table is the schema name which holds the table. To change the owner just recreate the table in the new schema and drop the previous table

Answer Question  Select Best Answer

madhuk17

 Profile Answers by madhuk17 Questions by madhuk17

• Feb 9th, 2007

We can call a function from anonymous block as a part of sql statement written in that block.eg: create or replace function fn_emp(v_empno in number)return varchar2 isbeginselect ename into v_ename fr...

rajnish123

 Profile Answers by rajnish123 Questions by rajnish123

• Dec 30th, 2006

hi,suppose a function  add two number and you desire to call it from anonyms block.create or replace function f_add(a in number,b in number) return number asc number;beginc:= a+b;return (c);end;t...

Answer Question  Select Best Answer

madhuk17

 Profile Answers by madhuk17 Questions by madhuk17

• Feb 8th, 2007

Hi,I think trigger is not called.The code in the trigger defines the action the database needs to perform whenever some database manipulation (INSERT, UPDATE, DELETE) takes place.I think maximum number of data strings that can be returned through DBMS_OUTPUT is 255 bytes.

gchandra_sekar

 Profile Answers by gchandra_sekar Questions by gchandra_sekar

• Feb 7th, 2007

Hi!) Trigger cannot be called as it automatically gets activated once u touch the table.2) Prior 10g user SQL> set serveroutput on size 1000000 or if it is 10gORA10GR2> set serveroutput on size unlimited

Answer Question  Select Best Answer

Vishakha

• Feb 17th, 2007

 declare cursor v_cursor is      select empno, empnm, empdept from emp where empdept = 10;begin      open v_cursor;     ...

geetha24

 Profile Answers by geetha24 Questions by geetha24

• Feb 13th, 2007

To display the cursorOPEN v_cursor FOR SELECT ename, empno, deptno FROM emp WHERE deptno = p_deptno ORDER BY ename;LOOP FETCH v_cursor INTO v_ename, v_empno,...

Answer Question  Select Best Answer

KSPRADEEP

• Oct 17th, 2012

Cluster are groups of one or more tables physically stores together to share common columns and are often used together

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 6th, 2008

Clustering is a method of storing tables that are intimately related and often joined together into the same area on disk. For example, instead of the BOOKSHELF table being in one section of the disk ...

Answer Question  Select Best Answer

Ravindra Reddy

• Sep 5th, 2007

The PL/SQL Blocks are 2 types1. Ananymous Block2. Named Block1. Ananymous Block means with out any name.Ex:- Declare<variables>Begin<Exec Statmts>ExceptionEnd.2. Names Block are ...

Sanjay Bharti

• Jun 13th, 2007

Hi All,I am new to this community. It seems the question is related to Begin End block of PL/SQL. See if you do not want to write any procedure and you want to do some sequence of operation that inclu...

Answer Question  Select Best Answer

gauravy

• Jul 5th, 2017

Use pipeline functions

durgadas.menon

 Profile Answers by durgadas.menon Questions by durgadas.menon

• Aug 13th, 2008

Unlike tables ref cursors do not store data. They act like mold to hold data during the execution of the piece of code so proper coding and use of bind variables can help decrease the burden of proces...

Answer Question  Select Best Answer

How can I write a function which returns previous business date of given input date1. skip holidays when you find previous day2. skip Sunday and saturday's when you find previous dayUS holidays are defined in HOLIDAYS tabledate, holiday_desc1-Jan-2007 New Year

ravgopal

 Profile Answers by ravgopal Questions by ravgopal

• Oct 10th, 2007

If you need to get the previous business date, just change the in_dt variable in declaration to input_dt date := '&Dt';in_dt date := input_dt - 1;

ravgopal

 Profile Answers by ravgopal Questions by ravgopal

• Oct 10th, 2007

Did you find the solution?  if not then, here it is..try thisa) Create the sample table holiday : create table holiday (h_dt date, h_desc varchar2(100));b) let us feed some records;Inse...

Answer Question  Select Best Answer

krishnaindia2007

 Profile Answers by krishnaindia2007 Questions by krishnaindia2007

• Jun 23rd, 2008

Collection is an ordered group of elements all are of same time. Each element in the collection has unique subscript to identify its position in the collection.Pl/sql offers three collection type...

ravgopal

 Profile Answers by ravgopal Questions by ravgopal

• Oct 10th, 2007

The following bullet points can be referred to when deciding what collection best suits a particular solution.VarrayUse to preserve ordered list Use when working with a fixed set, with a known number ...

Answer Question  Select Best Answer

kirangsv

 Profile Answers by kirangsv Questions by kirangsv

• Jan 6th, 2008

A collection can be loosely defined as a group of ordered elements, all of the same type that allows programmatic access to its elements through an index. Commonly used collection types used in the pr...

dev5000

 Profile Answers by dev5000 Questions by dev5000

• Dec 26th, 2007

It is kind of datatype.Collection is nothing but?a convenient?way to manipulate many variables at once.There are 3 types of collection.1. INDEX BY TABLE2. NESTED TABLE3. VARRAYS

Answer Question  Select Best Answer

What are the types of cursors apart from explicit and implicit cursors ? Explain when and where they are used ?

krishnaindia2007

 Profile Answers by krishnaindia2007 Questions by krishnaindia2007

• Jun 1st, 2008

There are only two types of cursors in oracle Pl/sql.1. Implicit cursors2. Explicit cursors    We can define an explicit cursor as static or dynamic (REF CURSOR).   ...

Manoharan

• Oct 25th, 2007

1. Implicit Cursor2. Explicit Cursor3. Ref CursorImplicit Cursor like SQL%rowcount,SQL%rowtype...Explicit   cursors are user defined cursorRef Cursor is object name of the cursor type. Its mainly used for dynamic purpose

Answer Question  Select Best Answer

Assume that I am using a temporary table in a procedure and I am inserting records and updating another set of records through Merge statement. If I use cursor in that temporary table, How can I extract all of the records from temporary table at the end of the stored procedure. Can you please give coding for this.

johnjerry

 Profile Answers by johnjerry Questions by johnjerry

• Oct 7th, 2009

Make sure you do not COMMIT* in the middle of the procedure. You can do any number of insertion into and deletion from temporary table and use "Select * from temp_table" to fetch a...

priyanka jolly

• Nov 24th, 2007

Create Global temporary tables and say on commit preserve rows. The global temporary tables have data available till the session is active. So you if you insert it at one procedure and want to access it somewhere else you can do that very easily till the session is activeThanks Priyanka

Answer Question  Select Best Answer

While i compiled my code , it got compiled but while running my application i got the Oracle error "Could not find the Program unit ? "Can any one tell exactly why this happens.I had validated all the objects and even released all the Locked objects . But still this error persisted .

binurajnair

 Profile Answers by binurajnair Questions by binurajnair

• Feb 20th, 2008

This error can occur in the following scenario also. The application has a constant connection with the database and a package which the application uses gets recompiled. And the recompiled package co...

raj_imr2000

 Profile Answers by raj_imr2000 Questions by raj_imr2000

• Jan 15th, 2008

Hi,ORA-06508:PL/SQL: could not find program unit being calledCause:An attempt was made to call a stored program that could not be found. The program may have been dropped or incompatibly modified, or ...

Answer Question  Select Best Answer

Hi All,I want create a stored procedure by passing the parameter to top nth recordfor Excreate proc test1(@x integer)asbeginselect top @x empid from emp order by empid descendwhen iam executing iam getting error .Please let me know any other alternative way

shruti.potdar

 Profile Answers by shruti.potdar Questions by shruti.potdar

• Dec 10th, 2008

Solution to your problem:Create Procedure TEST1( p_num number)isv_eid number;begin?? select empid into v_eid from EMPwhere empid=(select A.empid from (SELECT empid, rank() over (order by empid desc) RNK FROM emp) A where A.RNK=p_num);dbms_output.put_line('Top'|| p_num || 'emp is ::'|| v_eid);End;/

xambrose

 Profile Answers by xambrose Questions by xambrose

• Jul 19th, 2008

create proc test1(@x integer)asbeginSELECT empid  FROM   (SELECT empid  FROM emp ORDER BY empid )   WHERE ROWNUM = @x;end

Answer Question  Select Best Answer