After using set unused can we enable the column again to use? Please give me some answers....1 3366
what is the difference between no rows returned and null returned?2 3577
how to genarate random numbers in oracle for particular row?3 5423
i can't insert column value greater than 4000 characters at one instance even i am using CLOB datatype . how to insert efficiently more than 4000 characters ? And please let me know how to impose inline and out-of line constraints on oracle column??? Thanks in Advance... Prakash2 7935
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?1141
SQL> CREATE TABLE to_table 2 (col1 NUMBER); Table created. SQL> CREATE OR REPLACE TRIGGER statement_trigger 2 AFTER INSERT ON to_table 3 BEGIN 4 DBMS_OUTPUT.PUT_LINE('After Insert Statement Level'); 5 END; 6 / Trigger created. SQL> CREATE OR REPLACE TRIGGER row_trigger 2 AFTER INSERT ON to_table 3 FOR EACH ROW 4 BEGIN 5 DBMS_OUTPUT.PUT_LINE('After Insert Row Level'); 6 END; 7 / Trigger created. SQL> INSERT INTO TO_TABLE VALUES(1); After Insert Row Level After Insert Statement Level 1 row created. SQL> BEGIN 2 INSERT INTO TO_TABLE VALUES(2); 3 INSERT INTO TO_TABLE VALUES(3); 4 INSERT INTO TO_TABLE VALUES(4); 5 INSERT INTO TO_TABLE VALUES(5); 6 INSERT INTO TO_TABLE VALUES(6); 7 INSERT INTO TO_TABLE VALUES(7); 8 INSERT INTO TO_TABLE VALUES(8); 9 INSERT INTO TO_TABLE VALUES(9); 10 INSERT INTO TO_TABLE VALUES(0); 11 END; 12 / WAT LL BE THE O/P??? XPLAIN IT>>>>1 2722
interview questions with answer for cts1562
What is the difference between alert log file and trace file ?1 23313
What is the difference between alert log file and tarce file ?
How many memory layers are in the shared pool?1 3494
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?1929
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?1368
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
what are archived logs?
Where do you use decode and case statements?
What is the usage of analyze command in oracle?
How to delete a column in an existing table?
How to drop a tablespace?
What happens to indexes if you drop a table?
What is the quickest way to fetch the data from a table?
Give the various exception types.
How to invoke the data pump export utility?
what is the dual table in oracle?
What are the numeric comparison operations?
Is there a function to split a string in plsql?