Does View occupy memory? If we delete the base table of existing view, What happens?
Latest Answer: View just stores the query defination and not the data. if base table or any one table involed with view is dropped we will get this error in 10gORA-04063: view "SCOTT.VEMP" has errors  where vemp is view name ...
Where clause restricts rows, what does having clause restricts ?1. only group results.2. rows results.3. both rows and groups result.
Latest Answer: Hi there,The WHERE clause restricts which rows are returned,while the HAVING clause operates on groups of rows.HAVING is always used with GROUP BY and it must have a function in it and it restrictsThe rule says:- If a condition refers to an aggregate ...
Latest Answer: The columns which are mentioned in group by clause should also be mentioned in select statement except for aggrerations. ...
There is a table having the following columns :-student id marks1 marks2 maxmarks1 10 20 202 25 30 303 30 10
Latest Answer: update tablenameset Maxmarks = case when mark1> mark2 then mark1 else mark2 end ...
Have 2 table Emp1 (Column Name: Ename), 2nd table Emp2 (Column Name: First and Column Name: LastTable Name :Emp1ENameHunt, MichaelGraham, SmithNelson, Ryan Table Name: Emp2First LastMichael HuntSmith GrahamRyan NelsonNeed
Latest Answer: insert into emp2(first,last) (select substr(ename,1,instr(ename,',')-1),substr(ename,instr(ename,',')+1) from emp1) ...
what is difference between nested query,sub query and nested query? explain clearly with an example?
Latest Answer: query inside the query is nested query.
it is also called as sub query.
Correlated subquery runs once for each row selected by the outer query. It contains a reference to a value from the row selected by the outer query.
Nested subquery runs only ...
How can I select column values from a table without knowing the column name ?Suppose , select employee_id from employees , now I don't know the column name and I want to select the column.Please let
Latest Answer: If you do not know the column name you want to select from the table, I would simply suggest you that, follow this command:
SELECT * FROM table_name
here * let you choose all the column name from the respective table. ...
Latest Answer: We cannot insert, update, delete record in dual table.Dual means dummy. In the dual table only one column is present. ...
WE using Last_value()analytical function but the result do not match according to me?
How and in what way REPLACE is different from TRANSLATE?
Latest Answer: Translate check and replace character by character in the string like this
example-
SELECT TRANSLATE('AGDFADCDA ANLKAKE ABZUYA','AG','ZY') FROM DUAL;
here in all three words ('AGDFADCDA ANLKAKE ABZUYA') the character ‘A’ , ‘G’
and ‘AG’ ...
View page [1] 2 3 4 5 6 7 8 9 10 Next >>
Go Top
