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 to get the second max val for every group in a table
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.
What is currency type in database ?
How do I manually uninstall oracle client?
Why required to run root.sh at the time of installation and what exactly it will do
How to define an anonymous block?
State and explain about oracle instance?
How can you merge two tables in oracle?
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
How to delete a column in an existing table?
What happens to the indexes if a table is recovered?
Explain about functional dependency and its relation with table design?