Interested to Buy Any Domain ? << Click Here >> for more details...
how are rank and dense rank being alloted for column with same values over a particular column
- 1 Answers
- 2492 Views
- I also Faced
- E-Mail Answers
Create a procedure to delete certain records from a table and display the total number of records deleted in this process. (Condition for deletion can be of ur choice, for instance delete all records where eid='')
What is pessimistic concurrency control? : Transact sql
What is scalar data type in pl sql?
Why we use stored procedure instead of query?
what is mean by forward declaration and where we'll use it.
What is the difference between pl and sql?
What is the difference between distinct and unique in sql?
What is the difference between partitioning and sharding?
what is uncommittable transactions? : Transact sql
What is the usage of nvl function?
I have one Excel file with 1,50,000 Records. Now I need to load that whole file into Oracle Database with same columns in Excel sheet . I need PLSQL Procedure or used by SQL PLUS
I have a package in which a table was used in a procedure and compiled later i have dropped the table used in the package what would be the status of package specification and body
-
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)
