-
Which error is associated with this ORA-01426?
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
-
What does a following command do. DELETE (6,3);
-
What is autonomous transaction in Oracle ?
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...
-
Oracle refcursor and procedure
How to pass result set using refcursor from one package procedure to another package procedure? and code also
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, '...
-
Difference between Oracle 8i and Oracle 9i as a Developer
What are the diffrences between Oracle 8i and Oracle 9i as a Developer, not as a DBA??
bismitapadhy
- Feb 3rd, 2008
ISQl*plus and J-server is not there in oracle-8i which are there in 9iBismita
-
Difference between 'TABLE OF' and 'REF CURSOR'
What exactly the difference between 'TABLE OF' and 'REF CURSOR' in PL/SQL?For what purposes these both might be used?
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 ...
-
Package and Module
What is the difference between a package and a module?
-
Nested and Normal Table
What is the difference between Nested Table and Normal Table?
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...
-
Analytical functions
What are analytical functions and how are they used?
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 ...
-
Skip Columns with SQLLDR
How to skip columns while loading data with SQLLDR
lokeshRao
- Jun 23rd, 2008
Specify Filler Load datatruncate into table empfields treminated by'|'(field1,field2 filler,field 3)
-
Problem with Utl_file.fopen
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
- 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...
-
Job scheduling
How can i schedule a procedure every day at 10 pm
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. -
How do you Optimize query
How can i choose which query is best?i.e On which factors i can choose the best query?
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.
-
Filling a ref cursor
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
- 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
-
Load White Space Delimited Data
How to load whitespace delimited data using SQL*Loader?
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.
-
External Table
Define External Table
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
-
Call PL/SQL function
How to call a PL/SQL function in another PL/SQL function? Is it possible? Give example?
Jirange
- Nov 7th, 2008
Eg,create or replace fun_1 return varchar2asddmmyy varchar2;beginselect sysdate into ddmmyy from dual;end fun1;in above example function fun_1 calling another function (i.e. sysdate) thro' select statement. this way you can call any function in pl/sql function
-
Send Email from Oracle Procedure
How to send Email via PL/SQL Procedure?
rajivgupta780184
- Nov 24th, 2008
rem -----------------------------------------------------------------------rem Filename: smtp.sqlrem Purpose: Send e-mail messages from PL/SQLrem Notes: ...
-
SQL Query Tuning Considerations
While tuning SQL query what should be taken into consideration?
edarasatish
- Jun 23rd, 2009
During the SQL tuning, there couple of things need to be considered1. If it is below Oracle 9i we need make sure about the driving table concept (Since it uses RBO - Rule Based Optimization), which im...
-
BulkBind
What Is BulkBind? When it is used?
saishradha
- Nov 27th, 2008
Bulk Bind is the facilty through which we can INSERT, UPDATE, DELETE or SELECT from records from a table in bulk rather than multiple individual statments..Suppose you have 10 inserts to be made so yo...
PL/SQL Interview Questions
Ans