what are the advantages and disadvantages of views in a database? : Sql dba
No Answer is Posted For this Question
Be the First to Post Answer
What is primary key secondary key alternate key candidate key?
What are the modes of parameters that can be passed to a procedure ?
Is pl sql useful?
What is the plv (pl/vision) package offers?
What is a cursor for loop ?
how to convert character strings to dates? : Sql dba
Explain the structure of pl/sql in brief.
Why do we use sql constraints?
How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from <table_name>; except this you can't use another select statement. You can use no of variables as per requirement.
Can we use update in sql function?
What is sql scripting?
What is difference between inner join and self join?
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)