is it mandatory to select all the column in a view then what
columns should be selected
- 2 Answers
- 5406 Views
- I also Faced
- E-Mail Answers
Answer Posted / guest
No, Its not mandatory.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Why is the cursor important?
what is a database? : Sql dba
How do I partition a table in sql?
What is row_number () in sql?
What is a file delimiter?
What found sql?
What does closing a cursor do?
Why function is used in sql?
How to know the last executed procedure?
What is AUTH_ID and AUTH_USER in pl/sql ?
write an sql query to find names of employee start with 'a'? : Sql dba
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
How can we solve sql error: ora-00904: invalid identifier?
First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.
What is a sql*loader control file?
