Interested to Buy Any Domain ? << Click Here >> for more details...
Can you have multiple SPs with the same name on a database?
- 6 Answers
- 12282 Views
- CGI, I also Faced
- E-Mail Answers
Answer Posted / baba
When we create a stored procedure,if db object already
exists we will get a message that
ERROR at line 1:
ORA-00955: name is already used by an existing object
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
Difference between truncate, delete and drop commands?
What are the types of join in sql?
What are sql ddl commands?
What is left inner join in sql?
What are actual parameters and formal parameters?
How to select unique records from a table?
How do you go back in sql?
How to rename a column in the output of sql query?
How to use sql statements in pl/sql?
what are date and time data types? : Sql dba
What is a primary key called that is made up of more than one field?
how to use in conditions? : Sql dba
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
What are the possible values for the boolean data field?
what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba
