Recent content by Abhivyakti

hi arpan, EXISTS works out in the query along with Where clause. So try using it in the where clause. It will not work with exists i guess. As your query will bring only true or false when u use exists in the where clause.... u can then check, if true give a msg otherwise give another msg. hope...

hi arpan try visiting sqlcourse.com or sqlcourse2.com for tutorials abhivyakti

start with the site sqlcourse.com or sqlcourse2.com abhi

hi, As far as the new features in 9i are concerend, its a wide range of new keywords, new fundas made in this release. But to mention a few there are new things in SQL and in PL/SQL there are new things like ONline Table redifinition, Resumable tablespaces, new functions in ranking and...

hi, I also got the same error regarding hte external tables. The thing is, when i say desc the external table schema, its showing me the details of columns for the external table. But when i actually give the command select * from ext_tab then it gives me the same error. My logic is it is not...

hi some more sites orakle.com orafans.com orapub.com orafaq.com regards abhivyakti

hi there are some sites you can get some quick info about PLSQL. sqlcourse.com sqlcourse2.com dbasupport.com some site with a name containing pipeline plsql archives. (sorry i dont remeber the full name.) Oreially.com is another site where you can see some sample chapters free (belonging to...

yes for sure you need another privilege on that column from another schema. That is 'REFERENCES' privilege. The other schema owner should grant you that privilege on that table. Abhivyakti

hi Nitin, I dont know about this althought i know 8i and 9i. But i m pasting here the erro msg and the action to be taken for it. This is from Oracle documentation. May be that helps you to understand . I have also tried to complie the procedure on my mahcine but first, i think its not able to...

hi again, I m almost pasting a whole article i found just now on stylusinc.net hope this will also help. Oracle9i - Unicode What is Unicode? Unicode is a universal encoded character set that allows you to store information from any language using a single character set. Stylus Systems is...

hi there, There is a little difference in between teh UTF16 adn UTF8 in the way they will store the data. Also one is variable length while the other is fixed length. Also there are 2 ways youcan design your database to incorporate NLS support for Unicode. One is 'Unicode Database' other is...

yes surely you can have a numeric value generated automatically by a database object called sequence. For this you have to use the standard syntax of create sequence seq1 start with 1 increment by 1; This will create a value each time incremented by one. Whenyou want to use this in the table...

hi yes there is a lot of difference in 8/8i and 9i release. There are new documents in the 9i documentation. But there isnot just one book which i can suggest which will be sortof summary what u wnat to read. The thing is, there are all diferent areas where new features have been implemented...

Yes you can have only one date time field which will give you this data u need about diff time zones from one and hte same value in diff. timezones. abhivyakti

hi at sql prompt type set autotrace on explain plan SQL> set autotrace on explain plan<enter> this should work