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 |
a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.
What is sql partition?
Does truncate need commit?
How many types of relationship are there?
What is the relation b/w view and trigger
What are the types of operators available in sql?
What is difference between sql and mysql?
Explain ttitle and btitle.
What are primary key and foreign key and how they work?
How to run pl/sql statements in sql*plus?
Can a table have no primary key?
What is case function?
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)