What are the restrictions on cursor variables?Thanks ramki, hyd, tcs
Cursor Variable RestrictionsCursor variables are subject to the following restrictions; Oracle may remove some of these in future releases. Cursor variables cannot be declared in a package since they ...
cursor variable can't use with dynamic sql.
cursor variable can't use with in package because it is not having persistent state.
nulls can't assinged to cursor variable.
remote procedure can't accept cursor variable
How can I create a new table by using other two table's values.
create table new_employees
as (select e.employee_id, e.first_name, e.last_name, d.department_name, d.department_id,c.location_id, c.city from employees e, departments d, locations cwhere e.department_id = d.department_idand d.location_id = c.location_id);
create table table_name as( select tab1.column1,tab1.column2,tab2.column3 from table_name tab1,table_name2 tab2 where tab1.colum1=tab2.column4);
How to disable multiple triggers of a table at at a time?
SQL> Spool c:tempdisable_all_trigger
SQL> Select 'ALTER TRIGGER '|| trigger_name ||' disable;' from user_triggers;
SQL> spool off
after that open file disable_all_trigger.lst and remove header part and save file.
Can I change the elements of listitems at runtimes?
Hi.. We can change the elements of listitems at runtime with the help of Record Group
Give the structure of the function ?
function name (argument list .....) return datatype is local variable declarations begin executable statements exception ...
create or replace function function_name(formal parameters list with only IN mode)
local variable declarations
What is the difference between a reference cursor and normal cursor ?
we can use Ref cursor as an IN OUT parameter .
Normal cursor is used to process more than one record in plsql.
Refcusor is a type which is going to hold set of records which can be sent out through the procedure or function out variables.
How to view the contents of tables created by the following procedure after the loop?Create or replace procedure a0_bulk_collect_test is type employee_mrno is table of a_registration_header.Arh_mr_num%type;...
select text from user_source
select * from user_objects where type='procedure' and name='function or procedure name'
What is datatype of x when we say define x in Oracle
define is use for predefine variable
its depends on user. You can use char or number
How we can create a table in PL/SQL block. Insert records into it??? Is it possible by some procedure or function?? Please give example...
I traied with the DBA previlage but... again the same prob.. proc created but table is not thea... ok I tried u r proc and mail back to you...
You are right Maria Antony, but the question is, why is it not possible to create the table thru the procedure while you can create the sametable using create table SQL command.The answer is, to creat...
How to display the contents of a current record fetched in a ref cursor
by making use of sql%rowfound.
Hi,You could do the same as given under below for emp table.....CREATE OR REPLACE procedure procasbegindeclarev_empno emp.empno%type;v_ename emp.ename%type;cursor c_emp isselect empno,ename from emp;b...
How to handle exception in bulk collector?
During bulk collect you can save the exception and then you can process the exception.Look at the below given example:DECLARE TYPE NumList IS TABLE OF NUMBER; num_tab NumList := NumList(10,0,11,1...
DECLARE TYPE NumList IS TABLE OF NUMBER; num_tab NumList := NumList(10,0,11,12,30,0,20,199,2,0,9,1); errors NUMBER;BEGIN FORALL i IN num_tab.FIRST..num_tab.LAST SAVE EXCEPTIONS DELETE *...
What is the datatype of primary key?Is it binary integer..I'm not sure..1.Varchar22.Char3.Binary integer4.Number
Its Binary Integer
is it number or binary integer?
In a distributed database system can we execute two queries simultaneously ? Justify ?
Its depend upon the query. If the two queries are firing on the table it is not possible. If the queries are firing on different different tables then it is possible.
Thanks & Regards
As Distributed database system based on 2 phase commit,one query is independent of 2 nd query so of course we can run.
#1 what are the advantages and disadvantages of using PL/SQL or Java as the primary programming tool for database automation.#2 will Java replace PL/SQL?
Internally the Oracle database supports two procedural languages, namely PL/SQL and Java. This leads to questions like "Which of the two is the best?" and "Will Oracle ever desupport PL/SQL in favour ...
What is PL/SQL tables?Is cursor variable store in PL/SQL table?
DECLARE TYPE EmpCurTyp IS REF CURSOR; // Reference Cursor - weak TYPE NumList IS TABLE OF NUMBER; // Table of Number TYPE NameList IS TABLE OF VA...
Pl/Sql Table is like C Array .
Cursor variable doesn't store with pl/sql Table .
IT is a pointer to cursor & it is not item, It is dynamic.
What is data concarency and consistency?
Data concarency => means that many users can access data at the same time.Data consistency => means that each user sees a consistent view of the data, including visible changes made by the user's own transactions and transactions of other users.
types of triggers
What is crosstab
create table src_table(col1 varchar2(10),col2 varchar2(10),col3 varchar2(10),col4 varchar2(10),col5 varchar2(10));insert into src_table values ('A', 'B', 'C', null, null);insert into src_table values ...
to create a result set where the rows need to be columns, or vice versa. You need to "pivot" rows into columns, or vice versa. this is where you need to look at a pivot (or crosstab) query.
Describe in brief some of the featurs of Oracle9i.What is logminer?
LogMiner is a powerful audit tool for Oracle databases, allowing administrators to easily locate changes in the database, enabling sophisticated data analyses, and providing undo capabilities to rollback logical data corruptions or user errors.
What happens when a package is initialized ?
when a package is initialised that is called for the first time the entire package is loaded into SGA and any variable declared in the package is initialises.
Backup and Recovery
Concepts and Architecture
Oracle Forms 4.0
RMAN Interview Questions
Importance of an MBA for an entrepreneur
How do you handle conflict?
Give me good reasons why should I choose you over others.
What was the most important decision you ever had to make?
Tell me three things about you, which are not found in your resume
Describe a time when you had to listen to someone.
BPO Career for BTech Graduates
How do you handle pressure and stress?
What do you do when things do not go as planned? Cite an example.
What is your way of building rapport with a person you just met?
Ask Interview Question?
Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.