Interested to Buy Any Domain ? << Click Here >> for more details...
After using set unused can we enable the column again to use? Please give me some answers....
1 4810i 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... Prakash
2 10263Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
1987SQL> 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 4440How 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?
2827Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
2270Post New Oracle General Questions
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
What is a proxy class?
What is a database table in oracle?
How to execute a stored procedure in oracle?
What is varray?
Explain oracle 12c new features for developers?
State and explain the different types of data models?
What are named parameters?
How to create lov dynamically at runtime & attach to text field?
In what script is snap$ created? In what script is the scott/tiger schema created?
What operating systems are supported by oracle database 10g xe?
What is oracle open database communication (odbc)?
How will you write a query to get a 5th rank student from a table student_report?
What are the different oracle database objects?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
