Vaibhav Tyagi

• Sep 25th, 2007

You cannot move existing table into a cluster. You can create new tables though, including tables with the same contents as existing tables. In the second. form, query returns a set of rows which...

Answer Question  Select Best Answer

dinu78

 Profile Answers by dinu78 Questions by dinu78

• Dec 21st, 2007

1) First identify the current excecution plan by using showplan.In most cases, creating and then forcing usage of the indexes result in drastic improvement.1) Ensure that indexes(single or composite)&...

Answer Question  Select Best Answer

we have a PRIMARYKEY field with auto generation in sequence of a table of records. If we delete any one of records from the table, how can we update the table implicitly using Trigger?

amahanit

 Profile Answers by amahanit Questions by amahanit

• Dec 1st, 2007

Which table u want to update ,in case if it is the same table then write after delete  trigger on the table and select values from destination table.

Answer Question  Select Best Answer

SELECT APE.DAT_INSERT_DATE as "Payment Entry Date", Case when APE.TXT_INTERMEDIARY_CD is null or APE.TXT_PAYER_CUSTOMER_ID APE.TXT_INTERMEDIARY_CD then (Select TXT_CUSTOMER_NAME from GENMST_CUSTOMER where TXT_CUSTOMER_CD = APE.TXT_PAYER_CUSTOMER_ID) else(Select TXT_INTERMEDIARY_NAME from GENMST_INTERMEDIARY where TXT_INTERMEDIARY_CD = APE.TXT_PAYER_CUSTOMER_ID) End as "Payer Name" , APE.TXT_PAYER_CUSTOMER_ID...

joybanerjee

 Profile Answers by joybanerjee Questions by joybanerjee

• Dec 20th, 2007

create or replace procedure sql_to_procedure as declare cursor c1 is SELECT APE.DAT_INSERT_DATE as "Payment Entry Date",APE.TXT_INTERMEDIARY_CD AS "Intermediary ID",APE.TXT_PAYER_C...

Answer Question  Select Best Answer

prabhatushar

 Profile Answers by prabhatushar Questions by prabhatushar

• Oct 31st, 2007

ORA - 01426 is associated with Numeric  overflow Cause : Evalution of an value expression causes an overflow or underflow.Action : Reduce the operand

Answer Question  Select Best Answer

gan20k

 Profile Answers by gan20k Questions by gan20k

• Jan 14th, 2008

This will delete Collection (eg index by table ) in the range 6,3

Answer Question  Select Best Answer

soorajsk_84

 Profile Answers by soorajsk_84 Questions by soorajsk_84

• Dec 19th, 2007

autonomous transaction  are independent transaction exCREATE OR REPLACE PROCEDURE a1ASPRAGMA AUTONOMOUS_TRANSACTION; BEGININSERT INTO table1 VALUES('autonomous transaction');COMMIT; END;D...

Answer Question  Select Best Answer

How to pass result set using refcursor from one package procedure to another package procedure? and code also

MAQDOOMAAMER

 Profile Answers by MAQDOOMAAMER Questions by MAQDOOMAAMER

• Dec 25th, 2007

CREATE TABLE employees (empid   NUMBER(5),empname VARCHAR2(30));INSERT INTO employees (empid, empname) VALUES (1, 'Dan Morgan');INSERT INTO employees (empid, empname) VALUES (2, '...

Answer Question  Select Best Answer

What are the diffrences between Oracle 8i and Oracle 9i as a Developer, not as a DBA??

bismitapadhy

 Profile Answers by bismitapadhy Questions by bismitapadhy

• Feb 3rd, 2008

ISQl*plus and J-server is not there in oracle-8i which are there in 9iBismita

Answer Question  Select Best Answer

What exactly the difference between 'TABLE OF' and 'REF CURSOR' in PL/SQL?For what purposes these both might be used?

krishnaindia2007

 Profile Answers by krishnaindia2007 Questions by krishnaindia2007

• Jun 1st, 2008

A ref cursor is a dynamic cursor in which the contents of cursor can be changed dynamically at run time depending upon our requirement.A ref cursor is basically a data type. A variable declared based ...

Answer Question  Select Best Answer

What is the difference between a package and a module?

tariq_oracle

 Profile Answers by tariq_oracle Questions by tariq_oracle

• Apr 13th, 2008

Module is a collection of Package

Answer Question  Select Best Answer

What is the difference between Nested Table and Normal Table?

garvi.1983

 Profile Answers by garvi.1983 Questions by garvi.1983

• Mar 5th, 2008

Normal Table : It contain rows and columns.Each Row-Column represente only one value i.e intersection of Row-Columncreate table t1(col1 number(10), col2 varchar2(9));------>Creates normal tabl...

Answer Question  Select Best Answer

What are analytical functions and how are they used?

singh.neerajin

 Profile Answers by singh.neerajin Questions by singh.neerajin

• Jul 22nd, 2008

Analytic functions compute an aggregate value based on a group of rows. They differ from aggregate functions in that they return multiple rows for each group. The group of rows is called a window and ...

Answer Question  Select Best Answer

How to skip columns while loading data with SQLLDR

lokeshRao

 Profile Answers by lokeshRao Questions by lokeshRao

• Jun 23rd, 2008

Specify Filler Load datatruncate into table empfields treminated by'|'(field1,field2 filler,field 3)

Answer Question  Select Best Answer

Hi,There is problem with ult_file.fopen. When I run from the server side, there is no issue with utl_file and it is working fine.If I run the same procedure from Client machine, I am facing problem. It throws an exception Invalid_operation.I am using Oracle 8.2 and Unix server.Can you please let me know what change needs to be done? Is this related to permission issue.Thanks & Regards,Ananth P

stshekhar

 Profile Answers by stshekhar Questions by stshekhar

• Jun 22nd, 2008

the parameter set in configuration file init.oraand UTL_FILE_DIR belongs to the directory structure in oracle server machine. And the directory structure should be on same machine as oracle server. Th...

Answer Question  Select Best Answer

How can i schedule a procedure every day at 10 pm

rajivgupta780184

 Profile Answers by rajivgupta780184 Questions by rajivgupta780184

• Aug 13th, 2008

This is the sample code you have to adjust time according to your requirementSET AUTOPRINT ONVAR jobno NUMBER;BEGIN DBMS_JOB.SUBMIT(:jobno, 'JOBNAME;', TRUNC(SYSDATE) + 6/24, 'TRUNC(SYSDATE + 1) + 6.183/24'); COMMIT;END; ThanksRajiv
GuptaYogik Technologies Pvt. Ltd.

Answer Question  Select Best Answer

How can i choose which query is best?i.e On which factors i can choose the best query?

madanuprashanth

 Profile Answers by madanuprashanth Questions by madanuprashanth

• Jul 18th, 2008

By forcing the SQL engine to use indexes.If query is too much nested then break it into two or three queries using temp tables and then write one query by joining these temp table to perform the task.

Answer Question  Select Best Answer

How to fill a refcursor with dataset in C#.i want to pass a dataset as parameter and fill a refcursor with the same dataset.

viv_mca

 Profile Answers by viv_mca Questions by viv_mca

• Jul 31st, 2008

you need to use ODP.Net connector.In OracleCommand object add OracleParameter object with following propertiesOracleDbType = OracleDbType.RefCursor;Direction= ParameterDirection.Output;give the name of your stored procedures's refcursor parameter name

Answer Question  Select Best Answer

How to load whitespace delimited data using SQL*Loader?

psingla

 Profile Answers by psingla Questions by psingla

• Apr 21st, 2010

1. Create a ontrol file with extn (.ctrl). This file will map the flat file data with the Oracle table columns.2. Pass control file as one of the parameter of SQL Loader.

Answer Question  Select Best Answer

Define External Table

lanka_satya

 Profile Answers by lanka_satya Questions by lanka_satya

• Sep 12th, 2008

it is same as oracle table but act as view to the data available in an external file of a physical drive,so here we can query the data and retrieve and can do anything but cannot do manupulations on the data

Answer Question  Select Best Answer