what are rollup and cube in t-sql? : Transact sql
No Answer is Posted For this Question
Be the First to Post Answer
how can we replace the particular column value of a resulted set of executed query? I mean write down a sql query to chane the particular column's value of a resulted set of executed query
I want to know the difference between A Record Type and a Table.
how to convert numeric values to character strings? : Sql dba
give the syntax of grant and revoke commands? : Sql dba
I am creating an index on Emp table Empno column,if u using this indexed column in ur SELECT stmt. where clause,then how do u know that yr index will be working or nor? Thanks Advance...
Why do we need cursors in pl sql?
What is the difference between subquery and correlated query?
What are the types of records?
What is sql deadlock?
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.
how to include character strings in sql statements? : Sql dba
Give the structure of the function ?
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)