what is oracle sql,pl/sql with interfaces
Answers were Sorted based on User's Feedback
How does rowid help in running a query faster?
How do I add a primary key to a table?
What are the modes of parameters that can be passed to a procedure ?
What is the difference between truncate and drop statements?
What are the benefits of stored procedures?
how can we know the count/number of elements of an array? : Sql dba
I have a table with 1 million records out of which 10,000 records are of unique records, then if I will implement index, then which type of index shall I use and why shall I use?
Can you have a foreign key without a primary key?
What is the syntax and use of the coalesce function?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
Can i use Commit inside the Trigger? Suppose i use commit what will be happy (it's complied /executed/work)
how to fetch alternate records from a table? : Sql dba
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)