try to put cast or convert functions
i think it will help u.....
smruti
Last Activity: Mar 18 '08, 11:41 AM
Joined: Mar 18 '08
Location:
-
oracle8i
1) only rbo(rule base optimizer)
2)no merge statement available
3)no full outer join available
4)no timestamp datatype available
5)sql and pl/sql engine are different engine.
Oracle9i
1)both RBO and CBO(cost base optimizer)
2)MERGE is there.
3)FULL OUTER JOIN is there
4)TIMESTAMP is there
5)SQL AND PL/SQL ENGINE IS INTEGRATED INTO SINGLE ENGINE
...Leave a comment:
-
[quote]
how can i retrieve values of indexname? can i use these index values for ny other purposes? in what way i able to manipulate these index values?
say an example nextval & currval is used for manipulate sequence numbers
Try to run this
[code=oracle]
SELECT * FROM user_indexes WHERE index_name = 'xyz'
[/code]
Hope it will fullfil ur...Leave a comment:
-
[QUOTE=jeronjais on]hey i got an errror in my program can u help me............. .....
using system.data;
using system.data.sql client;
sqlconnection con;
sqlcommand cmd;
slqdataadapter da;
dataset ds;
pageload
{
sqlconnection con=new sqlconnection(" server=.;databa se=employee;uid =sa");
con.open();
sqlcommand cmd=new sqlcommand("sel ect...Leave a comment:
-
-
not good buddy...
Try to write some meaningful informations.Leave a comment:
No activity results to display
Leave a comment: