What are the different types of PL/SQL program units that
can be defined and stored in ORACLE database ?
Answers were Sorted based on User's Feedback
Answer / guest
|Is This Answer Correct ?||3 Yes||0 No|
Answer / pratima
|Is This Answer Correct ?||1 Yes||0 No|
Are views faster than queries?
What normalization means?
State few characteristics of pl/sql?
table name :Tab fields name 1.trx_no (pk) 2.trx_date 3.account code (7 char) 4.account type (1 char) 5.amt Tab contains account code day wise debit and credit transaction , account type fiels can have 2 value D for debit and c for Credit . write a query to display the account code wise total debit and credit bal for the month of april 2004. write a query to display account code wise new amt credit for the april 2004
If we update a complex view, is base table will get update ?
Why you are not able to create a table using select command,if it is having a LONG column? for eg:create table test as select * from test1 here test1 containg a column having LONG datatype...
How will you distinguish a global variable with a local variable in pl/sql?
What is trigger explain with example?
What do you mean by field in sql?
My select statement is not working as expected, So, to overcome from such issues what are the steps needed to be taken care?
What does stand for in sql?
why we use nocopy?