Interested to Buy Any Domain ? << Click Here >> for more details...
What is meant by SQL,PL/SQL,SQL PLUS?
Is there any differnece between them?
- 2 Answers
- 8428 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
What are two of your strengths that you will bring to our QA/testing team?
is it possible to learn sap from book without any tutorial. if yes please mention the beginner,s book of sap and also make your valuable advice for self study of sap .
what are importance in problem tracking
What is the purpose of
Is buffer size and file block size is similar? If similar,at which case it will be same size?
1.what is the vesition managment.
what is an INI file?
Define Form modules, Class modules and Standard modules
SELECT A~FTRMI A~AUFNR B~MATNR D~MAKTX B~PSMNG B~WEMNG C~MTART E~CHARG C~MATKL C~SPART R~BWART R~CHARG R~MATNR E~BWART R~BDMNG INTO TABLE ITAB FROM AFKO AS A INNER JOIN AFPO AS B ON A~AUFNR = B~AUFNR * INNER JOIN AFVC AS A1 ON A~AUFPL = A1~AUFPL AND B~DWERK = A1~WERKS INNER JOIN MARA AS C ON B~MATNR = C~MATNR INNER JOIN MAKT AS D ON C~MATNR = D~MATNR INNER JOIN MSEG AS E ON B~MATNR = E~MATNR AND A~AUFNR = E~AUFNR AND B~DWERK = E~WERKS INNER JOIN RESB AS R ON A~AUFNR = R~AUFNR AND E~AUFNR = R~AUFNR AND R~RSNUM = A~RSNUM AND R~WERKS = E~WERKS AND R~BAUGR = E~MATNR INNER JOIN MARA AS C1 ON R~MATNR = C1~MATNR WHERE A~FTRMI IN S_DATE AND A~AUFNR IN S_AUFNR AND C~MTART IN S_TYPE AND C~MATKL = 'T' AND R~BWART ='261' AND E~BWART = '101' AND R~XWAOK ='X' AND B~DWERK = '2000' AND R~XLOEK EQ SPACE AND E~KZBEW ='F' AND D~SPRAS = 'E' AND R~KZEAR = 'X' AND C~MATNR IN S_MATNR. This query gives repetative records from RESB.There must be some common field which i am not taking thats why its giving repetative records. If u find any solution pls lety me know ASAP. Thanks Swati Ghadge
Wrtite a JCL for sorting a file with start from 36 postion lenth 9 excluding a num eq to 98768. for 3 marks mainframe
can we use commit,rollback in triggers and how?
what is the difference between rename and label
Iam using Microsoft Visual Studio to create a system for mobile store I want to know how to calculate mobile price that the customer buy and how to reduce quantity from the data base that we have for mobile .And also how to calculate revnue for each mobile and revnue for the total mobile
how much fee for deccan soft institute .how to block seat for sandeep sir class reply soonnnnÂ
what is the difference between read the data from table and infotype
