Explain the purpose of %type and %rowtype data types with the example?
No Answer is Posted For this Question
Be the First to Post Answer
what is column? : Sql dba
What are the properties of a transaction?
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.
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
What is the source code of a program?
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba
Can we alter stored procedure?
What do you mean by dbms? What are its different types?
How we can update the view?
What is %type in sql?
I need a function for a train ticket reservation please answer it thanks in advance
How to remove duplicate rows from a table?.
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)