How to add a primary key to a table that is not having any primary key?How to display the Date of birth from a table in the dd-mm-yyyy format?
What is Locking? Explain types of Locking? Explain example of Locking? What is database link? Explain types of database link? Explain example of database link?
Latest Answer: To process an SQL statement, a DBMS performs the following five steps: The DBMS first parses the SQL statement. It breaks the statement up into individual words, called tokens, makes sure that the statement has a valid verb and valid clauses, and so on. ...
Latest Answer: hi,select sno,sname,(case when total>50then 'good'when total>35 and total
Latest Answer: SELECT BYTES/1024 FROM DBA_EXTENTS WHERE OWNER = 'SCOTT' AND SEGMENT_NAME = 'EMP'; This will return you size of table in Kilo Bytes. User is Scott and Table ...
A table has one varchar2, one clob, one blob data typeHow many segment will be created in the table?
I tried "truncate table cascadebut I got the error storage keyword is missing (says either drop storage or reuse storage) Can any one help me out.
Latest Answer: if u want to delete a table with constraints i think u need to first disable the constraints on the table and the use truncate table ;alter table disable constraint primary key cascade; ...
If your answer is yes, explain the steps.
Latest Answer: Yes we can.create or replace trigger trg_testbefore insert on empbeginnull;end;create synonym trg_syn for trg_test; ...
For example::In a table Table1, I want 2 make the column "Column1" as primary key and I want the first letter must start with 'S'
Latest Answer: i guess it would work if u add a check constraint as follows:constraint check (column1 like 's%'); ...
View page << Previous 4 5 6 7 [8] 9 10 11 12 13 Next >>
Go Top
