I want to apply for a programming job that requires me to know Oracle. I have never worked on Oracle before but i have worked with DB2 with SQL. Is it fair to say that DB2 is generally the same as Oracle in terms of programming?
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.
461679
when you have specific questions like that, make the search (yahoo/google) your friend.  That's how all programmers get quick information.  Do you have to use access?  SQL Server is so much easier to use and more robust.
145382
Use the link below to visit the download server of Oracle...\nhttp://www.oracle.com/technology/software/index.html\n\nAll downloads are FREE under the Developer License which allows you to use full versions of the products only while developing and prototyping your applications....\n\nRead the License Agreement for more information about licensing...
347108
You need to identify your database requirements.  Simply moving to a proper relational database is likely the right move, but you might want to identify the restrictions around your choice:\n\n- operating system\n- programming environment (what will apps be written in)\n- price\n- volume of data\n- amount of concurrent users\n- level of database administration required\n- synchronization/replication\n- availability of help (online communities, etc...)\n\nFor my money, I would start of trying either:\n\n- Postgres\n- MySQL\n- SQL Anywhere Studio - Developer Edition\n\nThe latter is a great commercial-product choice because of the low cost of both licensing and of support, plus it has one of the best online communities going (the newsgroup "sybase.public.sqlanywhere.general" and other "sybase.public.sqlanywhere.*" newsgroups)\n\nLinks below should help.
119451
Firstly there's only one java language, which is written with several interfaces, but the java compiler is the same. \nThe syntax in Java is pretty much the same as in C++. The only thing is that Java is fully object oriented while C++ is only partially. Which means that if you write Java code, you have to declare classes, while C++ can run C codes which aren't object orinted, so you can write programs without classes. For VB tutorials try: \nhttp://www.programmingtutorials.com/vbnet.aspx
270606
In structured programming you make functions-sub procedures in a "nested" fashion. Several languages force you to use structured approach. OO languages USE structured programming at their core. The difference might be understood comparing the old BASIC where you wrote things like:\n10 CLS\n20 LOCATE 1,1: PRINT "HELLO"\n30 LOCATE 2,1: PRINT "Enter your name?"\n40 INPUT $NAME\n50 IF $NAME="JOHN" THEN PRINT "Hi, JOHN"\n60 IF $NAME="MARY" THEN GOTO 80\n70 PRINT "Hello, " & $NAME\n80 PRINT "BYE"\nThis is NOT structured... a structured approach would be:\n\nname=readname();\nwrite(name);\ncompare(name,"john")\n\n... and elsewhere you'd define each subroutine (readname, compare...)\n\nIn OOP you'd do something like\nname.compare("john")\n\nwhere name.compare is a function you'll define for the object 'name'.
492142
A simple SELECT statement is the most basic way to query multiple tables. You can call more than one table in the FROM clause to combine results from multiple tables. Here’s an example of how this works:\nSELECT table1.column1, table2.column2 FROM table1, table2 WHERE table1.column1 = table2.column1; \n\nIn this example, I used dot notation (table1.column1) to specify which table the column came from. If the column in question only appears in one of the referenced tables, you don’t need to include the fully qualified name, but it may be useful to do so for readability. \n\nTables are separated in the FROM clause by commas. You can include as many tables as needed, although some databases have a limit to what they can efficiently handle before introducing a formal JOIN statement, which is described below. \n\nThis syntax is, in effect, a simple INNER JOIN. Some databases treat it exactly the same as an explicit JOIN. The WHERE clause tells the database which fields to correlate, and it returns results as if the tables listed were combined into a single table based on the provided conditions. It’s worth noting that your conditions for comparison don’t have to be the same columns you return as your result set. In the example above, table1.column1 and table2.column1 are used to combine the tables, but table2.column2 is returned. \n\nYou can extend this functionality to more than two tables using AND keywords in the WHERE clause. You can also use such a combination of tables to restrict your results without actually returning columns from every table. In the example below, table3 is matched up with table1, but I haven’t returned anything from table3 for display. I’ve merely checked to make sure the relevant column from table1 exists in table3. Note that table3 needs to be referenced in the FROM clause for this example.\nSELECT table1.column1, table2.column2 FROM table1, table2, table3 WHERE table1.column1 = table2.column1 AND table1.column1 = table3.column1;\n\nBe warned, however, that this method of querying multiple tables is effectively an implied JOIN. Your database may handle things differently, depending on the optimisation engine it uses. Also, neglecting to define the nature of the correlation with a WHERE clause can give you undesirable results, such as returning the rogue field in a column associated with every possible result from the rest of the query, as in a CROSS JOIN. \nIf you’re comfortable with how your database handles this type of statement, and you’re combining two or just a few tables, a simple SELECT statement will meet your needs.
110344
Really it depends on which database u'd like to administer,you have two basic choices,\nwhether oracle or mssql server...\nBut i recommend microsoft sql server Coz it's very powerful database,\nonce u choose mssql server, you should go and take the MCDBA course.check it out on microsoft.com\nby the way,\nI've just finished this certificate :\nMicrosoft Certified Database Administrator\nif you wanna know more,\nu can contact me \nfadydodo2004@yahoo.com
86542
I believe all of us do have this question in the back of our minds, especially with the huge request of free source php programming, but i still think you do not need to make a huge jumpin your life in one day. so it would be better if you do what you are good at and gradually and smoothly work on projects in VB or .NET, untill you find professionalism in your work.  but i totally agree that the world is shifting towards .NET and Oracle programming but still huge and vast area of the world still using open source.
138945
Honestly, and technically, neither C nor C++ would work for database programming alone. C and C++ are the languages themselves. You'd have to use an API, like Win32 or MFC or .NET, in order to connect to a database. But I think the ATL library includes database connectivity.
96816
Firebird SQL is an open-source database engine. Firebird SQL server can handle multiple independent databases.\n\nWhy it is on your computer...I am not sure. Is it a work computer? Maybe a relative or friend installed it to use it or just play with it?\n\nYou can go to the link to learn more about it and get instructions on safely uninstalling the program.
374574
Hello,\nThe inner query, which is\n\nSELECT [Employee Information].FirstName, [Employee Information].LastName, Courses.CourseTitle, CoursesCompleted.CourseID\nFROM Courses INNER JOIN ([Employee Information] INNER JOIN CoursesCompleted ON [Employee Information].StudentID=Courses... ON Courses.CourseID=CoursesComple...\nWHERE (((CoursesCompleted.CourseID)=... THE COURSE NUMBER])))\n\nreturns a set of first names, last names, course titles and course id numbers; however you are checking whether >only< the first name and the last name of a particular employee is in that set. If I'm not mistaken, both sides of the 'NOT IN' clause should contain the same information. In this example, one side (outer query) contains the name of the employee, and the other side (inner query) contains the name of the employee + course information. \nTry this: in the second query select only the first and last name of the employee (not the course info) but keep the joins in the FROM clause.\n\nIf I had designed the tables, I would assign a unique id to each employee, just as courses have their unique course ids. It would have eased this task a lot.\n\nI know I sound confusing, but hope it helps
263712
Hi Sam,\n\nIf you're new to programming - but want a really robust solution - you should really check out Servoy. With Servoy you can deploy via client/server AND/OR the web at the same time from the same code base.\n\nThe programming language can be either JavaScript or inline Java - and there is a object model tree and you can double-click to create code. Also, there are "samples" for each of the available functions that will all work with a single click - so you can learn as you go.\n\nIt has point-and-click form control, and you can create relations between different tables (and even between different SQL database engines) with a few clicks - WITHOUT having to know any SQL programming.\n\nYou can have people log in without them having to install anything, and if, down the road, you want to offer offline capabilities - that's available as well.\n\nI would stay away from desktop database products like FileMaker, Access, etc. because they use proprietary databases, don't scale, are a NIGHTMARE to update on the client side, and are difficult to maintain.\n\nJust my $0.02 worth - I hope this helps.
508243
Queries can be a very complex things, involving one or more tables of the data-base.\n\nBut any example is specific to the DataBase structure you have. You can read a lot about SQL queries in the "mysql" (http://www.mysql.com/) documentation.
214477
if you have good programming capable go to programming side means either java or .net .other wise go to testing side. otter wise oracle apps.
328696
I doubt if you would get a job as DB admin as an OCA or OCP. It's better to just go for the OCM. So, if you have the OCP that's good, you might can get a job just doing SQL.\n\nI need to get my certs too.\n\nAlso, experience is the key. you might want to get a grip on Linux and script writing.
239181
Hi Johny,\n\nSAP is an ERP package having different modules which has been intergrated internally. Based on company structure they maintain different servers for their respective modules.\n\nWhile learning SAP you can choose either as a Functional consultant or a programmer [ABAP], a functional consultant involves less in code and more in defining/ customizing/ modelling according to the company structure.\n\nSince you know CRM concept i think it doesn't take much time for you to get into that, i suggest you to get trained as a functional consultant. make sure to get the full domain knowledge before you apply for the jobs.