What are different types of statements supported by sql?
A table was given with 3 columns like Manager id,Manager Name and Employee name. Question was to create hierarchy.
Types of indexes. What is the default key created when a primary key is created in a table ?
what are null values? : Sql dba
Differentiate between % rowtype and type record.
What is procedure and function?
What is a constraint?
What is pragma in pl sql?
Inline the values in PL/SQL, what does it mean.?
Is record in oracle pl sql?
What is mutating error in pl sql?
i have one table with accounts and amounts as colums.accounts with columns c and d. and amounts with values 1000,2000,3000 for c and 4000,5000,8000 for d.i need to find the sum of these accounts c and d individually and find the differences between their sum using one select statement.
What is bind variable in pl sql?