What is a procedure in pl sql?
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
Explain the types of joins in sql?
what is switch column,colums cost in oracle?
what are the performance and scalability characteristics of mysql? : Sql dba
a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.
What is the largest value that can be stored in a byte data field?
which types of join is used in sql widely? : Sql dba
What is a left inner join?
HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE.
how view used for security purposes?
What are the steps you take to tune(performance tuning) the code in plsql?
4 Answers Cap Gemini, Infosys, TCS,
What is the difference between a procedure and a function?