What happens internally when the user types
userID/password@string in SQL PLUS
Thanks-Bhaskar
Answer / sudipta santra
It will give the error. Unknown command.
You should give as follows:-
connect userID/password@string
Then it will connect to that instance under this user area.
Is This Answer Correct ? | 3 Yes | 1 No |
How does Oracle guarantee data integrity of data changes?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
What is a trigger and what are its types?
How to make a Data Backup in oracle ? What is the procedure for creating the dump files in oracle ( any version ) ?
Can a primary key contain more than one columns?
How will you differentiate between varchar & varchar2?
Can a formula column referred to columns in higher group ?
What is Normalization ?
55 Answers ACS, Genpact, Graphix Solution, IBM, Keane India Ltd, TCS, Vault,
Is it possible to join two tables, that are in two different users (e.g. SCOTT and HR etc.),but im same database (e.g. ORCL)? If yes, then how it is possible? Explain with step by step procedure.
What do you mean by group by clause?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
I have created one package with out procedures in package specification and in package body i have used 2 procedures. is it compile????