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 |
when a procedure /package is getting invalidated?
Can you call pl/sql package functions from within a fast formula?
define data blocks ? : Sql dba
Define overloaded procedure?
Is it possible for a table to have more than one foreign key?
define sql update statement ? : Sql dba
What is scalar data type in pl sql?
How to fetch common records from two tables?
What is clustered index in sql?
What are the sql commands?
Which language is used in 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?
Oracle (3259)
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)