Hi,
now run the quiery it will run properly.
create or replace procedure proc1
(emp_id in employees.employee_id%type,
emp_na out employees.last_name%type,
emp_sal out employees.salary%type,...
Type: Posts; User: su123; Keyword(s):
Hi,
now run the quiery it will run properly.
create or replace procedure proc1
(emp_id in employees.employee_id%type,
emp_na out employees.last_name%type,
emp_sal out employees.salary%type,...
According to your above code, if you give %rowtype, it will take all the columns and their datatypes from the table which you specified
( ex: in 'emp' if you are having 3 columns means it will take...
I'm also a mechanical engineer, never worry about your future in Software field. Here in software Industry no one will ask you the question “what is your branch in engineering”, once you got...
A full outer join retrieves all the records in the both tables,
for example on two tables using the ON clause. The full outer join can retrieve the records on both tables even if the data not...
HI,
ORA-12838 Can not read or modify an object after modifying it in parallel
The meaning of the error is:
Within the same transaction, an attempt was made to add read or modification statements...
The difference between the normal view and materialized view is, a normal view will have the statement only, whenever you try to open the view it will be compiled in that particular time and the...
Hi,
If you know the structures of all tables You will be having more chances of doing this type of quires in different ways.
for ex: If ur having related columns in each and every table use natural...
Hi,
the RR date format is similar to YY element, but you can use it to specify different centuries, you can use the RR date format element instead of YY.
so that the century of the return value...
How can we understand ur problem atleast you send your quiery to us,
then we will try to rectify it.
Hi krishna,
For handling this kind of situations we are having test engineers and QA’s, after testing also it fails means there will be plenty of reasons for that failure, ...
Hi babi,
Check here U will get good idea
http://www.itk.ilstu.edu/docs/Oracle/appdev.101/b10807/07_errs.htm
Byee sudheer
Hi babi,
If a transaction is updating data in a database, it gets an exclusive lock on that part of the database automatically. Up to this the Question is good After that you typed "Then what is the...
Create table entity_x
( a varchar2(20), b number(10), c date);
here we are creating a trigger;
create or replace trigger statement_level
before update on entity_x ...
&variable_name; (substitution variable)
:variable_name; (bind variable)
For example in a query such as:
OPEN CURSOR (&my_var)
OPEN CURSOR (:my_var)
Sorry I don’t know the exact difference...
Hi friends happy to join with you people, can u give me an example for using return data type in the procedures. Because I never used return in procedures, so kindly reply me.