How to read/write files from pl/sql?
No Answer is Posted For this Question
Be the First to Post Answer
What is a trigger ?
11 Answers Accenture, BirlaSoft,
type type_name is table of varchar2(30) index by binary_integer for the above type you have to create a identifier... like identifier_name type_name; for the above type you can use the below methods..like first , last , prior, next , delege..etc...like this.. if you create a cursor...like cursor cursor_name is select * from scott.emp; is there any methods like above to use prior, fist , last , next , trim ,etc...
what is primary key? : Sql dba
Explain the difference between drop and truncate commands in sql?
How do you retrieve set of records from database server. {Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }
what is the difference between inner and outer join? Explain with example. : Sql dba
What is difference between select statement and cursor
Are stored procedures faster than queries?
What is nvl?
What trigger means?
how to use case expression? : Sql dba
How many types of index are there?
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)