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
What is the max nvarchar size?
Is inner join same as self join?
what is 'mysqladmin' in mysql? : Sql dba
What does over partition by mean in sql?
Can procedure in a package be overloaded?
What is intersect?
In a distributed database system, can we execute two queries simultaneously?
How many types of cursors are available in pl/sql?
2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A Full outer join ( select 1 B from dual Union select 2 B from dual)B On A.A=B.B
using cursors salesman get bonus as 10% of their salary , managers get 20% , analalist get 30%. generae a report showing the employee name, salary , bonus.
how can i read files from a pl/sq l program
Why query optimization is needed?
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)