Can we write ddl statements in functions?
No Answer is Posted For this Question
Be the First to Post Answer
What are nested triggers ?
6 Answers Amazon, Appeal Soft, IBM, Infosys, TCS,
What is minus?
i have doubt that any one tell ref cursor comes in sql pl/sql? pls clarify?
how to write utl file pkg in SQL
What is group function in sql?
Explian rowid, rownum? What are the psoducolumns we have?
How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from <table_name>; except this you can't use another select statement. You can use no of variables as per requirement.
How to return an array from java to pl/sql?
How is indexing done in search engines?
What is the size of partition table?
In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join.
What is the current version of postgresql?
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)