1> how are u debugging in plsql ?
2> how to connect oracle database from unix. is there ne
way other than using sqlplus ?
Answers were Sorted based on User's Feedback
Answer / gourvendra singh
1> we can do the debugging in the plsql by placing the
message in the code, so that we can trace the values and
pointer in the pl/sql.
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / guru
hi friends click below link to see Debugging in Plsql
http://www.adp-gmbh.ch/ora/plsql/debug.html#dbr
| Is This Answer Correct ? | 1 Yes | 2 No |
what is collation? : Sql dba
What are the string functions in sql?
What is compilation error in pl sql?
one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows only how should u write query?
What is the order of sql select?
How can a pl sql block be executed?
Is full outer join same as cross join?
How do you create an update query?
How do rank () and dense_rank () differ?
write a query to display diference between two dates in sql server
Which command is used to delete a package?
Does inner join remove duplicates?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)