Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Abhivyakti
  • Order by date
  1. Abhivyakti

    EXISTS

    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...
  2. Abhivyakti

    What Does This Mean?

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

    How to get started

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

    New features

    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...
  5. Abhivyakti

    external table

    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...
  6. Abhivyakti

    Need opinions on Oracle Paradigm please!

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

    Need opinions on Oracle Paradigm please!

    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...
  8. Abhivyakti

    Foreign key to another schema

    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
  9. Abhivyakti

    Stored Procedure execution

    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...
  10. Abhivyakti

    Oracle 9i 92010 National Character set: AL16UTF16

    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...
  11. Abhivyakti

    Oracle 9i 92010 National Character set: AL16UTF16

    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...
  12. Abhivyakti

    Generate and Auto Number

    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...
  13. Abhivyakti

    is there a comparison of 9i and 8.1.7

    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...
  14. Abhivyakti

    New Datetime with timezone type

    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
  15. Abhivyakti

    How can I obtain the execution plan of a SQL statement?

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

    User Trigger

    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...
  17. Abhivyakti

    How can I obtain the execution plan of a SQL statement?

    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...
  18. Abhivyakti

    Problems with Oracle 9i as backend and Access 2000 as frontend

    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
  19. Abhivyakti

    sqlplus problem on oracle 9i DB

    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...
  20. Abhivyakti

    Forms

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

Part and Inventory Search

Back
Top