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
- 8292 Views
- HSBC, I also Faced
- E-Mail Answers
Answer Posted / sravan 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 ? | 48 Yes | 6 No |
Post New Answer View All Answers
1.how to deploy the Maven application in weblogic server? 2.In Real time projects all classes are singleton or some classes only singleton explain? 3.what are the major uses of the designpatterns? 4.explain restful &Soap based services explain?
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
Diff between IF and where ?
What do you understand by modular programming?
Suppose we are doing 4 operations on database using service, first operation is successful but due to some reason remaining 3 operations are failed. I) is this transaction successful or not? ii) How can you give that error message to user?
Write a program to reverse a number?
how do i create my own exception class which will restrict IO exception?
what are importance in problem tracking
we create a pf with 3 fields.2 is defined as keyfields.we lock it with alcobj command.how we find out whether the file is locked or not?is it dspfd??/
what is the difference between uservariables and systemvariables (in Environmental variables)???
can we allocate memory for interface? if no then why?
how do we provide security for web services
Difference between views and index in sas programming
what is client server & server? What r types of Joins? explsin it! which types of indexex in sql server? what is triggers?
< No Frames > tag is used for
