raseena nm

Greenhorn
+ Follow
since Nov 07, 2003
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by raseena nm

hi,
I wanna create a table by fetching columns from two other tables?
For eg:
table -1
name
age
table -2
part1
part2
I wanna create a 3rd table with the following fields
name
age
part1
part2
Any kind of help will be appreciable?
thanx.
17 years ago
hi,
Im facing a problem.
I've a trigger which is getting fired while afteer insertion (statement)of a table.But that parent statement is not getting commited. I do wanna parent insert into be commited before firing the trigger or before trying to do some actions inside my trigger..
any kind of suggestions??thanx.
17 years ago
tatz funny.
thanx.
18 years ago
tanQ Mark for your answer.
But can you tell me how to use the 'CODE' tag that u've mentioned in the reply?
Im getting Invalid SQL statement while giving
CODE
above procedure.
thanx.
18 years ago
hi,
Can anybody tell me how to write a query to retrieve all the column names of a table?
thanx.
18 years ago
I think Simon understands my question.
thanx to all of you.
18 years ago
HI,
declare
cursor c1 is
select sid,scity
from supplier;
wrong_city exception;
begin
for s_rec in c1 loop
if s_rec.scity = 'bangalore' then
raise wrong_city;
end if;
end loop;
exception
when wrong_city then
dbms_output.put_line('wrong city');
end;
result:
SQL> /
wrong city
PL/SQL procedure successfully completed.

Here in my table 'SUPPLIER' i've more than 1 record which has the value 'BANGALORE'. But this code ends as sson as it got one record with the value 'BANGALORE'.
I want continue the loop until all the records are checking.
How can i go back to that FOR ..LOOP after fetching and displaying the exception?

can anybody give me the solution?
thanx .
18 years ago
HI all,
Is there any way to know that , which all fields in a table holds auto generated values?
for eg:
SQL> desc test_AUTO;
Name Null? Type
--------------------- -------- --------------------
VV NUMBER(10)

actually while inserting value to VV imj using sequence.
Here i know that VV is autogenerated.
But if i know only the structure of a table.How can i know that how many fields in that table holds autogenerated values??
thanx.
18 years ago
hi,
please check my code.
CREATE OR REPLACE TYPE MYEMPARRAY AS OPBJECT
(
EMPID NUMBER(5),
FIRSTNAME VARCHAR2(10),
LASTNAME VARCHAR2(10),
SALARY NUMBER(6)
);
CREATE OR REPLACE TYPE EMPARRAY is VARRAY(20) OF MYEMPARRAY;
Now anybody can tell me how to enter values to MYEMPARRAY object and how to retrieve values from that?
thanx a lot.
18 years ago
hi simon,
your info waz a valuable one for me.
But i wanna do it not for one dimensional array.
anyway thanx for your guidence
18 years ago
hi pradeep,
can u just give me a URL which will provide me the needed information.
I meant about varray and table.
Thanx a lot.
18 years ago
Hi,
Im working in struts framework. I've a JSP page with some hidden fields.
When i display that page first time, those fields are not visible.
Now i wanna display those hidden fields when im reloading the same page by clicking submitt button.
Thanx for your answers.
18 years ago
Hi,
Im working in struts framework. I've a JSP page with some hidden fields.
When i display that page first time, those fields are not visible.
Now i wanna display those hidden fields when im reloading the same page by clicking submitt button.
Thanx for your answers.
hi,
i wanna insert values to a table through stored procedure.
But the datas im gettiing from a java array.
Can anybody tell me how to pass an array to a stored procedure.
Thanx in advance.
18 years ago