Can we alter stored procedure?
No Answer is Posted For this Question
Be the First to Post Answer
what is the difference between varray and table data type..please expalain with some examples... under what situation you will go for varray..instead of index by table...
How does an execution block start and end in pl sql?
Explain the rollback statement?
Table Student has 3 columns,Student_id,Student_Name & Course_Id. Table Course has 2 columns, Course_Id & Course_Name.Write a query to listdown all the Courses and number of student in each course.
How to return more than one value from a function?
Why do we need a foreign key?
Explain what is an index?
Write a query to get 2nd maximum salary in an employee table ?
69 Answers Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP,
What SQL keyword must immediately follow the UNION ALL statement? 1. SELECT 2. INTO 3. ORDER 4. WHERE 5. JOIN
What are the most important ddl statements in sql?
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?
What are % type and % rowtype?
Oracle (3253)
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)