Hi All,
I have 2 tables with the following data.
Table1
Col1 Col2
a b
a c
a d
a e
Table 2
Col1 Col2
a 1
a 2
a 3
I have to write query that will get
a b 1
a c 2
a d 3
a e null
Thanks
kewldudehere
Last Activity: Dec 19 '08, 04:04 PM
Joined: Jan 2 '07
Location:
-
I get one row for each iteration. I am inserting that row in temporory table. After for loop, i open cursor for that temporory table and return it.... -
Hi Amit,
I am doing
for i=1..count loop
Insert into table(col1,col2 ,col3)
select c1,c2,c3 from table where id=i
End loop
So i get 1 row for each iteration in for loop which i am iserting in a table. After i am done with for loop ,I have opened a ref_cursor forthe table in which i have inserted and returning that Ref_cursor back.
But this is very slow since there its doing a insert to a...Leave a comment:
-
Hi,
Its confusing. Du want me to output refcursor from SP or Package? I have never used package. If possible can you wite me a sample one and how to call it.
ThanksLeave a comment:
-
Using Collections in PL/SQL
Hi All,
I have a Stored Procedure in which i have a for loop .In this loop i have a select statement and the returned row i am storing in a temporary physical table like
for cntr in 1..count loop
insert into temp(col1,col2, col3)
select col1,col2,col3 from table connect by id1=id start with id=cntr;
End loop;
And in the front end i am reading values from that temp table.
... -
Hi ,
I am getting error at 'Prior' as 'ORA-00920: invalid relational operator
' .
I am using Oracle 9i.Leave a comment:
-
Hi saii..,
But i have some data where employee is same as manager i.e top level person reports to himself. so i i use the above query i am getting an error 'connect by loop in user data'. I want to get the top level manager too...Leave a comment:
-
hi saii,
this is exactly wat i want..thanks a lot.Leave a comment:
-
Query Help
Hi All,
I have a data in table as follows.
Employee Manager
b a
c b
d c
I should write a query that will get 'b','c','d' for 'a'. -
Generate a Table
Hi all,
I have to generate this table with the following structure in vb.net 2k5
col1 col2 col3
*************** ******* 1
a ********** x******* 2
********** ******* 3
********** y ******* 4
********** ******* 5
b ********** p******* 6
********** ******* 7
c ********** z ******* 8
The data comes from the... -
' not in ' function syntax.
Hi All,
I am trying to execute this kind of query that uses'Not in ' function but unable to get 'Nulls'
select * from table1 where col1 not in (select col2 from table2).
Here col1 is not primary key in table1 and col2 is not foreign key for col1. They store same kind of data.
There are few nulls for col1 in table 1 and no nulls for col2.
If i execute the above statement , the rows with nulls... -
Compare / copy Datatables
I have two datasets with same no.of columns.
I should read one dataset and if that row is in the second dataset then i have to add that row to new dataset/datatable else i have to add the row from the firstdataset.
Finally the third dataset should have the same no.of rows as in the first dataset. -
Disable Items in DropDownList
Hi All,
Is it Possible to disable or greyout some items in dropdownlist. My application is role based and want to disable selection of some items in dropdownlist based upon user role. But i want to show all items in dropdownlist.
Thanks -
I have to use a Javascript. But currently i am not displaying any alert boxes. I need to display something where user has to enter a valid reason and read that and store back into database....Leave a comment:
-
I am developing an Asp.NET application....Leave a comment:
-
Reading from MessageBox
Hi Frinavale,
Hope You remember me. I just want to ask you quick Question. How to read from MessageBox. I need to implement something like this.
There is a Manager who approves a record. If he want to reject, he can but need to supply some reason.
So before rejecting a record, i want to display a message like ' Please enter valid reason for rejection' . Then i need to read the reason...Leave a comment:
-
Reading from MessageBox
Hope You remember me. I just want to ask you quick Question. How to read from MessageBox. I need to implement something like this.
There is a Manager who approves a record. If he want to reject, he can but need to supply some reason.
So before rejecting a record, i want to display a message like ' Please enter valid reason for rejection' . Then i need to read the reason he enters and store it in the database.
I am using... -
HI.. these are the columns for first query for a particular role.
[code=asp]
<asp:HyperLinkF ield DataTextField=" WeekBeginningDa te"
DataNavigateUrl Fields="TimeCar dID"
DataNavigateUrl FormatString="A ctivityEntry.as px?id={0}"
HeaderText="Wee kBeginningDate"
...Leave a comment:
-
I tried to use asp:hyperlinkfi eld too...but no good...So what is the appropriate column should i use from the given columsn of gridview....Leave a comment:
-
Hi, its not working. Its throwing me a runtime error as column not bound.
The column name that does'nt appear for particular role , is not getting bound by datasource which is obvious and throwing a runtime error.
I have used asp:bound field for this column.
Any suggetsionsLeave a comment:
No activity results to display
Leave a comment: