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 is null value?
What is the purpose of a cluster?
Can you drop an index associated with a unique or primary key constraint?
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?
Is a rollback possible to any savepoint?
How index is implemented in oracle database?
What are the uses of linked server and explain it in detail?
How do I escape a reserved word in oracle?
How can we Update a table with out using UPDATE command?
Explain oracle’s system global area (sga).
16. Display the order number, order line number and the shipping date. If the shipping date is null, display the string <not shipped yet>.
write a sql query following source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want the output column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c