Interested to Buy Any Domain ? << Click Here >> for more details...
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
- 0 Answers
- 1003 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
How to recompile a already made trigger?
Can we write create command in the plsql block?if possible how?
What are conditional predicates?
What is the unique index?
How do you take the union of two tables in sql?
What will you get by the cursor attribute sql%notfound?
Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
What is the maximum number of triggers, you can apply on a single table?
Explain uses of cursor.
How to sort the rows in sql.
What are the parameter modes supported by pl/sql?
-
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)
