i am so beginner to oracle but i know the basic fundementals of database ?
121764
Again, i don't know what is exactly what you want to learn, but i am sending the link to Oracle Technology Network again....\n\nhttp://www.oracle.com/technology/developer/index.html
37509
Oracle is actually a database system that is used companywide.  For example - shipping, receiving, accounts payable, accounts receivable, purchasing, etc - all work from the same database.  It could also be called an enterprise system.  or an MRP system.  Contact Oracle to find information on becoming a certified Oracle expert, there is more than one Oracle certification.
598194
Great little PDF here for you..\n\nhttp://www.oracle.com/technology/sample_code/tutorials/jsp20/files/jsp2.pdf
123256
Both Oracle 9i Database and IBM DB2 Universal Database v8.1 support the ANSI SQL-92 entry level and do not support the ANSI SQL-92 intermediate level.\n\nThe dialect of SQL supported by Oracle 9i Database is called PL/SQL. The dialect of SQL supported by IBM DB2 v8.1 is called DB2 SQL dialect. \n\nFollowing is a brief comparison of PL/SQL and DB2 SQL dialect:\n\nIndexes  \n\nPL/SQL:\n\nB-Tree indexes,\nBitmap indexes,\nPartitioned indexes,\nFunction-based indexes,\nDomain indexes  \n\nDB2 SQL dialect:\n\nB-Tree indexes,\nBitmap indexes,\nPartitioned indexes,\nblock indexes,\ndimension block indexes  \n\nTables  \n\nPL/SQL:\n\nRelational tables,\nObject tables,\nTemporary tables  \n\nDB2 SQL dialect:\n\nRelational tables,\nObject tables,\nTemporary tables  \n\n\nTriggers  \n\nPL/SQL:\n\nBEFORE triggers,\nAFTER triggers,\nINSTEAD OF triggers  \n\nDB2 SQL dialect:\n\nBEFORE triggers,\nAFTER triggers,\nINSTEAD OF triggers  \n\nProcedures  \n\nPL/SQL:\n\nPL/SQL statements,\nJava methods,\nthird-generation language\n(3GL) routines  \n\nDB2 SQL dialect:\n\nDB2 SQL dialect statements,\nJava methods,\nthird-generation language\n(3GL) routines  \n\nMultiple Triggers  \n\nPL/SQL:\n\nSupported  \n\nDB2 SQL dialect:\n\nSupported  \n\nArrays  \n\nPL/SQL:\n\nSupported  \n\nDB2 SQL dialect:\n\nSupported  \n\nIt is not true that Oracle Database is better than DB2 Universal Database or vice versa. \n\nBoth products can be used to build stable and efficient system and the stability and effectiveness of your applications and databases depend rather from the experience of the database developers and database administrator than from the database's provider.\n\nSince both of them support ANSI SQL-92 which means all your SQL commands can work on Oracle which you used on DB2.\n\nWorking knowledge of both the products will be more or less the same however the architecture will be different.\n\nBut I recommend you apply for the programming job that requires your knowing Oracle. Refer to some Oracle books before going for interviews. Visit http://www.sharanamshah.com for book details.
266887
So some searches on Yahoo for java, VB and oracle.\nThis should give you some information, and ideas on what they are, and how to use them.
290044
The best place to start is with "PHP/MySQL for Dummies".  It's now out of print, but you should be able to find it on eBay or try Google.  Amazon also sells used copies.  Once you have a basic understanding of PHP and MySQL, there are LOTS of great books for beginners through professional.  Do a search on Amazon for that.\n\nThe documentation at php.net is good, but it's a little too technical for those new to PHP and MySQL.\n\nGood luck!
353593
A freeware version is Open Office, does the same job but its free.\nhttp://www.openoffice.org\nYou can also download the tutorial.\n\nThe trick with databases is to organise the info properly first. Think about the types of info, write it out on paper and try a few different things. Think about how people will use the database, how will they want to retrieve the info.\nSome people have a real knack for databases; it migh be best to have one or two members of staff whos job it is to build and maintain the database; and assist anyone who gets stuck.
254536
From your point, i think you want to creata an authentication application and you want the authentication will be done using database. That database stores all username, and password. Am i right?\nPlease state what programming language do you intend to use?
545905
Using either PHP or ASP use ADO to establish your connection to either database and fetch your data that way.  You will need to install the Oracle OLE or ODBC driver.  I have not done this in the Unix / Linux world but it is so easy to do in the windows world.  Here is the ado connection strings you will need to do it.  I know this is written for Windows but it is somewhat similar in the Linux / Unix world.\n\n\nhttp://www.carlprothman.net/Default.aspx?tabid=81
243718
database is like a huge table with information or entries.  Like information of similar groups of different records.  Dbms is basically, mananing all of those records.  Also database is storing as well as retreiving.
165048
heres some code from a old ASP.NET application I found (the database connection string should be 1 line)\n\nDim Public DBS as String = "PROVIDER=Microsoft.Jet.OLEDB.\n4.0; DATA Source=c:&#92;DataBase.mdb"\n\n\n\nDim myconnection as oleDbConnection = new oleDbconnection(DBS)\nmyConnection.open()\nDim myCommand as oleDbCommand = New OleDbCommand("Select * from Threads", myConnection)\nDim myDataReader as oleDbDataReader = myCommand.ExecuteReader()
617149
Place in the first CD and start the Oracle Installer. What you'll need to install on your computer is not only the Oracle database but also the Oracle server (which from wht I've heard can be configured and installed only on the same partition windows is installed...). Then you'll be prompted for what kind of database do you want to configure on your system (depends..). After this Oracle will copy all the files needed... You'l have a hard time configuring users password, group id's in Oracle 9i...
364399
Hai Shaam,\n     I assume that you are successful in obtaining aconnection to the \nOracle Table, If not please code as necessary like\ntry{\nClass.forName("sun.jdbc.odbc.JdbcOdbcDriver")\nConnection con=DriverManager.getConnection("jdbc:odbc:<dsnname>", "<userid>","<password>");\nStatement stm = con.createStatement();\nResultSet rs = stm.executeQuery(<sql query>);\n// you will get each value by using\n//rs.getString(<index>) then store it in an array\n//display it to output,\n//if you need to display it in an output table in java\n//you can use JTable in the swing library.\n}\ncatch(Exception e){}\n\nfor further details you can contact me\n\nemail:ananthasivanvk@gmail.com\ncell:+919995403653
511477
Oracle Naming Conventions\nNothing is carved in stone, but these are the sort of rules I follow:\n\n    * Entities & Tables\n    * Aliasing\n    * Attributes & Columns\n    * Keys & Their Columns\n    * Indexes\n    * Triggers\n    * Other Objects\n    * PL/SQL Variables\n    * File Extensions\n\nEntities & Tables\nAll entity names should be singular and may have spaces. These are replaced with '_' by Oracle Designer during table creation:\n\n    APPLICATION\n    APPLICATION FUNCTION\n    APPLICATION FUNCTION ROLE\n\nAll table names should be plural. If the table name contains serveral words, only the last one should be plural:\n\n    APPLICATIONS\n    APPLICATION_FUNCTIONS\n    APPLICATION_FUNCTION_ROLES\n\nAliasing\nAll entities and tables should be defined a unique alias that is used as part of the foreign key definitions. The alias should be an abbreviation of the name such that:\n\n    APPLICATIONS = APPL (4)\n    APPLICATION_FUNCTIONS = APFU (2:2)\n    APPLICATON_FUNCTION_ROLES = APFR (2:1:1)\n    APPLICATION_FUNCTION_ROLE_BANANAS = AFRB (1:1:1:1)\n    APPLICATION_FUNCTION_ROLE_BANANA_APPLES = (Do what you like!)\n\nThe bracketed numbers indicate the number of letters used from each word in the name.\n\nOracle has a 30 character restriction on object names, so table aliases are useful to reduce the length of object names.\nAttributes & Columns\nAttributes and columns should not be prefixed with a table alias. For the most part this is unnecessary and often very messy.\nKeys & Their Columns\nPrimary Keys are named after the table or its alias with the suffix of '_PK':\n\n    Table      : APPLICATIONS\n    Primary Key: APPLICATIONS_PK\n                 or\n                 APPL_PK\n\nUnique Keys are named after the table or its alias with the suffix of '_UK'. If more than one unique key is present you may need to add further information to make the key name unique:\n\n    Table      : APPLICATIONS\n    Unique Key : APPLICATIONS_UK\n                 or\n                 APPL_UK\n\nForeign Keys are usually named using the two table aliases, from and to, with the suffix of '_FK':\n\n    Relationship: APPLICATION_FUNCTIONS -> APPLCIATIONS\n    Foreign Key : APFU_APPL_FK\n\nThe foreign key column on the dependant table may be named using the full table name or the alias, along with the column name such that:\n\n    APPLICATION_FUNCTIONS.APPLICATION_ID -> APPLICATIONS.ID\n    or\n    APPLICATION_FUNCTIONS.APPL_ID -> APPLICATIONS.ID\n\nI prefer the full table name, but the the 30 character limit forces the use of the alias at times.\nIndexes\nIndexes are created implicitly to support PKs and UKs. These indexes have the same name as the constraint.\n\nAs a rule of thumb, all foreign key columns should be indexed. Indexes to support foreign keys should be named using the foreign key name with the suffix '_I':\n\n    Foreign Key    : APFU_APPL_FK\n    Suporting Index: APFU_APPL_FK_I\n\nOther indexes should be created with meaningful names, usually incorporating the table alias and the column name(s) where possible, along with the suffix '_I'.\nTriggers\nTrigger names should be made up of the table name, an acronym representing the triggering action and the suffix "_TRG":\n\n    Table : APPLICATIONS\n\n    Action: BEFORE INSERT STATEMENT-LEVEL\n    Name  : APPLICATION_BIS_TRG\n\n    Action: AFTER INSERT AND UPDATE ROW-LEVEL\n    Name  : APPLICATION_AIUR_TRG\n\nOther Objects\nOther database objects have a suffix that identifies their object type:\n\n    Check Constraints : <name>_CHK\n    Sequences         : <name>_SEQ\n    Views             : <name>_V\n    Materialized Views: <name>_MV\n    Types             : <name>_T\n    Directories       : <name>_DIR\n    External Tables   : <name>_EXT\n    PL/SQL Packages   : <name>_API\n    PL/SQL Procedures : <name>_PRC\n    PL/SQL Functions  : <name>_FUN\n\nPL/SQL Var
67849
http://www.orafaq.com/\n\nhttp://www.peoplesoft.com/corp/en/public_index.jsp\n\nhttp://www.db.cs.ucdavis.edu/teaching/sqltutorial/\n\nhttp://en.wikipedia.org/wiki/Oracle_database
643624
Read this short review:\nhttp://en.wikipedia.org/wiki/DBMS
419125
There is a lot of useful information on ADO and Delphi here:\nhttp://delphi.about.com/od/database/\n\nThis might be of some use - sorry I can't help more, despite being a Delphi buff I don't know much about database connectivity.\n\nRawlyn.