Where can I learn quickly the differences between using SQL Server 2008 and Toad for Oracle?

Where can I learn quickly the differences between using SQL Server 2008 and Toad for Oracle?
by

1 Answer

Answer :

answer:The SQL code IS different. Oracle and SQL Server syntax can differ from the ANSI version of SQL. For example, when you write a JOIN in SQL, you MUST use the OUTER JOIN ON syntax, where in Oracle you have the option of just putting using a (+) on the right or left side of the join clause. Toad for Oracle is a tool for Oracle, it’s not the database itself. That being said, if you open the Schema Browser, select your table, and right-click > ER Diagram. That will build an ERD. You can also use the Query Builder to write queries for you by dragging and dropping – just like Access.
by

Related questions

How to solve this problem I have with a restore (backup) file I made in SQL Server 2008?

Description : How to solve this problem I have with a restore (backup) file I made in SQL Server 2008?

Last Answer : try to see if you have volume optimization enabled, it prevents certain changes from happening and really gives the user a hell of alot more trouble than it is worth.

When to use stored procedure and when function in SQL Server 2008?

Description : When to use stored procedure and when function in SQL Server 2008?

Last Answer : There’s no technically right answer here – I think I’d do the SP calling SP.

The most open source DBMS. A) Microsoft SQL Server B) Microsoft Access C) MySQL D) Oracle

Description : The most open source DBMS. A) Microsoft SQL Server B) Microsoft Access C) MySQL D) Oracle

Last Answer : MySQL

The most popular commercial DBMS. A) Microsoft SQL Server B) Microsoft Access C) MySQL D) Oracle

Description : The most popular commercial DBMS. A) Microsoft SQL Server B) Microsoft Access C) MySQL D) Oracle

Last Answer : Oracle

How to learn Ruby on Rail quickly?

Description : How to learn Ruby on Rail quickly?

Last Answer : answer:This may be of help. http://guides.rubyonrails.org/getting_started.html

Why can I not install MS SQL Server Express 2008 R2?

Description : Why can I not install MS SQL Server Express 2008 R2?

Last Answer : Please provide details on what and how it fails the precheck.

In what year was Oracle developed ?

Description : In what year was Oracle developed ?

Last Answer : Oracle was developed in 1986.

I understand what the PL/SQL code below is supposed to do, but when I run the code, it won't compile. Can anybody help with why this is so?

Description : I understand what the PL/SQL code below is supposed to do, but when I run the code, it won't compile. Can anybody help with why this is so?

Last Answer : answer:PL\SQL really isn’t my thing, but I believe you need something between the first IF statement and the ELSIF. What do you want it to do with the number if it is 50 or 90?

Does anyone here have experience working with PL/SQL? I need some help getting started...

Description : Does anyone here have experience working with PL/SQL? I need some help getting started...

Last Answer : answer:PL/SQL is Oracle's take on SQL. It's mostly vanilla SQL, but with some Oracle-specific twists. You need Oracle SQL Developer or something similar. I doubt other relational ... more closely resembling a true object-oriented language, so make sure you get something Oracle-specific!.

What is better: One big SQL query or several?

Description : What is better: One big SQL query or several?

Last Answer : It’s difficult without examples. But what you describe seems like a simple join.

Will using .NET 3.5 server side for a web site place any notable restrictions on what web browers can use the site?

Description : Will using .NET 3.5 server side for a web site place any notable restrictions on what web browers can use the site?

Last Answer : .NET 3.5 VSTS feature won’t restrict you on any navigation features.VSTS is solely browser independent.You could publish your site on any browser, but you need to do some customization while using firefox.Some addin features are needed to make your Server side setup function properly.

Where is the best, most reliable place to purchase Visual Studio 2008?

Description : Where is the best, most reliable place to purchase Visual Studio 2008?

Last Answer : http://www.amazon.com/Microsoft-Visual-Studio-2008-Standard/dp/B000WM1Z46/ref=sr_1_2?ie=UTF8&s=software&qid=1248965173&sr=1-2

How can I quickly and easily shut down all non-essential applications and processes in Windows 7 64bit?

Description : How can I quickly and easily shut down all non-essential applications and processes in Windows 7 64bit?

Last Answer : in before delete system 32

What is the best way to learn how to layout your design images using CSS?

Description : What is the best way to learn how to layout your design images using CSS?

Last Answer : I learnt CSS layout in this tutorial

Is there an advantage to putting the database on a separate database server?

Description : Is there an advantage to putting the database on a separate database server?

Last Answer : answer:It depends on how much traffic you have and how data-intensive it is. Also, read-only requests are a lot lighter on resources than read-write. At the extremes, say you are running eBay ... a second server. If you make the web application modular, changing the data source later is pretty easy.

Can I force my Fedora Server to send an email when booted?

Description : Can I force my Fedora Server to send an email when booted?

Last Answer : Yes. It’s fairly straightforward, too. But what you might want to do is register with a dynamic DNS service like dyndns.org and use something like ddclient to update that automatically.

Free PHP Web Server for Dreamweaver?

Description : Free PHP Web Server for Dreamweaver?

Last Answer : answer:This is probably your best bet for getting PHP, Apache, and MySQL running easily. http://www.apachefriends.org/en/xampp.html It works well on most operating systems. I can't help with Dreamweaver ... add that xampp runs on your computer. No need for a external server. It is great for testing.

What is a web server ?

Description : What is a web server ?

Last Answer : A web server is a special kind of hardware and software that can be used to understand any data stored on that server that can be accessed via the Internet.

High-Performance Oracle SQL Performance Tuning Tools for Databases?

Description : High-Performance Oracle SQL Performance Tuning Tools for Databases?

Last Answer : database configuration monitoring, DBMS hardware configuration (a DBMS and related database may span computers, networks, and storage units) and related database mapping

How many types of Sql Statements are there in Oracle

Description : How many types of Sql Statements are there in Oracle

Last Answer : There are basically 6 types of sql statments.They are a) Data Defination Language(DDL) :: The DDL statments define and maintain objects and drop objects. b) Data Manipulation Language(DML) :: The DML ... e.g:: Using the Sql Statements in languages such as 'C', Open,Fetch, execute and close

What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

Description : What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

Last Answer : Procedures and Functions,Packages and Database Triggers.

Name three clients to connect with Oracle, for example, SQL Developer:

Description : Name three clients to connect with Oracle, for example, SQL Developer:

Last Answer : SQL Developer, SQL-Plus, TOAD, dbvisualizer, PL/SQL Developer… There are several, but an experienced dba should know at least three clients.

Suppose ORACLE relation R(A, B) currently has tuples {(1, 2), (1, 3), (3, 4)} and relation S(B, C) currently has {(2, 5), (4, 6), (7, 8)}. Consider the following two SQL queries SQ1 and SQ2 : SQ1 : Select * From R Full Join S On R.B=S.B; SQ2 : Select * From R Inner Join S On R.B=S.B; The numbers of tuples in the result of the SQL query SQ1 and the SQL query SQ2 are given by : (A) 2 and 6 respectively (B) 6 and 2 respectively (C) 2 and 4 respectively (D) 4 and 2 respectively

Description : Suppose ORACLE relation R(A, B) currently has tuples {(1, 2), (1, 3), (3, 4)} and relation S(B, C) currently has {(2, 5), (4, 6), (7, 8)}. Consider the following two SQL queries SQ1 and SQ2 ... (A) 2 and 6 respectively (B) 6 and 2 respectively (C) 2 and 4 respectively (D) 4 and 2 respectively

Last Answer : (D) 4 and 2 respectively

Differences between Compiler and Interpreter ?

Description : Differences between Compiler and Interpreter ?

Last Answer : 1) The compiler translates the whole program together. But the interpreter reads one line and translates. 2) Both Compiler and Interpreter display program errors. However, the compiler displays the errors ... programs. 6) It takes less time than Interpreter to execute the program through Compiler .

Can someone recommend a good book to learn C# from?

Description : Can someone recommend a good book to learn C# from?

Last Answer : Believe it or not, there is a Dummies Guide to C#, which I found quite straightforward and helpful…

How could I learn programming?

Description : How could I learn programming?

Last Answer : answer:Classes is the best option. I'm sure there's some available where you live, if not, the nearest big town (like what I have to do!) If not, there are tons of helpful guides online ... one and start looking for some deals online, there's always someone selling some in mint condition and cheap!

If I already know basic PHP/MySQL, what else should I learn to use Google App Engine?

Description : If I already know basic PHP/MySQL, what else should I learn to use Google App Engine?

Last Answer : answer:I am not an expert, I just started reading up on this myself, but here are a couple of starting points on data storage. Rather than a separately maintained SQL database, ... .com/appengine/articles/datastore/overview.html http://code.google.com/appengine/docs/python/datastore/overview.html

In what order should I learn web design languages?

Description : In what order should I learn web design languages?

Last Answer : Web design First…River Dancing Second!! Good luck!

Is it hard to learn how to program an iPhone app SDK?

Description : Is it hard to learn how to program an iPhone app SDK?

Last Answer : It’s not difficult, but there’s a lot to learn. If you have no programming experience at all, it will probably take you two to three years of working on it to become reasonably competent.

Out of C++ and C#, which is easier to learn?

Description : Out of C++ and C#, which is easier to learn?

Last Answer : I recommend C#. C++ has a lot of weirdness that C# doesn’t.

Programmers: I'm in the mood to learn a new language. Which one should it be?

Description : Programmers: I'm in the mood to learn a new language. Which one should it be?

Last Answer : Perl. Hubby says it makes business application easier to program.

How did you learn MATLAB, or generically speaking, how did you learn your first programming language?

Description : How did you learn MATLAB, or generically speaking, how did you learn your first programming language?

Last Answer : try using various media approaches, anything on youtube? is there a MATLAB ecosystem that you can tap into? Sometimes you just need repeated exposure to concepts and sometimes you ned a way to put it into practical experience. Like a test tile.

What is the best way to learn AJAX?

Description : What is the best way to learn AJAX?

Last Answer : If you're planning on learning AJAX for creating a websites (like this one), you should probably look into AJAX Libraries... which not only make AJAX easier to approach, but are also a great way to get started, because many have tutorials and documentation.

Want to expand on my marketability as a web developer. What language should I learn?

Description : Want to expand on my marketability as a web developer. What language should I learn?

Last Answer : answer:Recently discussed here: http://www.ask-public.com/disc/2804/whats-the-best-web-programming-language-to-study-right-now/ I’ll answer again, since you already have php, i would look at ASP and Cold Fusion. I also don’t see much demand for Python or Ruby. Not they are bad languages.

What is the best way to learn java?

Description : What is the best way to learn java?

Last Answer : Ditto on that. I also want to know.

What should I learn after HTML?

Description : What should I learn after HTML?

Last Answer : i guess PHP is interesting to learn, but i didn’t like it though..

What programming languages should I learn if I am interested in user interface design?

Description : What programming languages should I learn if I am interested in user interface design?

Last Answer : You need to be more specific. Are you interested in Mac, Windows, Linux, or Web based stuff?

How can I learn to program for cocoa?

Description : How can I learn to program for cocoa?

Last Answer : You need a lot of sparetime and enthusiasm. Have fun!

Why Learn C Programming ?

Description : Why Learn C Programming ?

Last Answer : C' is a medium level language which is not only easy for programmers but also directly controls the computer hardware. The structure structure of the 'C' language is a structured program design ... consists of a core program that calls to different modules. One mole can call another mole again.

How to Learn Programming ?

Description : How to Learn Programming ?

Last Answer : How to Learn Programming Programming is a very advanced computing skill that involves designing, debugging, and testing programs. Programmers create the backbone of every computer program available on the market today ... of programming, a few lines of code can be the start of a great new program.

Is there a way to make a default roaming profile using Server 2008 on a 2003 domain?

Description : Is there a way to make a default roaming profile using Server 2008 on a 2003 domain?

Last Answer : Not too familiar with how roaming profiles look, but I would suggest asking this question on Super User. If you don’t want to go through making an account, I’ll ask it for you and provide you with the answers.

Learning SQL Server 05

Description : Learning SQL Server 05

Last Answer : http://www.sqlcourse.com/

Points to resolve corruption of SQL server database?

Description : Points to resolve corruption of SQL server database?

Last Answer : Often the corruption for the SQL server database can't be resolved. And the best thing one can do is just roll over the past backup. And by that there is going to be certain amount of the data loss. But you have to make use of that instead of losing everything.

what are the features and data management strategies of SQL Server?

Description : what are the features and data management strategies of SQL Server?

Last Answer : SQL is one of the most demanding skill in the current world. Every day a huge amount of data is collected and one have to deal with these databases to make an ... : High Performance High Availability Scalability and Flexibility Robust Transactional Support High Security Management Ease Open Source

How does one use ORADEBUG from Server Manager/ SQL*Plus? (for DBA

Description : How does one use ORADEBUG from Server Manager/ SQL*Plus? (for DBA

Last Answer : Execute the "ORADEBUG HELP" command from svrmgrl or sqlplus to obtain a list of valid ORADEBUG commands. Look at these examples: SQLPLUS> REM Trace SQL statements with bind variables SQLPLUS> oradebug ... oradebug lkdebug -a convres SQLPLUS> oradebug lkdebug -r (i.e 0x8066d338 from convres dump)

Where is a procedure return in an external pl/sql library executed at the client or at the server?

Description : Where is a procedure return in an external pl/sql library executed at the client or at the server?

Last Answer : At the client.

Between Windows Authentication and SQL Server Authentication, which one is trusted and which one is untrusted?

Description : Between Windows Authentication and SQL Server Authentication, which one is trusted and which one is untrusted?

Last Answer : Windows Authentication is trusted because the username and password are checked with the Active Directory, the SQL Server authentication is untrusted, since SQL Server is the only verifier participating in the transaction.

What connections does Microsoft SQL Server support?

Description : What connections does Microsoft SQL Server support? 

Last Answer : Windows Authentication (via Active Directory) and SQL Server authentication (via Microsoft SQL Server username and password). 

Between Windows Authentication and SQL Server Authentication, which one is trusted and which one is untrusted?

Description : Between Windows Authentication and SQL Server Authentication, which one is trusted and which one is untrusted?

Last Answer : Windows Authentication is trusted because the username and password are checked with the Active Directory, the SQL Server authentication is untrusted, since SQL Server is the only verifier participating in the transaction.