What is meant by SQL,PL/SQL,SQL PLUS?
Is there any differnece between them?
- 2 Answers
- 7750 Views
- HSBC, I also Faced
- E-Mail Answers
Answer Posted / naresh kumar
sql: It is a structured query language, using this we can
use the DataBase for storing the data or retriving the data.
PL/SQL: It is a programing language with structured query
language. hear we wrote queries in programing type.
sqlplus:SQLPLUS is a tool used to connect the DataBase. SQL
and PL/SQL languages are connect with Oracle DataBase using
this tool. This Tool understands three catogories of text
1.SQL-statements,2.PL/SQL-Blocks and 3.SQL*PLUS internal
commands like "set","show".
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Please describe an example where you used object orientation in one of your programs.
how does database connection using ADO.NET?
I need to fetch all rows from the table based one field value in the table and later do a condition check if the condition is true I will have to move all the rows present in the data base to output file one else if the condition is not satisfied then move all the records of that field value into another file .Please let me know how to do that
What is easiest way to get the PL/i compiler,I didn't have found the compiler in my library. Is there any extra cost if we want to access the PL/1 programs?Actually we r having Mainframe rented training Ids
Delta 5 weight scale not connect with oracle application what i can do?
1. How many jobs can we write in a single file? 2. How many maximum members can exist in a single partition data set(pds) in jcl?
Do not use more than 3 nested IF. Use Evaluate statement in case of more IF required. Please give a detail explantion besides readability and clarity for Evaluate stmt.
what are all the validation we need to perform in data stage?
code for connection from windows forms to sql server
Given a cube of size n*n*n (i.e made up of n^3 smaller cubes), find the number of smaller cubes on the surface. Extend this to k-dimension.
how sap is different from other software ?
5. Which of the following can you do with DB2 Express- C? Query databases with SQL Query databases with XML using XQuery and XPath Use SQL in Xquery and Xquery in SQL All of the above
How to call dll API sub routine in VB Form.
A good website has the following conditions It should be interactive. It should contain at least 20 images. Title cannot be null and should contain at least 10 letters other than spaces and hyphen (-). The keywords should contain atleast three among the following list : "design", "Graphics", "lovely", "beautiful", "amazing" and "mesmerising" Write a method: boolean isGoodWebsite(boolean isInteractive, int numOfImages, String title,String keywords[]) isInteractive whether the site is interactive or not numOfImages Number of images on the website title Title of the website keywords Array of keywords in the website.
what are other resources are needed for this mantis?
