Why do we create stored procedures & functions in pl/sql and how are they different?
No Answer is Posted For this Question
Be the First to Post Answer
Why is theta join required?
i have one table with accounts and amounts as colums.accounts with columns c and d. and amounts with values 1000,2000,3000 for c and 4000,5000,8000 for d.i need to find the sum of these accounts c and d individually and find the differences between their sum using one select statement.
What's the difference between a primary key and a clustered index?
what is a control file ? : Sql dba
Is left join inner or outer by default?
what are integrity rules?
What is sql character function?
If we declare constraints Unique and Not null on a single column then it will act as a Primary key, so what is the use of primary key??
What is memory optimized?
what is the cursor and use of cursor in pl/sql ?
Find out the 3rd highest salary?
51 Answers BirlaSoft, DAC, Silvia Infotech, Sutra Infotech,
how are rank and dense rank being alloted for column with same values over a particular column
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)