What happens internally when the user types
userID/password@string in SQL PLUS
Thanks-Bhaskar
- 2 Answers
- 4753 Views
- Oracle, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / Komal Devi
When a user enters 'username/password@string' in SQL**Plus, the '@string' part is typically ignored by the system. The username and password are sent to the database server for authentication purposes.
| Is This Answer Correct ? | 0 Yes | 0 No |
how many types of index?
What is oracle datasource?
what are pseudocolumns?
How to connect to oracle using service name instead of sid?
What are the oracle differences between nvl and coalesce
Explain the blob datatype?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
i have a table with 1 lac of data.i want to insert this data into another table. i want every 5000 of data insert use a commit.using counter and if error is comming in the 5000 of data it rollback.
What are privileges and grants?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
What is the dynamic sql in oracle?
what are the diffeenes between oracle 9i,oracle 10g
Oracle General 
