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 are the tunnig tables you used for tuning a query and tell me some of coloumns in that tuning tables?
What is clause?
Why is nosql good?
Does execute immediate commit?
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
write a query find which rows of a table is updated on 2 days before?
Why do we use function in pl sql?
How do I edit a stored procedure?
What is sql partition?
need to split a string into seperate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,b,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.
What is null in pl/sql?
What is the maximum rows in csv?
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)