what is host string in sql plus? how does it related to
database?
Answer / sudipta santra
Host string is the instance name of the database in the server.
when we are using sqlplus then we use to give the
username/password@<hostname>
It relate the user as a connectivity with that specified
instance.
Is This Answer Correct ? | 4 Yes | 1 No |
What are the uses of linked server and explain it in detail?
how to create a new database in oracle?
How is it different from a normal table?
what is the use of composite key constraint?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
Is rowid unique in oracle?
How to create index-by table in oracle?
How to use "in out" parameter properly?
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3 Answer:select length(trim('ram charan singh')) - length (replace (trim ( 'ram charan singh'),' ','')) +1 from dual The above query working properly when space between the words is only one &similar But ,If the space between the words is nonuniform. Ex:'ram charan singh is good' ans:5 i am not getting this answer using above query.
How to update rows in table, suppose i have lacks of rows in table how to update total table with update statement. Can u please any one answer this question with update statement.
what is difference between foreign key and reference key
Explain the different normalization forms?