Search results for query: *

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

hi Yes you can do that. For that you have to write the when clause before the begin. You may trap the 'user' values to check if it is the user you want to track down. And when clause will make sure that this trigger , although it is on DML stmt on a particular table, it will still check the...

hi, For every DML statement that you would execute at SQL promp you can obtain the execution plan for it, provided you have the plan_table created in ur schema. If you don't have this plan_table created, then u hve to run the script file called utlxplan.sql (The name of the file may be a...

hi Access is not a reliable front end. You should use better frontends which allow you to write proper programs. Acecss is like a smallscale dbms with the inbuilt functionality of creating forms for those tables which are created in the database. abhivyakti

hi you need to put thisinfo in tnsnames.ora fie. So create one entry for ur new hostname which tracks the machine on which ur dataase is installed. a sample for that would be newname= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = servername or machine...

hi, For using form, you need Developer isnt it? I mean form is a visual tool that comes with Form Developer which is nother utility or product given by Oracle Corpn. I don;t think there is any other wya to create a form, unless you have another client application developer programming tool...