what is the difference amongSQL,SQL PlUS,ORACLE nd PLSQL?

interact with the database. You can write queries SELECT, manipulate objects DDL and data DML with SQL. However, SQL doesnt include all the things that normal programming languages have, such as loops and IF...THEN...ELSE statements....these all things r the part of oracle languge...........which combines to make oracle complete.........in sql we can only exectue queries...and in pl/sql we can make porgams like c or c plus

why global partitioning are use in SQL?????

prepare to query the view that we created in last months article by using the following script to populate the Orders view with all the rows from the Orders table in the Northwind database:One common technology and demonstrated how to set up and modify the views. In this article, we demonstrate how to query distributed partitioned views. We show you the execution plans for various queries so you can see

what is SQL

shashi SQL Structured Query Language pronounced /skjul / officially, although the nonstandard pronunciation /sikwl/ is often used see below, is a database computer language designed for the retrieval and programming language for querying and modifying data and managing databases. Although SQL is both an ANSI and an ISO standard, many database products support SQL with proprietary extensions to the standard

can anyone tell me what is search engine? How it works?

in each document. Each search engine uses a proprietary algorithm to create its indices such that, ideally, only meaningful results are returned for each query. How a Search Engine Works ?Search engine search the Web, or an intranet, or a database. Actually consumers would really prefer a finding engine, rather than a search engine.Search engines match queries against an index that they create. The index

Which component of RDBMS in sql validiates the syntax of users query?a. query parserb. database managerc. database administratord. query optimization?

what is Java JDBC?

hi fzail Java Database Connectivity JDBC is an API for the Java programming language that defines how a client may access a database. It provides methods for querying and updating data in a database activities:1. Connect to a data source, like a database2. Send queries and update statements to the database3. Retrieve and process the results received from the database in answer to your queryThe following

Where to write custom sql queries in crystal reports. Server is Sql 2005?

Well Himali , here are some tips for writing SQL queries in Crystal Reports.1. Use Crystal when you have your query tuned regardless how good Crystal Reports is - it is reporting tool - not querying environment. Tune your query first and be sure that you are pulling the right data.2. Use SQL Server Linked Servers. Use professional tool, such as Microsoft SQL Server, where you can create linked servers

How to transfter XML data including GUID into tally

;Ledger" tableStep 4: Write a SQL-query to fetch data from Ledger table of "scdatabase" as given below:-SQL-query<SQL.L IST><SQL> SELECT name AS name,parent FROM ledger <Ledger" tableStep 4: Write a SQL-query to fetch data from Ledger table of "scdatabase" as given below:-SQL-query<SQL.L IST><SQL> SELECT name AS name,parent FROM ledger <

how to find the serial no of the hard disk?

, and the serial number is found in Win32PhysicalMedia class, thus we need to query twice and integrate the information into our HardDrive class.Lets first create an ArrayList to store our HardDrive objectsArrayList hdCollection = new ArrayList; Next, we query the Win32DiskDrive class first: ManagementObjectSearcher searcher = new ManagementObjectSearcher"SELECT FROM Win32DiskDrive"; foreach

Hi Alok Gupta, this is khursheed from Hyderabad. I just wanted to ask you, why im not getting blog bonus even thow im at master level ?

I dont have much idea about Blogging as I dont write blogs here in ibibo.You can also do one thing, ask the same query to ibibo team, they will give you a better answer.Click on the link / option Contact us" option. It is there in your home page my home A new window will open with all details.Write your query and send it to ibibo team.They will revert back to you shortly....no one is getting

Hi Alok Gupta, this is khursheed from Hyderabad. I just wanted to ask you, why im not getting blog bonus even thow im at master level ?

You can also do one thing, ask the same query to ibibo team, they will give you a better answer.Click on the link / option Contact us" option. It is there in your home page my home A new window will open with all details.Write your query and send it to ibibo team.They will revert back to you shortly....well, You can also do one thing, ask the same query to ibibo team, they will give you a

Hi Alok Gupta, this is khursheed from Hyderabad. I just wanted to ask you, why im not getting blog bonus even thow im at master level ?

You can also do one thing, ask the same query to ibibo team, they will give you a better answer.Click on the link / option Contact us" option. It is there in your home page my home A new window will open with all details.Write your query and send it to ibibo team.They will revert back to you shortly....well, You can also do one thing, ask the same query to ibibo team, they will give you a

What do you mean by Correlated subquery?

Subqueries, or nested queries, are used to bring back a set of rows to be used by the parent query. Depending on how the subquery is written, it can be executed once for the parent query or it can be executed once for each row returned by the parent query. If the subquery is executed for each row of the parent, this is called a correlated subquery. A correlated subquery can be easily identified

What is a query?

SQL Structured Query Language pronounced /skjul / officially, although the unofficial pronunciation "sequel", /sikwl/, is often used see below, is a database computer language designed interactive and programming language for querying and modifying data and managing databases. Although SQL is both an ANSI and an ISO standard, many database products support SQL with proprietary extensions

What is meant by query optimization?

Queries of a database can be fast or slow. Depends on a lot of things. The size of the table, the amount of data you are requesting from the query, etc.One of the ways a dba can help query optimization, is by "updating statistics" on a table. Statistics of a table allows the query to find the most efficient way to gather the data from the table.http://wiki.answers.co m