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.

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.

tatz funny.
thanx.

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.

thanx

hi,
Can anybody tell me how to write a query to retrieve all the column names of a table?
thanx.

I think Simon understands my question.
thanx to all of you.

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 .

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.

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.

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

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.

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,
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.