You have EMP and dept table .how do you get the entire department and corresponding employee details and the department which are not alloted it?what is referential integrity constraint?wat is triggers,stored procedures,stored functions explain with examples
I have a table with a column city. The values are “delhi” and “hyderabad”. I need to update Hyderabad with delhi and delhi with Hyderabad. Define a query for that
Latest Answer: Hi All,A Schema in oracle is a logical representation of all the Oracle objects owned by a user.To make my explanation simpe , let me give an example.Let's say you own a bike, a computer, mobile. Now all these articles owned by you collectively is called ...
Latest Answer: when a join condition is omited when getting result from two tables then that kind of query gives us Cartesian product, in which all combination of rows displayed. All rows in the first table is joined to all rows of second table...... ...
Latest Answer: A join view is defined as a view that has more than one table or view in its FROM clause (a join) and that does not use any of these clauses: DISTINCT,AGGREGATION, GROUP BY, START WITH, CONNECT BY, ROWNUM, and set operations (UNION ALL, INTERSECT, and ...
Latest Answer: This is how the index works in simple terms. When you add a row to a table, the rowid of that row plus a few other info is store in a separate area which is dedicated to keep it. Lets say you define a unique index. When you insert a valid row, the ...
Latest Answer: select count(*) from all_users; ...
Latest Answer: subquery : returns value to main query. it wont get values from main query. Example: SELECT id "Emp #" First_name "Name" salary "Salary" ROWNUM rank FROM (SELECT id first_name salary FROM employee ORDER BY salary); corelated ...
How do i get Greatest salaray of dept group from emp and dept?we have to tables EMP and DEPT. for exp: dept 10 have 10000,dept 20 have 5000 and dept 30 have 15000 salaries, i need dept 30 group salary(means sum of that group is 15000).
When i write the following program, i am getting error like: DECLARE vInHandle UTL_FILE.file_type; vNewLine VARCHAR2(250); BEGIN vInHandle := UTL_FILE.Fopen ('D:', 'new.txt', 'R'); LOOP BEGIN UTL_FILE.get_line(vInHandle, vNewLine); dbms_output.put_line(vNewLine); END; END LOOP; UTL_FILE.fclose(vInHandle); END; Error:-DECLARE*ERROR at line 1:ORA-29280: invalid directory path ORA-06512: at "SYS.UTL_FILE", line 18 ORA-06512:
View page << Previous 3 4 5 6 [7] 8 9 10 11 12 Next >>
Go Top
